JDBC连接类
在我们不使用框架的情况下,我们就需要自己编写jdbc工具类,下面是代码
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class DBUtlis
{
private static String driverName;
private static String url;
private static String user;
private static String password;
//注册驱动
static {
try {
InputStream in = DBUtlis.class.getResourceAsStream("dbinfo.properties");
Properties properties = new Properties();
properties.load(in);
driverName = properties.getProperty("driverName");
url = properties.getProperty("url");
user = properties.getProperty("user");
password = properties.getProperty("password");
Class.forName(driverName);
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//获取连接
public static Connection getConnection() {
Connection con = null;
try {
con = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
//关闭连接
public static void close(ResultSet rs, Statement st, Connection conn){
try{
if(rs != null)
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
try{
if(st != null)
st.close();
}catch(SQLException e){
e.printStackTrace();
}
try{
if(conn != null)
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
//控制台输出是否连接成功
public static void main(String[] args)
{
System.out.println(getConnection());
}
}
下面是dbinfo.properties配置文件
driverName=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost;DatabaseName=VIIDB
user=sa
password=server