package com.zms.utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
public class JDBCUtil {
//获取jdbc的链接创建jdbc链接的工具类对象
public static Connection getConnetions() {
Connection conn = null;
String driverClass = null;
String jdbcUrl = null;
String user = null;
String password = null;
try {
//读取配置
InputStream ism = JDBCUtils.class.getClassLoader().getResourceAsStream("db.properties");
Properties properties = new Properties();
properties.load(ism);
driverClass = properties.getProperty("driver");
jdbcUrl = properties.getProperty("jdbcUrl");
user = properties.getProperty("user");
password = properties.getProperty("password");
Class.forName(driverClass);//注册驱动
conn = DriverManager.getConnection(jdbcUrl,user,password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public void query(String sql){
Connection conn = null;
PreparedStatement ps = null;
ResultSet result = null;
try {
conn = JDBCUtils.getConnetions();
ps = conn.prepareStatement(sql);
result = ps.executeQuery();
while(result.next()){
//(result.getInt(1),result.getString(2),result.getString(3));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
JDBCUtils.putoff(result, ps, conn);
}
}
public void update(String sql){
Connection conn = null;
PreparedStatement ps = null;
try {
conn = JDBCUtils.getConnetions();
ps = conn.prepareStatement(sql);
int result = ps.executeUpdate();
System.out.println(result);
} catch (Exception e) {
e.printStackTrace();
}finally{
JDBCUtils.putoff(ps, conn);
}
}
//关闭jdbc的链接
public static void putoff(PreparedStatement ps, Connection conn){
try {if(ps != null){ps.close();}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void putoff(ResultSet result,PreparedStatement ps, Connection conn){
try {
if(result != null){
result.close();
}
} catch (SQLException e1) {
e1.printStackTrace();
}finally{
try {
if(ps != null){
ps.close();
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}