@Test
public void DBtestt() throws ClassNotFoundException, SQLException {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/zhaosheng";
String username = "root";
String password = "root";
Class.forName(driver);
Connection connection = DriverManager.getConnection(url, username, password);
System.out.println("Connection" + connection);
// 插入数据
PreparedStatement ps= connection.prepareStatement("insert into admin(username,password) values (?,?)");
ps.setString(1,"admin");
ps.setString(2,"123456");
int row = ps.executeUpdate();
if (row>0){
System.out.println("添加成功");
}
// 查询数据(单个)
PreparedStatement ps= connection.prepareStatement("select * from admin where id=?");
ps.setInt(1,1);
ResultSet rs = ps.executeQuery();
if (rs.next()){
Admin admin = new Admin();
int id = rs.getInt("id");
String name = rs.getString("username");
String pass = rs.getString("password");
admin.setId(id);
admin.setUsername(name);
admin.setPassword(pass);
System.out.println(admin.toString());
}
查询全部
PreparedStatement ps= connection.prepareStatement("select * from admin ");
ResultSet rs = ps.executeQuery();
List<Admin> admins = new ArrayList<>();
while (rs.next()){
Admin admin = new Admin();
int id = rs.getInt("id");
String name = rs.getString("username");
String pass = rs.getString("password");
admin.setId(id);
admin.setUsername(name);
admin.setPassword(pass);
admins.add(admin);
System.out.println(admin.toString());
}
// 修改
PreparedStatement ps= connection.prepareStatement("updat admin set username=?,password=? where id=?");
ps.setString(1,"admn");
ps.setString(2,"1234");
ps.setInt(3,13);
int row = ps.executeUpdate();
if (row>0){
System.out.println("修改成功");
}
// 删除
PreparedStatement ps= connection.prepareStatement("delete from admin where id=?");
ps.setInt(1,13);
int row = ps.executeUpdate();
if (row>0){
System.out.println("删除成功");
}
rs.close();
ps.close();
connection.close();
}
}
servilet 增删改查
最新推荐文章于 2024-10-06 20:16:20 发布