Mysql数据库连接类

来源：互联网发布：淘宝不能货到付款编辑：程序博客网时间：2024/05/20 00:37
package edu.qdgxy.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MySQLConnBean {private Statement stmt = null;private Connection conn = null;ResultSet rs = null;//构造函数public MySQLConnBean(){}public void OpenConn()throws Exception{try{Class.forName("com.mysql.jdbc.Driver").newInstance();String url = "jdbc:mysql://localhost:3306/test";String user = "root";String password = "admin";conn = DriverManager.getConnection(url,user,password);}catch(SQLException e){System.err.println("Data.executeQuery: " + e.getMessage());}}//执行查询类的SQL语句，有返回集public ResultSet executeQuery(String sql){rs = null;try{stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);rs = stmt.executeQuery(sql);}catch(SQLException e){System.err.println("Data.executeQuery: " + e.getMessage());}return rs;}//关闭对象public void closeStmt(){try{stmt.close();}catch(SQLException e){System.err.println("Date.executeQuery: " + e.getMessage());}}public void closeConn(){try{conn.close();}catch(SQLException e){System.err.println("Data.executeQuery: " + e.getMessage());}}}
0 0