DB.java
资源名称:Shopping.rar [点击查看]
上传用户:lsj999sz
上传日期:2022-06-15
资源大小:4717k
文件大小:2k
源码类别:
ICQ/即时通讯
开发平台:
Java
- package com.bjsxt.shopping.util;
- import java.sql.*;
- public class DB {
- public static Connection getConn() {
- Connection conn = null;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection("jdbc:mysql://localhost/shopping?user=root&password=root");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return conn;
- }
- public static PreparedStatement prepare(Connection conn, String sql) {
- PreparedStatement pstmt = null;
- try {
- if(conn != null) {
- pstmt = conn.prepareStatement(sql);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return pstmt;
- }
- public static PreparedStatement prepare(Connection conn, String sql, int autoGenereatedKeys) {
- PreparedStatement pstmt = null;
- try {
- if(conn != null) {
- pstmt = conn.prepareStatement(sql, autoGenereatedKeys);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return pstmt;
- }
- public static Statement getStatement(Connection conn) {
- Statement stmt = null;
- try {
- if(conn != null) {
- stmt = conn.createStatement();
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return stmt;
- }
- /*
- public static ResultSet getResultSet(Connection conn, String sql) {
- Statement stmt = getStatement(conn);
- ResultSet rs = getResultSet(stmt, sql);
- close(stmt);
- return rs;
- }
- */
- public static ResultSet getResultSet(Statement stmt, String sql) {
- ResultSet rs = null;
- try {
- if(stmt != null) {
- rs = stmt.executeQuery(sql);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return rs;
- }
- public static void executeUpdate(Statement stmt, String sql) {
- try {
- if(stmt != null) {
- stmt.executeUpdate(sql);
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public static void close(Connection conn) {
- try {
- if(conn != null) {
- conn.close();
- conn = null;
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public static void close(Statement stmt) {
- try {
- if(stmt != null) {
- stmt.close();
- stmt = null;
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public static void close(ResultSet rs) {
- try {
- if(rs != null) {
- rs.close();
- rs = null;
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }