java数据库视图工具_数据库视图工具类

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);

}*/

}