mvc模式个人信息管理系统

package com.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.bean.FileBean; import com.bean.TelephoneBean; public class Telephone_DB { private DB mydb; private ResultSet rs; public Telephone_DB() { mydb = new DB(); } public List<TelephoneBean> select(int page, int pageSize, String id) throws SQLException { List<TelephoneBean> list = new ArrayList<TelephoneBean>(); String sql = "select * from telephone where ID='" + id + "'order by telephonename limit " + (page-1)* pageSize + "," + pageSize + " "; mydb.dostm(sql); rs = mydb.getRs(); while (rs.next()) { TelephoneBean bean = new TelephoneBean(); bean.setEmail(rs.getString("email")); bean.setHome(rs.getString("home")); bean.setQQ(rs.getString("QQ")); bean.setTelephone(rs.getString("telephone")); bean.setWork(rs.getString("work")); bean.setTelephonename(rs.getString("telephonename")); list.add(bean); } mydb.closed(); return list; } public boolean insert(TelephoneBean bean, String id) throws SQLException { String name = bean.getTelephonename(); String telephone = bean.getTelephone(); String email = bean.getEmail(); String work = bean.getWork(); String home = bean.getHome(); String qq = bean.getQQ(); String sql1 = "select * from telephone where telephonename='" + name + "'and ID='" + id + "'"; mydb.dostm(sql1); rs = mydb.getRs(); if (rs.next()) { mydb.closed(); return false; } String sql2 = "insert into telephone values('" + id + "','" + name + "','" + telephone + "','" + email + "','" + work + "','" + home + "','" + qq + "')"; mydb.dostm(sql2); mydb.closed(); return true; } public boolean update(TelephoneBean bean, String id) throws SQLException { String name = bean.getTelephonename(); String telephone = bean.getTelephone(); String email = bean.getEmail(); String work = bean.getWork(); String home = bean.getHome(); String qq = bean.getQQ(); String sql1 = "select * from telephone where ID='" + id + "'and telephonename='" + name + "'"; mydb.dostm(sql1); rs = mydb.getRs(); if (rs.next()) { String sql2 = "update telephone set telephone='" + telephone + "',email='" + email + "',work='" + work + "',home='" + home + "',QQ='" + qq + "'where telephonename='" + name + "'and ID='" + id + "'"; mydb.dostm(sql2); return true; } mydb.closed(); return false; } public void delete(String id, String name) { String sql = "delete from telephone where ID='" + id + "'and telephonename='" + name + "'"; mydb.dostm(sql); mydb.closed(); } }