public class DBbean {

    private String driverStr = "com.mysql.jdbc.Driver";

    private String URL = "jdbc:mysql://localhost:3306/student?useunicuee=true&characterEncoding=UTF-8&serverTimezone=GMT&useSSL=false";

    private String username = "root";

    private String password = "123456";

    private Connection conn = null;

    private Statement stmt = null;

    public DBbean() {

        try {

            Class.forName(driverStr);//查找并加载指定的类

            conn = DriverManager.getConnection(URL, username, password);//指定数据库的连接

            stmt = conn.createStatement();//封装 SQL 语句发送给数据库

        } catch (Exception ex) {

            System.out.println("数据库连接失败！");

        }

    }

    /**

     * 关闭数据库

     */

    public void close() {

        try {

            stmt.close();

            conn.close();

        } catch (Exception e) {

        }

    }

    /**

     * 执行更新操作

     * @param s

     * SQL语句

     * @return

     * 更新操作的结果

     */

    public int executeUpdate(String s) {

        int result = 0;

        try {

            result = stmt.executeUpdate(s);

        } catch (Exception ex) {

            System.out.println("更新出现异常！");

        }

        return result;

    }

    /**

     * 执行查询操作

     * @param s

     * SQL语句

     * @return

     * 查询结果

     */

    public ResultSet executeQuery(String s) {

        ResultSet rs = null;

        try {

            rs = stmt.executeQuery(s);

        } catch (Exception ex) {

            System.out.println("查询出现异常！");

        }

        return rs;

    }

}