conn.java

来自「一个完善的班级网站的实现」· Java 代码 · 共 53 行

package ly;
import java.sql.*;

public class Conn
{
        String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
        String sConnStr="jdbc:odbc:xfriend";
        Connection connect=null;
        ResultSet rs=null;
        Statement stmt=null;
        
        public Conn()
        {
             try{
                     Class.forName(sDBDriver); 
                     connect=DriverManager.getConnection(sConnStr,"","");
                     stmt=connect.createStatement();
                     
                }
                catch(Exception e)
                {
                      System.err.println(e.getMessage());	
                }
                
             
        }
        public ResultSet executeQuery(String sql)
        {
              try
              {                      
                      rs=stmt.executeQuery(sql);	
              }	
              catch(SQLException ex)
              {
                    System.err.println(ex.getMessage());	
              }
              return rs;
        }
        public int executeUpdate(String sql)
        {
            int result=0;
            try
            {                 
                 result=stmt.executeUpdate(sql);	
            }
            catch(SQLException ex)
            {
                    System.err.println(ex.getMessage());	
            }
            return result;	
        }	
}