package count;
import java.sql.*;
import java.io.*;
import java.lang.*;
import javax.sql.DataSource;
import javax.naming.*;
import java.util.Date;
public class MydbBean
{
private Statement st=null;
private ResultSet rs=null;
private Connection con=null;
private Context initCtx;
private DataSource ds ;
// //构造函数
public MydbBean()
{}
//建立连接
public void OpenConn()
{
try
{
initCtx=new InitialContext();
ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/student");
con=ds.getConnection();
}catch(Exception e)
{
System.err.println("execute sql error"+e.getMessage());
}
}
//执行查询类的SQL语句,又返回集
public ResultSet executeQuery(String strSQL)
{
rs=null;
try
{
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=st.executeQuery(strSQL);
}catch(Exception e)
{
System.err.println("Query sql error"+e.getMessage());
}
return rs;
}
//执行更新类的sql 语句,午返回值
public void executeUpdate(String strSQL)
{
st=null;
rs=null;
try
{
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(strSQL);
}catch(SQLException e)
{
System.err.println("Update sql error"+e.getMessage());
}
}
//关闭对象
public void closeSt()
{
try
{
st.close();
}catch(SQLException e)
{
System.err.println("close sql error"+e.getMessage());
}
}
//关闭连接
public void closeCon()
{
try
{
con.close();
}catch(SQLException e)
{
System.err.println("close sql error"+e.getMessage());
}
}
}
import java.sql.*;
import java.io.*;
import java.lang.*;
import javax.sql.DataSource;
import javax.naming.*;
import java.util.Date;
public class MydbBean
{
private Statement st=null;
private ResultSet rs=null;
private Connection con=null;
private Context initCtx;
private DataSource ds ;
// //构造函数
public MydbBean()
{}
//建立连接
public void OpenConn()
{
try
{
initCtx=new InitialContext();
ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/student");
con=ds.getConnection();
}catch(Exception e)
{
System.err.println("execute sql error"+e.getMessage());
}
}
//执行查询类的SQL语句,又返回集
public ResultSet executeQuery(String strSQL)
{
rs=null;
try
{
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=st.executeQuery(strSQL);
}catch(Exception e)
{
System.err.println("Query sql error"+e.getMessage());
}
return rs;
}
//执行更新类的sql 语句,午返回值
public void executeUpdate(String strSQL)
{
st=null;
rs=null;
try
{
st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(strSQL);
}catch(SQLException e)
{
System.err.println("Update sql error"+e.getMessage());
}
}
//关闭对象
public void closeSt()
{
try
{
st.close();
}catch(SQLException e)
{
System.err.println("close sql error"+e.getMessage());
}
}
//关闭连接
public void closeCon()
{
try
{
con.close();
}catch(SQLException e)
{
System.err.println("close sql error"+e.getMessage());
}
}
}