数据库视图工具类

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import net.sf.json.JSONObject;

/**
* Title: DBUtil.java Description: 数据库连接释放 公用方法
*
* @author zyl
* @created 2018年12月26日 上午10:47:12
*/

public class DBUtil {
private static final String DBURL = "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(port=1521)(host=192.168.0.102)(PORT = 1521))(connect_data=(SERVER = DEDICATED)(service_name=MES_WIP)))";  //数据库地址
private static final String DBUSER = "ZHWL"; //登录名
private static final String DBPWD = "ZHWL";//密码

// 只需要执行一次
static {
try {
System.out.println("注册数据库驱动......");
Class.forName("oracle.jdbc.OracleDriver");
} catch (ClassNotFoundException e) {
throw new RuntimeException("注册数据库驱动出现异常:" + e.getMessage());
}
}

/**
* 获取一个连接对象
*
* @return
*/
public static Connection getConn() {
try {
return DriverManager.getConnection(DBURL, DBUSER, DBPWD);
} catch (SQLException ex1) {
throw new RuntimeException("无法获取连接,原因:" + ex1.getMessage());
}
}

public static void close(ResultSet rs, Statement st, Connection conn) {
try {
if (null != rs) {
rs.close();
System.out.println("ResultSet已关闭！");
}
} catch (SQLException e) {
throw new RuntimeException("关闭ResultSet出现异常:" + e.getMessage());
} finally {
try {
if (null != st) {
st.close();
System.out.println("Statement已关闭！");
}
} catch (SQLException e) {
throw new RuntimeException("关闭Statement出现异常:" + e.getMessage());
} finally {
if (null != conn) {
try {
conn.close();
System.out.println("Connection已关闭！");
} catch (SQLException e) {
throw new RuntimeException("关闭Connection出现异常:" + e.getMessage());
}
}
}
}

}
/*public static void main(String[] args) throws SQLException {
WDK.startup();
Connection conn = DBUtil.getConn();
String sql = "select * from MES.V_SOC_CUSTOMER_PARTNER_TO_ZHWL";
PreparedStatement pstm = conn.prepareStatement(sql);
ResultSet rs = pstm.executeQuery();
while (rs.next()) {

String name = rs.getString("");
}

System.out.println(i);
}*/
}

 

转载于:https://www.cnblogs.com/maxlangod/p/10270465.html