conn.jsp

来自「这个是用jsp做的一个系统。不过我没调出来」· JSP 代码 · 共 62 行

<%!
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public void jspInit()
{
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	//载入驱动程式类别
		con = DriverManager.getConnection("jdbc:odbc:login");	//建立数据库连接
		//建立Statement变量
		stmt = con.createStatement();
	}
	catch(Exception ex)
	{
		System.out.println(ex.toString());
	}
}
public void Exec(String sql){
     jspInit();
         try{
            stmt.executeUpdate(sql);
         }catch(Exception e){
              System.out.print(e.toString());
          } 
}
public ResultSet getRs(String sql) throws SQLException{
           jspInit();
            try{ 
             rs=stmt.executeQuery(sql);
              return rs; }
          catch(Exception e){
             System.out.print(e);
             return null;
          }
     }
 public ResultSet executeQuery(String sql) throws Exception 
     { 
        jspInit();
        try 
          {  
          sql=new String(sql.getBytes("GBK"),"ISO8859_1"); 
          stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
          rs=stmt.executeQuery(sql); 
          } 
      catch(SQLException ex) 
           { 
          System.out.println("sql.executeQuery:"+ex.getMessage()); 
           } 
           return rs; }

  public String getS(String Str){
            try{
                byte b[]=Str.getBytes("ISO-8859-1");
                Str=new String(b,"UTF-8");
             }
            catch(Exception ee){
               ee.printStackTrace();
             }
            return Str;
   }
%>