随笔档案(496)

import java.sql.*;

public class DBconn
{
String DBDriver = "org.gjt.mm.mysql.Driver";
String ConnStr = "jdbc:mysql://localhost/db";
String MyUser = "root";
String MyPassword = "";
Connection conn = null;
Statement stmt = 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(
      java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
      java.sql.ResultSet.CONCUR_READ_ONLY);
    rs = stmt.executeQuery(sql);
   } catch (SQLException ex)
   {
    System.err.println("aq.executeQuery:" + ex.getMessage());
   }
   return rs;
}

public void executeUpdate(String sql)
{
   {
    try
    {
     conn = DriverManager.getConnection(ConnStr, MyUser, MyPassword);
     Statement stmt = conn.createStatement();
     stmt.executeQuery(sql);
     stmt.close();
     conn.close();
    } catch (SQLException ex)
    {
     System.err.println("aq.executeQuery:" + ex.getMessage());
    }
   }
}

public boolean closeConn()
{
   try
   {
    if (rs != null)
     rs.close();
    if (stmt != null)
     stmt.close();
    if (conn != null)
     conn.close();
    return true;
   } catch (SQLException ex)
   {
    System.err.println("closeConn:" + ex.getMessage());
    return false;
   }
}
}