dbconn.java

MySql（JSP版）数据库管理系统

/*
 * DBconn.java
 *
 * Created on 2002年7月25日, 上午12:12
 */
package Show;
import java.sql.*;
public class DBconn 
  {String DBDriver="org.gjt.mm.mysql.Driver";
   String ConnStr="jdbc:mysql://localhost/web";
   String MyUser="inens";
   String MyPassword="inens";
   Connection conn = null;
   ResultSet rs = null;
   public DBconn()
     {try 
        {Class.forName(DBDriver);
        }
      catch(java.lang.ClassNotFoundException e) 
        {System.err.println("DBconn (): " + e.getMessage());
        }
     }
   public ResultSet executeQuery(String sql) 
     {rs = null;
      try
        {conn = DriverManager.getConnection(ConnStr,MyUser,MyPassword);
         Statement stmt = conn.createStatement();
         rs = stmt.executeQuery(sql);
        }
      catch(SQLException ex) 
        {System.err.println("aq.executeQuery:"+ex.getMessage());
        }
      return rs;
     }
  }