DHY.zip_dhy 9977.com_dhy111166.com_dhy123.com_dhy6563. com

package com.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import com.bean.Servicebean; import db.DBConnection; public class Servicedao { private DBConnection dbcn = new DBConnection();// 实例化数据库基本操作类 public int add(Servicebean service) {// 增加操作 int i = 0; String sql = "insert into service(seid,name,address,duration,introduce,time,peoneed,peo) " + "values('" +service.getSeid() + ",'" +service.getName()+ ",'" +service.getAddress()+ ",'" +service.getDuration()+ ",'" +service.getIntroduce()+ ",'" +service.getTime() + ",'" +service.getPeoneed()+ ",'" +service.getPeo() + "')"; dbcn.connect(); i = dbcn.executeUpdate(sql); dbcn.connectionClose(); return i; } public int update(Servicebean service) {// 更新操作 int i = 0; String sql = "update service set " +"name='" +service.getName()+ "'," +"address='" +service.getAddress()+ "'," +"introduce='" +service.getIntroduce()+ "',time='" +service.getTime() + "',peoneed=" +service.getPeoneed()+ "'"; dbcn.connect(); i = dbcn.executeUpdate(sql); dbcn.connectionClose(); return i; } public int delete(Servicebean service) {// 删除操作 int i = 0; String sql = "delete from service " + " where seid='" + service.getSeid() + "'"; dbcn.connect(); i = dbcn.executeUpdate(sql); dbcn.connectionClose(); return i; } public Servicebean findByseid(String seid) { String sql = "select * from service " + " where seid='" + seid + "' "; dbcn.connect(); ResultSet rs = dbcn.select(sql); Servicebean service = new Servicebean(); try { if (rs.next()) { service.setSeid(rs.getInt(1)); service.setName(rs.getString(2)); service.setAddress(rs.getString(3)); service.setDuration(rs.getString(4)); service.setIntroduce(rs.getString(5)); service.setTime(rs.getString(6)); service.setPeoneed(rs.getInt(7)); service.setPeo(rs.getInt(8)); return service; } else { return null; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { dbcn.connectionClose(); } } public ArrayList findAll() {// 查找所有 String sql = "select * from service order by time desc"; dbcn.connect(); ResultSet rs = dbcn.select(sql); try { ArrayList allData = new ArrayList(); while (rs.next()) { Servicebean service = new Servicebean(); service.setSeid(rs.getInt(1)); service.setName(rs.getString(2)); service.setAddress(rs.getString(3)); service.setDuration(rs.getString(4)); service.setIntroduce(rs.getString(5)); service.setTime(rs.getString(6)); service.setPeoneed(rs.getInt(7)); service.setPeo(rs.getInt(8)); allData.add(service); } return allData; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { dbcn.connectionClose(); } } public ArrayList findLikeSeid(String isbn) {// 通过isbn模糊查找 String sql = "select * from service " + " where isbn like '%" + isbn + "%' order by adddate desc"; dbcn.connect(); ResultSet rs = dbcn.select(sql); try { ArrayList allData = new ArrayList(); while (rs.next()) { Servicebean service = new Servicebean(); service.setSeid(rs.getInt(1)); service.setName(rs.getString(2)); service.setAddress(rs.getString(3)); service.setDuration(rs.getString(4)); service.setIntroduce(rs.getString(5)); service.setTime(rs.getString(6)); service.setPeoneed(rs.getInt(7)); service.setPeo(rs.getInt(8)); allData.add(service); } return allData; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { dbcn.connectionClose(); } } }