DAY 7-jdbc

package jdbc;

import java.sql.*;

public class DBUtil {
public static Connection getConnection(){
Connection connection=null;
//1.加载驱动
try {
Class.forName(“com.mysql.jdbc.Driver”);
//2.创建连接
connection = DriverManager.getConnection
(“jdbc:mysql://127.0.0.1:3306/nbufe?useSSL=true&characterEncoding=utf-8&user=root&password=123”);
System.out.println(“创建连接成功”);
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}

public static void closeAll(ResultSet rs, PreparedStatement preparedStatement,Connection connection){
    if(rs!=null){
        try {
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if (preparedStatement!=null){
        try {
            preparedStatement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if (connection!=null){
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}

}

package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class TestJdb {
public static void main(String[] args) throws Exception {
Connection connection = DBUtil.getConnection();
List students=new ArrayList<>();
//3.写sql语句
String sql=“select * from student”;
//4.得到statement对象
PreparedStatement preparedStatement = connection.prepareStatement(sql);
//5.执行sql得到结果集
ResultSet resultSet = preparedStatement.executeQuery();
//6.处理结果集
while (resultSet.next()){
Student student=new Student();
student.setId(resultSet.getInt(1));
student.setName(resultSet.getString(2));
student.setPassword(resultSet.getString(3));
students.add(student);
}
System.out.println(students);
//7.关闭资源
DBUtil.closeAll(resultSet,preparedStatement,connection);
}
}

package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class TestDelete {
public static void main(String[] args) {
Connection connection=null;
PreparedStatement preparedStatement=null;
DBUtil dbUtil=null;

    //1.加载驱动
    try {
        dbUtil=new DBUtil();
        connection = dbUtil.getConnection();
        //3.写sql
        String sql="delete from student where id=?";
        //4.获得statement对象
        preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setInt(1,2);
        preparedStatement.executeUpdate();

    } catch (Exception e) {
        e.printStackTrace();
    }finally {
        dbUtil.closeAll(null,preparedStatement,connection);
    }

}

}