javabean mysql_JavaBean连接MySQL数据库

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;

}

}

}