JDBC的增删查改操作

1.先写个工具类，将连接数据库与释放封装起来。

-------------util.java---------------

package com.util;

import java.sql.*;

public class util {

public static Connection conn(){
    Connection connection=null;
    Connection resultSet=null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/newtest?useSSL=true&serverTimezone=UTC&characterEncoding=utf-8&user=root&password=123456");

    } catch (Exception e) {
        e.printStackTrace();
    }
    return connection;



}


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

}

2.查询功能
创建一个数据库名称的类 Newtest，自动生成
package bean;

import com.sun.xml.internal.bind.v2.model.core.ID;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Newtest {
public Newtest(String username, String password) {
this.username = username;
this.password = password;
}

@Override
public String toString() {
    return "Newtest{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            '}';
}

private int id;
private String username;
private String password;

public int getId() {
    return id;
}

public void setId(int id) {
    this.id = id;
}

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username;
}

public String getPassword() {
    return password;
}

public void setPassword(String password) {
    this.password = password;
}


}

//在jdbc.java主程序中声明一个模板类
List list=new ArrayList<>();

ResultSet resultSet=null;
PreparedStatement statement=null;
Connection connection=null;
try {
connection=util.conn();

//3.写sql
String sql="select * from students";
//4.得到statement对象
statement = connection.prepareStatement(sql);
//5.执行sql
resultSet = statement.executeQuery();
//6处理结果集

---

while (resultSet.next()){

    int id=resultSet.getInt(1);
    String username=resultSet.getString(2);
    String password=resultSet.getString(3);
    Newtest newtest=new Newtest(username,password);
    newtest.setId(id);
    list.add(newtest);
}
System.out.print(list.toString());

} catch (Exception e) {
e.printStackTrace();
}finally {
util.closeAll(resultSet, statement, connection);

---

***** *************************** ********** //7关闭资源

}

以下功能 将上面*星号包括的内容替换就可以了
增加功能
prepare.setString(1, “6”);
prepare.setString(2, “小白”);
prepare.setString(3, “30”);
int i = prepare.executeUpdate();
System.out.println(“i=” + i);

删除功能
PreparedStatement prepare = connection.prepareStatement(sql);
prepare.setString(1, “6”);
int i = prepare.executeUpdate();
System.out.println(“i=” + i);