eclipseè¿æ¥mysqléè¦å¯¼å ¥mysqlç驱å¨å ï¼æ´çæ¬æ å ³ã
é ç½®ä¹å请å ä¸è½½mysql-connector-java-5.1.15-bin.jaræ件ã
å³é®åå»å æå¨çå·¥ç¨å ï¼projectï¼ï¼Build Path ---> Configure Build Pathï¼å¨å¼¹åºççªå£ä¸éæ© Add External JARsãæä¸è½½å¹¶è§£ååºæ¥çmysql-connector-java-5.1.15-bin.jaréä¸ãå¦å¾ï¼
é ç½®ä¸è½½å¥½ç驱å¨jarï¼
ç¼åè¿æ¥ç¨åºï¼
import java.sql.*;
class ConnMySql {
/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/select_test",
"root","123456");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from teacher_table");
while (rs.next()) {
System.out.println(rs.getInt(1) + "\t"
+rs.getString(2) + "\t"
+rs.getString(3) );
}
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
}
}
数据库名:select_test
用户名:root
密码:123456
连接成功后显示teacher_table表中的数据。