import java.sql.*;
public class Jdbc_con {
private Connection Conn=null;
private PreparedStatement psmt=null;
private ResultSet rs=null;
private static String url="jdbc:mysql://localhost:3306/dbtest";
private static String user="root";
private static String passWord="root";
/**
* 定义成静态是为了在数据库调用时更加方便
* @return 返回的是取得的连接
*/
public static Connection getConn(){
Connection con=null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url,user,passWord);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
/**
* 关闭数据库的相关连接等
* @param rs 结果集
* @param con 连接
* @param stmt 状态
*/
public static void free(ResultSet rs,Connection con,Statement stmt){
try {
if(rs!=null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(stmt!=null)
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(con!=null){
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}