服务器已配置好的数据源,获取数据库连接工具类(网络协议纯Java驱动程序方式),默认连接本地
package com.sise.system.util;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import com.sise.util.TableName;
public class ConnectionUtil {
private static DataSource dataSource;
static{
try{
Context context=new InitialContext();
dataSource = (DataSource) context
.lookup(TableName.DATASOURCE1);
}catch(Exception e){
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
Connection connection = dataSource.getConnection();
return connection;
}
public static void closeConnection(Connection con,PreparedStatement preStmt,ResultSet rs) throws SQLException{
if (rs != null)
rs.close();
if (preStmt != null)
preStmt.close();
if (con != null)
con.close();
}
public static void closeConnection(Connection con, PreparedStatement preStmt) throws SQLException {
// TODO 自动生成的方法存根
if (preStmt != null)
preStmt.close();
if (con != null)
con.close();
}
}
直接连接数据库,获取数据库连接工具类(本地协议纯Java驱动程序)
public class JdbcUtils {
//注册驱动的工具类
private static String url = null;
private static String user = null;
private static String password = null;
private static String dv = null;
static{
Properties prop = new Properties();
InputStream in = JdbcUtils.class.getResourceAsStream("/a.properties");
try {
prop.load(in);
url = prop.getProperty("url");
user = prop.getProperty("user");
password = prop.getProperty("123456");
dv = prop.getProperty("driver");
/*System.out.println("url:"+url);*/
//注册驱动
try {
Class.forName(dv);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//获取连接对象
public static Connection getCon() throws SQLException{
Connection conn = null;
conn = (Connection) DriverManager.getConnection(url, user, password);
return conn;
}
//关闭的方法
public static void close(Statement statement,Connection conn){
if(statement !=null){
try {
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn !=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//关闭的方法
public static void close(PreparedStatement preparedStatement,Connection conn,ResultSet resultSet){
if(preparedStatement !=null){
try {
preparedStatement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn !=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(resultSet!=null){
try {
resultSet.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}