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
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
¾ÍÊǼòµ¥µÄ´«ÖµºÍȡֵ
ÇëÎÊÂ¥Ö÷ÏëÎÊʲô£¿
jspÒ³Ãæ²ÉÓÃ±íµ¥»òÕßjavabean´«Öµ¶¼¿ÉÒÔ£¬Ê¹ÓÃrequest.getParameter()»ñµÃʹÓÃ±íµ¥´«¹ýÀ´µÄÖµ¡£
ÎÊÎÊÌ⣬ÏȰÑÎÊÌâ˵Çå³þµã£¡£¡ ÎÊÌâ̫ģºý£¡£¡
ÎÊÎÊÌ⣬ÏȰÑÎ ......