JDBC连接mysql查询示例

使用原生sql，jdbc连接数据库简单查询

package ;

import java.sql.*;

/**
 * 功能描述  jdbc操作数据库
 *
 * @author: 
 * @date: 2022年05月19日 11:03
 */
public class JDBCconnection {

    private final static String driver = "com.mysql.cj.jdbc.Driver";
    private final static String url = "jdbc:mysql://192.168.1.1:3306/ku";
    private final static String username = "root";
    private final static String password = "root";

    //获取连接
    public static Connection getConn(){
        try {
            Class.forName(driver);
            return DriverManager.getConnection(url,username,password);
        }catch (Exception e){
            e.printStackTrace();
        }
        return null;
    }

    //查询
    public static ResultSet query(String sql,Object... params){
        Connection connection = getConn();
        PreparedStatement pst = null;
        ResultSet rs = null;
        try {
            pst = connection.prepareStatement(sql);
            for (int i = 0; i < params.length; i++) {
                pst.setObject(i+1,params[i]);
            }
            rs = pst.executeQuery();
        }catch (Exception e){
            e.printStackTrace();
        }
        closeConnection(rs, pst, connection);
        return rs;
    }

    //关闭连接
    public static void closeConnection(ResultSet rs, PreparedStatement pstmt, Connection conn) {
        try {
            if (rs != null) {
                rs.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

        try {
            if (pstmt != null) {
                pstmt.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

        try {
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }

    //测试
    public static void main(String[] args) throws SQLException {
        String sql = "select * from table where id = ?";
        ResultSet resultSet = JDBCconnection.query(sql,"id");
        while (resultSet.next()){
            System.out.print("name:"+resultSet.getString("name"));
        }
    }

       /** 提前引入maven jar
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
    */

}