1月31日实训

数据库的连接

package com.java;

import java.sql.*;

public class JDBCDemo {
    public static void main(String[] args) throws Exception {
        Connection connection = null;
        ResultSet resultSet = null;
        PreparedStatement preparedStatement = null;
        //1.在项目上新建一个文件夹，lib，导入mysql驱动，并将jar包加入到项目中
        try {
            //2.注册驱动，使用到反射第三种方式
            Class.forName("com.mysql.cj.jdbc.Driver");
            //3、获取连接
            String url = "jdbc:mysql://60.205.91.224:3306/userdb";
            String username = "userdb";
            String password = "root";
            connection = DriverManager.getConnection(url, username, password);
            //System.out.println(connection);
            //4.获取预编译SQL,查询emp表中的数据
            String sql = "select * from emp";
            preparedStatement = connection.prepareStatement(sql);
            //5、查询，获取结果集（增删改，添加数据即可）并遍历;查询使用executeQuery()，
            // 增删改使用 execute()或者executeUpdate()
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()) {
                String ename = resultSet.getString("ename");
                String job = resultSet.getString("job");
                System.out.println(ename + "======" + job);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //6、释放资源 Connection,PreparedStatement,ResultSet,释放时需从后往前
            //如果connection,preparedStatement,resultSet对象为null JVM GC
            if (resultSet != null){
                try {
                    resultSet.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
            if (preparedStatement != null){
                try {
                    preparedStatement.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
            if (connection != null){
                try {
                    connection.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
        }
    }
}