public void addUser(User u) throws Exception{
?Connection conn=GetConnection.getConnection();
?String sql="insert into user_table (name,sex,keshi,jituanhao,group) values (?,?,?,?,?)";??
?PreparedStatement pdst=conn.prepareStatement(sql);
?pdst.setString(1, u.getName());
?pdst.setString(2, u.getSex());
?pdst.setString(3, u.getKeshi());
?pdst.setInt(4, u.getJituanhao());
?pdst.setString(5, u.getGroup());
?pdst.execute();?
?}
?public void delUser(Integer id) throws SQLException{
??Connection conn=GetConnection.getConnection();
??String sql="" + "delete from user_table" +
????"where id=? ";
??PreparedStatement pdst=conn.prepareStatement(sql);
??pdst.setInt(1, id);
??pdst.execute();
?}
?public void updateUser(User u) throws SQLException{
??Connection conn=GetConnection.getConnection();
??String sql="" + " update user_table"+" set name=?,sex=?,keshi=?,jituanhao=?,group=? " +
????"where id=? ";
??PreparedStatement pdst=conn.prepareStatement(sql);
??pdst.setString(1, u.getName());
??pdst.setString(2, u.getSex());
??pdst.setString(3, u.getKeshi());
??pdst.setInt(4, u.getJituanhao());
??pdst.setString(5, u.getGroup());
??pdst.setInt(6, u.getId());
??pdst.execute();
?}
?public List<User> query() throws Exception{
??Connection conn=GetConnection.getConnection();
??Statement stmt=conn.createStatement();
??ResultSet res=stmt.executeQuery("select name,group ?from user_table");
??List<User> user=new ArrayList<User>();
??User u=null;
??int i=0;
??while(res.next()){
???System.out.println(++i);
???u=new User();
???u.setName(res.getString("name"));
???u.setGroup(res.getString("group"));
???user.add(u);
???
??}
??return user;
?}
?public User get(Integer id) throws SQLException{
??User u=null;
??Connection conn=GetConnection.getConnection();
??String sql="" + "select * from user_table " +
????"where id=? ";??

?pdst=conn.prepareStatement(sql);???
??pdst.setInt(1, id);
??ResultSet rs=pdst.executeQuery();
??while(rs.next()){
???u=new User();
???u.setId(rs.getInt("id"));
???u.setGroup(rs.getString("group"));
???u.setJituanhao(rs.getInt("jituanhao"));
???u.setKeshi(rs.getString("keshi"));
???u.setName(rs.getString("name"));
???u.setSex(rs.getString("sex"));
??}
???
??return u;
?}

增加人員時報錯信息：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group) values ('??','?','????',6922,'???')' at line 1

刪除人員時報錯信息：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the?right syntax to use near 'id=23' at line 1

更新人員時報錯信息：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group='???' where id=24' at line 1

查詢多個人員時報錯信息：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group from user_table' at line 1

查詢單個人員時報錯信息：/*You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=3' at line 1??PreparedStatement

實(shí)在找不出sql語句錯在哪，在MySQL數(shù)據(jù)庫直接用這些sql語句操作，提示錯誤信息類似。