Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

javaÎļþÁ¬½ÓmysqlÊý¾Ý¿âÂÒÂë - Java / Eclipse

ÏÖÔÚÕâ¸öÎÊÌ⻹ûÓнâ¾ö£¬ÎÒÔÚmyeclipseÖÐjdbcÁ¬½ÓmysqlÊý¾Ý¿â£¬ºóÀ´×öÁËÊý¾Ý²âÊÔ£¬É¾³ý£¬²éѯµÃµ½µÄÊý¾ÝºÜÕý³££¬µ«ÊÇ£¬²åÈëÊý¾Ý£¬Ö»ÒªÓÐÖÐÎÄ£¬ÓÀÔ¶¶¼ÊÇÂÒÂ룬°üÀ¨¸üÐÂÊý¾Ý£¬Ò²ÊÇÂÒÂë¡£¿´ÁËÍøÉÏ´ò´óƪµÄµÄÈçºÎ¸Ä£¬ÎÒ¶¼¸ÄÁË£¬¿ÉÊÇ»¹ÊDz»ÐС£Õâ¸öÎÊÌâ¿àÄÕËÄÌìÁË¡£ÕæÊǹ»·³È˵ġ£»¹ÇóÓÐÄÜÁ¦µÄ¸ø¸ö»Ø´ð¡£Ëµ·çÁ¹»°£¬ºÍ˵Á˵ÈÓÚûÓÐ˵µÄÇë±ðÀË·ÑÐÄÇé¡£
ÏÂÃæÌṩ×ÊÁÏ¡£
Õâ¸öÊÇÁ¬½ÓjdbcµÄURL
import java.sql.*;
public class ConnectionManager {
private static final String DRIVER_CLASS="com.mysql.jdbc.Driver";
//url="jdbc:mysql://localhost:3306/examonline?useUnicode=true&characterEncoding=GBK"

private static final String DATABASE_URL="jdbc:mysql://localhost:3306/newsdb";
private static final String DATABASE_USER="root";
private static final String DATABASE_PASSWORD="3022103";
public static Connection getConnection()
{
Connection dbcon=null;
try {
Class.forName(DRIVER_CLASS);
dbcon=DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return dbcon;
}
PS Á¬½ÓÍêÈ«Õý³££¬Ã»ÓÐÒ»µãÎÊÌâ¡£
ÏÂÃæÊÇÎÒÔÚmysql´´½¨Êý¾Ý¿âÒÔ¼°²åÈëµÄÊý¾ÝÖµ£¬Ò²Ã»ÓÐÎÊÌâ¡£
CREATE DATABASE newsdb;
USE newsdb;
DROP TABLE IF EXISTS FristTitle;
CREATE TABLE FristTitle(id INT UNSIGNED NOT NULL AUTO_INCREMENT,
FristName VARCHAR(50) NOT NULL,
creator VARCHAR(50) NOT NUL


Ïà¹ØÎÊ´ð£º

JSP ½ÓÊÕ FORM Ìá½» - Java / Web ¿ª·¢

Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼ 
È» ......

myeclipse+mysqlµÄÅäÖÃÎÊÌâ - Java / Eclipse

ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ­°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......

javaÖд«Öµ - Java / Web ¿ª·¢

¾ÍÊǼòµ¥µÄ´«ÖµºÍȡֵ
ÇëÎÊÂ¥Ö÷ÏëÎÊʲô£¿

jspÒ³Ãæ²ÉÓÃ±íµ¥»òÕßjavabean´«Öµ¶¼¿ÉÒÔ£¬Ê¹ÓÃrequest.getParameter()»ñµÃʹÓÃ±íµ¥´«¹ýÀ´µÄÖµ¡£

ÎÊÎÊÌ⣬ÏȰÑÎÊÌâ˵Çå³þµã£¡£¡ ÎÊÌâ̫ģºý£¡£¡

ÎÊÎÊÌ⣬ÏȰÑÎ ......

javaÖд«Öµ - Java / Web ¿ª·¢

ÔõôÑù½«id´«¹ýÈ¥°¡£¿£¿£¿ÊǼòµ¥µÄ´«¡£¡£¡£ÔÚµØÖ·À¸ÖÐдidºÅ
LZ ºÃÓÄĬ£¡²»ÖªµÀÄãµÄÒâ˼£¿

ÊÇÏë°ÑID ´«µ½ACTION ? ͨ¹ýURl id=?

²»¹»Ïêϸ ±ðÈ˲»ÖªµÀÔõÑù°ïÄã

../XXXXX.do?id=XXXX&id2=XXXXX

......

mysqlµÄ¸üÐÂÓï¾ä - Java / Java SE

id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ