package Test;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 数据库连接工具类
* @author wukuan
*
*/
public class DBLink {
static{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
/**
* 获取链接
* @return
*/
private Connection getConnection(){
String url = "jdbc:oracle:thin:@192.168.3.185:1521:orcl";
try {
return DriverManager.getConnection(url,"scott","root");
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 查询数据
* @param sql
* @param rowMapper
*/
public void select(String sql,IRowMapper rowMapper){
Connection connection = getConnection();
Statement statement = null;
ResultSet rs = null;
try {
statement = connection.createStatement();
rs = statement.executeQuery(sql);
rowMapper.rowMapper(rs);
} catch (SQLException e) {
e.printStackTrace();
}finally {
close(connection, statement, rs);
}
}
/**
* 查询数据
* @param sql
* @param rowMapper
* @param values
*/
public void select(String sql,IRowMapper rowMapper,Object...values){
Connection connection = getConnection();
PreparedStatement preparedStatement = null;
ResultSet rs = null;
try {
preparedStatement = connection.prepareStatement(sql);
for (int i = 1; i <= values.length; i++) {
rs = preparedStatement.executeQuery(sql);
}
rowMapper.rowMapper(rs);
} catch (SQLException e) {
e.printStackTrace();
}finally {
close(connection, preparedStatement, rs);
}
}
/**\
* 修改(update、delete、insert)数据
* @param sql
* @return
*/
public boolean update(String sql){
Connection connection = getConnection();
Statement statement = null;
try {
statement = connection.createStatement();
int result = statement.executeUpdate(sql);
return result > 0;
} catch (SQLException e) {
e.printStackTrace();
}finally {
close(connection,statement,null);
}
return false;
}
public void update(String sql,Object...values){
Connection connection = getConnection();
PreparedStatement ps = null;
try {
ps = connection.prepareStatement(sql);
for(int i = 1;i<=values.length;i++){
ps.setObject(i, values[i-1]);
}
int result = ps.executeUpdate();
System.out.println(result>0);
} catch (SQLException e) {
e.printStackTrace();
}finally {
close(connection,ps,null);
}
}
/**
* 数据库批量修改
* @param sqls
* @return
*/
public boolean bathUpdate(String ...sqls){
Connection connection =getConnection();
Statement statement = null;
try {
connection.setAutoCommit(false);
statement = connection.createStatement();
for (String sql :sqls) {
statement.executeUpdate(sql);
}
connection.commit();
return true;
} catch (SQLException e) {
if(connection !=null){
try {
connection.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
e.printStackTrace();
}finally {
close(connection, statement, null);
}
return false;
}
/**
* 释放资源
* @param connection
* @param statement
* @param rs
*/
private void close(Connection connection, Statement statement, ResultSet rs) {
try {
if(rs!=null){
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(statement!=null){
statement.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(connection!=null){
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}