会python真的可以为所欲为0(回)
350天前
这里还有人吗1(回)
535天前这里还有人吗0(回)
535天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
760天前到处都是羊，不想上班0(回)
840天前
鸽子
0(回)
844天前package demo.utils; |
import java.sql.Connection; |
import java.sql.DriverManager; |
import java.sql.ResultSet; |
import java.sql.SQLException; |
import java.sql.Statement; |
/* |
* 使用工具类来简化代码 |
*/ |
public class JDBCUtils { |
private static String driver = "com.mysql.jdbc.Driver"; |
private static String url = "jdbc:mysql://localhost:3306/jdbc"; |
private static String user = "root"; |
private static String password = "password"; |
|
//通过静态块注册驱动 |
static{ |
try { |
Class.forName(driver); |
} catch (ClassNotFoundException e) { |
throw new ExceptionInInitializerError(e); |
} |
} |
|
|
//获取连接 |
public static Connection getConnection(){ |
try { |
return DriverManager.getConnection(url, user, password); |
} catch (SQLException e) { |
e.printStackTrace(); |
} |
return null; |
} |
|
//释放资源 |
public static void release(Connection conn,Statement st,ResultSet rs){ |
if(rs != null){ |
try { |
rs.close(); |
} catch (SQLException e) { |
e.printStackTrace(); |
}finally{ |
rs = null; |
} |
} |
if(st != null){ |
try { |
st.close(); |
} catch (SQLException e) { |
e.printStackTrace(); |
}finally{ |
st = null; |
} |
} |
if(conn != null){ |
try { |
conn.close(); |
} catch (SQLException e) { |
e.printStackTrace(); |
}finally{ |
conn = null; |
} |
} |
} |
} |
