17,086
社区成员
发帖
与我相关
我的任务
分享
@Component
public class JdbcCon {
private Statement stmt;
public boolean connect;
public PooledConnection dbpool;
public OracleConnectionPoolDataSource ocpds = null;
public void setConnect(boolean connect) {
this.connect = connect;
}
StringBuffer script = new StringBuffer();
// 私有构造器
public JdbcCon() {
try {
try{
dbpool = ocpds.getPooledConnection();
}
catch (Exception e) {
OracleConnectionPoolDataSource ocpds = new OracleConnectionPoolDataSource();
ocpds.setURL("jdbc:oracle:thin:@localhost:1521:orcl");
ocpds.setUser("hafei");
ocpds.setPassword("hafei123");
dbpool = ocpds.getPooledConnection();
}
this.connect = true;
} catch (Exception e) {
this.connect = false;
}
}
@Expose
public boolean getConnect() {
JdbcCon con = new JdbcCon();
try{con.dbpool.close();}
catch(Exception e){}
return con.connect;
}
/*
* 执行一句查询的SQL
*/
public ResultSet executeQuery(String sql) throws SQLException {
Statement stmt = null;
ResultSet result = null;
Connection connection = null;
try{
connection = dbpool.getConnection();
stmt = connection.createStatement();
result = stmt.executeQuery(sql);
}
catch( Exception e){
//System.err.println("Error in Query - SQLBean : ");
//e.printStackTrace(System.err);
}
return result;
}
// 执行单句INSERT、UPDATE 或 DELETE 语句, 如果执行INSERT时, 返回主键
public int executeUpdate(String sql) throws SQLException {
Statement stmt = null;
int rc = 0;
Connection connection = null;
try
{
connection = dbpool.getConnection();
stmt = connection.createStatement();
rc = stmt.executeUpdate(sql);
}
catch( Exception ex )
{
//System.err.println("Error in Update - OraPooledSQL : ");
//ex.printStackTrace(System.err);
}
return rc;
}
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
// System.err.println("*** db:closeStmt():\r"+e.getMessage());
}
}
public void closeConn()
{
if(dbpool != null) {
try {
dbpool.close();
} catch(Exception ex){
// ex.printStackTrace();
}
}
}
}