package Data;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import java.sql.*;
public class Databean { Connection con = null;
Statement state = null;
ResultSet rs = null;
ResultSetMetaData rsmd = null;
public Databean(){
try
{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/oracle");
con = ds.getConnection();
}catch(Exception e){}
}
public Connection getConnection() throws SQLException{
return con;
} public Statement getStatement() throws SQLException{
state = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
return state;
}
public ResultSet getResult(String SQL) throws SQLException{
rs = state.executeQuery(SQL);
return rs;
} public void SQLFunction(String SQL) throws SQLException{
state.executeUpdate(SQL);
}
public ResultSetMetaData getResultSetMetaData() throws SQLException{
rsmd = rs.getMetaData();
return rsmd;
}
public void closeBase() throws SQLException{
if(con != null){
//rs.close();
state.close();
con.close();
}
}
}
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import java.sql.*;
public class Databean { Connection con = null;
Statement state = null;
ResultSet rs = null;
ResultSetMetaData rsmd = null;
public Databean(){
try
{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/oracle");
con = ds.getConnection();
}catch(Exception e){}
}
public Connection getConnection() throws SQLException{
return con;
} public Statement getStatement() throws SQLException{
state = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
return state;
}
public ResultSet getResult(String SQL) throws SQLException{
rs = state.executeQuery(SQL);
return rs;
} public void SQLFunction(String SQL) throws SQLException{
state.executeUpdate(SQL);
}
public ResultSetMetaData getResultSetMetaData() throws SQLException{
rsmd = rs.getMetaData();
return rsmd;
}
public void closeBase() throws SQLException{
if(con != null){
//rs.close();
state.close();
con.close();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货