try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/myqq", "root", "不告诉你");
//Create 增加
PreparedStatement ps = connection.prepareStatement("insert into accountinfo values(?,?,?)");
ps.setString(1, "5");
ps.setString(2, "5");
ps.setString(3, "王大花");
ps.executeUpdate();
//Retrieve 查询
ps = connection.prepareStatement("select* from accountinfo");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("qqNumber") + " " + rs.getString("password") + " " + rs.getString("nickName"));
}
//Update 更新
ps = connection.prepareStatement("update accountinfo set nickName = ? where qqNumber = ?");
ps.setString(1,"大帅哥");
ps.setString(2,"4");
ps.executeUpdate();
//Delete 删除
ps = connection.prepareStatement("delete from accountinfo where qqNumber = ?");
ps.setString(1,"1");
ps.executeUpdate();
rs.close();
ps.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
Java实现CRUD操作
最新推荐文章于 2024-07-04 02:10:41 发布