基本操作步骤为:
1、获取数据库连接
2、SQL语句的预加载
3、获得结果集(仅限查询)
4、操作结果集
5、关闭资源
一、获取连接的方法getConnection()
public static Connection getConnection() throws Exception {
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
Properties pro = new Properties();
pro.load(is);
String user = pro.getProperty("user");
String password = pro.getProperty("password");
String url = pro.getProperty("url");
String driverClass = pro.getProperty("driverClass");
Class.forName(driverClass);
Connection connection = DriverManager.getConnection(url, user, password);
return connection;
}
其中jdbc.properties文件如下
二、关闭资源的方法closeResources()
1.关闭增删改资源
代码如下(示例):
public static void closeResources(Connection connection,PreparedStatement ps){
try {
if