![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/e5ca15fc64ecd5b4d118b2de5694bd3c.png)
package com.scv.servlet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class JdbcUtil {
public static void main(String[] args) {
JdbcUtil jdbcUtil =new JdbcUtil();
List list=jdbcUtil.findAllUsers();
for (int i = 0; i < list.size(); i++) {
System.out.println(list.get(i));
}
}
public void addUser(String username,String password) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/qqs", "root", "123456");
PreparedStatement ps=conn.prepareStatement("insert into user (username,password) value(?,?)");
ps.setString(1, username);
ps.setString(2, password);
ps.execute();
ps.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void updateUser(String username,String password) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/qqs", "root", "123456");
PreparedStatement ps=conn.prepareStatement(" update user set password=? where username=?");
ps.setString(1, password);
ps.setString(2, username);
ps.execute();
ps.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void deleteUserByName