Jsp GridView(代数据库)

package org.qhit.webdemo.operations; import java.sql.*; import java.util.*; import org.qhit.webdemo.common.*; import org.qhit.webdemo.beans.*; public class OperUproc { private Connection conn; public OperUproc(){ conn=new GetDB().getConn(); } public boolean doIstUproc(UprocBean ub){ boolean bol=false; try{ String sqlStr="insert Uproc values('"+ub.getUpName()+"','"+ub.getUpSex()+"',"+ub.getUpAge()+",'"+ub.getUpType()+"')"; Statement stat=conn.createStatement(); int num=stat.executeUpdate(sqlStr); if(num>0) bol=true; }catch(Exception e){ System.out.println("添加数据失败"+e); } return bol; } public boolean doUpd(UprocBean ub){ boolean bol=false; try{ String sqlStr="update Uproc set UpName='"+ub.getUpName()+"',UpSex='"+ub.getUpSex()+"',UpAge="+ub.getUpAge()+",UpType='"+ub.getUpType()+"' where UpId="+ub.getUpId(); System.out.println(sqlStr); Statement stat=conn.createStatement(); int num=stat.executeUpdate(sqlStr); if(num>0) bol=true; }catch(Exception e){ System.out.println("修改数据失败"+e); } return bol; } public boolean doDel(int id){ boolean bol=false; try{ String sqlStr="delete from Uproc where UpId="+id; Statement stat=conn.createStatement(); int num=stat.executeUpdate(sqlStr); if(num>0) bol=true; }catch(Exception e){ System.out.println("删除数据失败"+e); } return bol; } public Vector getAllData(){ Vector v=new Vector(); try{ Statement stat=conn.createStatement(); ResultSet rs=stat.executeQuery("select * from Uproc"); while(rs.next()){ UprocBean ub=new UprocBean(); ub.setUpId(rs.getInt(1)); ub.setUpName(rs.getString(2)); ub.setUpSex(rs.getString(3)); ub.setUpAge(rs.getInt(4)); ub.setUpType(rs.getString(5)); v.addElement(ub); } }catch(Exception e){ System.out.println("删除数据失败"+e); } return v; } }