myeclipseä¸ä½¿ç¨JDBCè¿æ¥MySQLè¿æ¥æ°æ®åºï¼å¯ä»¥æ°å»ºä¸ä¸ªjavaæ件ï¼ä½¿ç¨JDBCæä½æ°æ®åºå°±å¯ä»¥ï¼å®ä¾å¦ä¸ï¼
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBConnection {
private final static String url = "jdbc:mysql://localhost:3306/test?user=root&password=root&useUnicode=true&characterEncoding=utf-8";//é
ç½®è¿æ¥æ°æ®åºçç¨æ·ååå¯ç
private final static String dbDriver = "com.mysql.jdbc.Driver";//mysqlç驱å¨ç¨åºå
private Connection con = null;
// éè¿æé æ¹æ³å è½½æ°æ®åºé©±å¨
static {
try {
Class.forName(dbDriver).newInstance();//å©ç¨åå°å®ä¾å驱å¨ç±»
} catch (Exception ex) {
System.out.println("æ°æ®åºå 载失败");
}
}
// å建æ°æ®åºè¿æ¥
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url);
con.setAutoCommit(true);//æ交sqlè¯å¥
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
}
// 对æ°æ®åºçå¢å ãä¿®æ¹åå é¤çæä½
public boolean executeUpdate(String sql) {
if (con == null) {
creatConnection();
}
try {
Statement stmt = con.createStatement();//å¾å°ä¸ä¸ªç»æéï¼æ¿æ¥éå
int iCount = stmt.executeUpdate(sql);
return true;
} catch (SQLException e) {
System.out.println(e.getMessage());
return false;
}
}
// 对æ°æ®åºçæ¥è¯¢æä½
public ResultSet executeQuery(String sql) {
ResultSet rs;
try {
if (con == null) {
creatConnection();
}
Statement stmt = con.createStatement();//å¾å°ä¸ä¸ªç»æéï¼æ¿æ¥æ¥è¯¢
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
} catch (SQLException e) {
return null;
}
return rs;
}
}