CRUD增删改查(insert,delete,update,select)
CRUD操作部分
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.HashMap;
import java.util.List;
import java.util.Map;
import javax.swing.text.StyledEditorKit.BoldAction;
import com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper;
public class UserCRUD {
private Connection conn;
private boolean insert(String username, String password) throws ClassNotFoundException, SQLException {
PreparedStatement ps = null;
try {
conn=DBUtils.getConn();
String sql = "insert into tbuser(username,password) values(?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
// 执行
int i = ps.executeUpdate();
return i > 0;
} finally {
DBUtils.close(null, ps, conn);
}
}
private boolean update(int id, String password) throws ClassNotFoundException, SQLException {
PreparedStatement ps = null;
try {
conn=DBUtils.getConn();
String sql = "update tbuser set