數(shù)據(jù)庫連接問題
package com.jdbc.test;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class Testjdbc {
? ? private static final String url="jdbc:mysql://127.0.0.1:3306/testdata";
? ? private static final String user="root";
? ? private static final String password="root";
? ??
public static void main(String[] args) throws Exception {
//1、加載驅(qū)動程序
Class.forName("com.mysql.jdbc.Driver") ; ??
//2、獲得數(shù)據(jù)庫的連接
? ?Connection conn=DriverManager.getConnection(url, user, password);?
? ?//3、實現(xiàn)增刪改查
? ?Statement stmt=conn.createStatement();
? ?ResultSet rs=stmt.executeQuery("select id,name from testtable");
? //上面兩句提示錯誤，請高手教我，謝謝
? ?while(rs.next()){
? ? System.out.println(rs.getInt("id")+","+rs.getString("name"));
? ?}
? ?
}
}
2016-11-27
雖然自己已經(jīng)找到原因，但還是感謝晴顏的回答
2016-11-24
你的包導(dǎo)入錯了，import java.beans.Statement;這個包不對
應(yīng)該是import java.sql.Statement;
2016-11-24
public Connection GetConnection() {
// 數(shù)據(jù)庫連接語句
String url = "jdbc:mysql://localhost:3306/database?"
+ "user=root&password=root&useUnicode=true&characterEncoding=UTF8";
// 加載MySql的驅(qū)動類
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("[數(shù)據(jù)庫] 找不到驅(qū)動程序類 ，加載驅(qū)動失?。?);
e.printStackTrace();
}
// 連接數(shù)據(jù)庫
try {
Connection con = (Connection) DriverManager.getConnection(url);
System.out.println("[數(shù)據(jù)庫] 已連接。");
return con;
} catch (SQLException se) {
System.out.println("[數(shù)據(jù)庫] 連接失敗！");
se.printStackTrace();
}
return null;
}