package com.yucheng.jdbc;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Properties;
public class jdbcTools {
//获取数据库的连接
public static Connection getConnecition() throws Exception{
String driverClass=null;
String url=null;
String user=null;
String password=null;
InputStream in =
jdbcTools.class.getClassLoader().getResourceAsStream("jdbc.properties");
Properties properties=new Properties();
properties.load(in);
driverClass=properties.getProperty("driverClass");
url=properties.getProperty("url");
user=properties.getProperty("user");
password=properties.getProperty("password");
Class.forName(driverClass);
Connection conn =DriverManager.getConnection(url, user, password);
return conn;
}
//关闭数据库
public static void release(Statement statement,Connection conn){
if(statement !=null){
try {
statement.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
if(conn !=null){
try {
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
// @Test
// public void test() throws Exception{
// System.out.println(getConnecition());
// }
}
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Properties;
public class jdbcTools {
//获取数据库的连接
public static Connection getConnecition() throws Exception{
String driverClass=null;
String url=null;
String user=null;
String password=null;
InputStream in =
jdbcTools.class.getClassLoader().getResourceAsStream("jdbc.properties");
Properties properties=new Properties();
properties.load(in);
driverClass=properties.getProperty("driverClass");
url=properties.getProperty("url");
user=properties.getProperty("user");
password=properties.getProperty("password");
Class.forName(driverClass);
Connection conn =DriverManager.getConnection(url, user, password);
return conn;
}
//关闭数据库
public static void release(Statement statement,Connection conn){
if(statement !=null){
try {
statement.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
if(conn !=null){
try {
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
// @Test
// public void test() throws Exception{
// System.out.println(getConnecition());
// }
}
-------------注意:statement只是用于增加、删除和修改 。。。