与mysql数据库建立连接
package cn.java.mydoc.dao.impl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import javax.resource.cci.ResultSet;
public class BaseDao {
private static String driver="com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test1";
private static String user="root";
private static String password="123456";
public static Connection getConnection(){
Connection conn =null;
try{
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed()){
System.out.println("succeed connecting to database");
}
}catch(Exception e){
e.printStackTrace();
}
return conn;
}
public static void closeAll(Connection conn,Statement stmt,ResultSet rs){
if(rs!=null){
try{
rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
if(stmt!=null){
try{
stmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
if(conn!=null){
try{
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
}
实现按id查找、更新、和全部遍历
package cn.java