首先要把mysql的數(shù)據(jù)庫連接驅(qū)動加入到工程當(dāng)中
代碼只要修改下sql語句、數(shù)據(jù)庫、表以及用戶名和密碼
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*
* Create Date:2008-9-4 下午02:27:36
*
* Author:dingkm
*
* Version: V1.0
*
* Description：對進(jìn)行修改的功能進(jìn)行描述
*
*
*/
public class DBConnection {
//測試主方法
public static void main(String[] args) {
DBConnection db = new DBConnection();
Connection conn = db.getConnection();
String sql = "select * from newitem";
ResultSet rs = db.getResultSet(sql, conn);
try {
while (rs.next()) {
String title = rs.getString("title");
System.out.println(title);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//得到Connection
public Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
// 建立到MySQL的連接
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/ding", "root", "ding");
} catch (Exception e) {
System.out.println("數(shù)據(jù)庫連接異常！");
e.printStackTrace();
}
return conn;
}
//得到ResultSet
public ResultSet getResultSet(String sql, Connection conn) {
ResultSet rs = null;
Statement stmt = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
}
執(zhí)行就可以連接數(shù)據(jù)庫了
posted on 2008-09-04 19:06
老丁 閱讀(226)
評論(0) 編輯 收藏 所屬分類:
數(shù)據(jù)庫