Web 开发（jsp） 同学录（增删该查）

package wang.wu.jsp; import netscape.javascript.JSObject; import org.json.JSONArray; import org.json.JSONObject; 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; public class SqlStatement { SqlConnect connect=new SqlConnect(); String sql_data; public boolean Add(Student student){ sql_data = "insert into user_data(username,sex,age,birthday,QQdata,telephone,constellation,nativeplace,dream,address,hobby,message) " + "values('"+student.toString()+"')"; return localUpdata(); } public boolean Delet(String id){ sql_data = "delete from user_data where id ='"+ id +"'"; return localUpdata(); } public boolean Update(Student student){ sql_data = "update into user_data(username,sex,age,birthday,QQdata,telephone,constellation,nativeplace,dream,address,hobby,message) " + "values('"+ student.toString()+"')"; return localUpdata(); } public JSONArray backout(){ String sql = "select * from user_data"; JSONArray jArray=new JSONArray(); backout1(sql,jArray); return jArray; } public void backout1(String sql,JSONArray jArray){ ResultSet resultSet = null; try { resultSet = connect.getStmt().executeQuery(sql); }catch (SQLException e) { e.printStackTrace(); } try { while(resultSet.next()) { //ResultSet 对象具有指向其当前数据行的光标。 //List使用 // List<String> dataArray = new ArrayList<>(); // int id=resultSet.getInt("id"); //id标识 // dataArray.add(String.valueOf(id)); // dataArray.add(resultSet.getString("username")); //名字 // dataArray.add(resultSet.getString("sex")); //性别 // dataArray.add(resultSet.getString("birthday")); // dataArray.add(resultSet.getString("telephone")); //电话 //Map使用 Map<String,String> dataArray=new HashMap<>(); int id=resultSet.getInt("id"); //id标识 dataArray.put("id",String.valueOf(id)); dataArray.put("username",resultSet.getString("username")); //名字 dataArray.put("sex",resultSet.getString("sex")); //性别 dataArray.put("birthday",resultSet.getString("birthday")); //生日 dataArray.put("telephone",resultSet.getString("telephone")); //电话 jArray.put(dataArray); } resultSet.close(); }catch (SQLException e) { e.printStackTrace(); } } public JSONArray lookup(String data){ if (data==null) return null; else{ String sql = "select * from user_data where username like '%"+data+"%' or sex like '%"+data+"%' or age like '%"+data+"%'"; JSONArray jArray=new JSONArray(); backout1(sql,jArray); return jArray; } } public JSONObject backout1(int ID){ String sql = "select * from user_data"; ResultSet result = null; JSONObject jsonObject=new JSONObject(); try { result = connect.getStmt().executeQuery(sql); }catch (SQLException e) { e.printStackTrace(); } try { while(result.next()) { //ResultSet 对象具有指向其当前数据行的光标。 if (ID==result.getInt("id")) { jsonObject.put("username",result.getString("username")); //名字 jsonObject.put("sex",result.getString("sex")); //性别 int age = result.getInt("age"); //年龄 jsonObject.put("age",String.valueOf(age)); jsonObject.put("birthday",result.getString("birthday")); //生日 jsonObject.put("QQdata",result.getString("QQdata")); //QQ号 jsonObject.put("telephone",result.getString("telephone")); //电话 jsonObject.put("constellation",result.getString("constellation")); //星座 jsonObject.put("nativeplace",result.getString("nativeplace")); //籍贯 jsonObject.put("dream",result.getString("dream")); //梦想 jsonObject.put("address",result.getString("address")); //地址 jsonObject.put("hobby",result.getString("hobby")); //描述 jsonObject.put("message",result.getString("message")); //描述 return jsonObject; } } result.close(); }catch (SQLException e) { e.printStackTrace(); } return null; } public boolean localUpdata(){ int acff=0; try { System.out.println(sql_data); acff=connect.stmt.executeUpdate(sql_data); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(acff>0) return true; else return false; } protected void finalize(){ connect.disconnect(); } }