java Web

7月24号

utils 实用工具

package com.google.dao;

import javax.sql.rowset.CachedRowSet;
import javax.sql.rowset.RowSetProvider;
import java.sql.*;

public class BaseDao {
   
    private Connection connection;

    private Connection getConnection() {
   
        try {
   
            Class.forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/javabook", "scott", "tiger");
        } catch (SQLException | ClassNotFoundException throwables) {
   
            throwables.printStackTrace();
        }

        return connection;
    }

    protected int executeUpdate(String sql, Object... params) {
   
        getConnection();
        int count = 0;
        try {
   
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            for (int i = 0; i < params.length; i++)
                preparedStatement.setObject(i + 1, params[i]);
            count = preparedStatement.executeUpdate();
        } catch (SQLException e) {
   
            e.printStackTrace();
        } finally {
   
            closeConnection();
        }
        return count;
    }

    protected ResultSet executeQuery(String sql, Object... params) {
   
        getConnection();
        CachedRowSet rowSet = null;
        try {
   
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            for (int i = 0; i < params.length; i++)
                preparedStatement.setObject(i + 1, params[i]);
            ResultSet resultSet = preparedStatement.executeQuery();
            rowSet = RowSetProvider.newFactory().createCachedRowSet();
            rowSet.populate(resultSet);
        } catch (SQLException e) {
   
            e.printStackTrace();
        } finally {
   
            closeConnection();
        }
        return rowSet;
    }

    private