jsp+servlet+eclipse+mysql(包含源码和数据库)

package com.jsp.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.jsp.util.ConnectionUtils; import com.jsp.vo.Client; public class clientDaoImp implements clientDao { @Override public List<Client> findClientsByName(String clientname) { Connection conn = ConnectionUtils.getConnection(); String sql = "select * from client where clientname like '%"+clientname+"%'"; List<Client> list = new ArrayList<Client>(); try { Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { Client client = new Client(); client.setClientid(rs.getString("clientid")); client.setClientname(rs.getString("clientname")); client.setReducemode(rs.getString("reducemode")); client.setChoice(rs.getString("choice")); client.setAddress(rs.getString("address")); client.setLinkman(rs.getString("linkman")); client.setLinkphone(rs.getString("linkphone")); client.setPaymentmode(rs.getString("paymentmode")); client.setPri(rs.getString("pri")); list.add(client); } } catch (SQLException e) { e.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return list; } @Override public boolean addClient(Client client) { Connection conn = ConnectionUtils.getConnection(); String sql = "insert into client(clientid,clientname,reducemode,choice,address,linkman,linkphone,paymentmode,pri) values(?,?,?,?,?,?,?,?,?)"; try{ conn.setAutoCommit(false); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, client.getClientid()); pstmt.setString(2, client.getClientname()); pstmt.setString(3, client.getReducemode()); pstmt.setString(4, client.getChoice()); pstmt.setString(5, client.getAddress()); pstmt.setString(6, client.getLinkman()); pstmt.setString(7, client.getLinkphone()); pstmt.setString(8, client.getPaymentmode()); System.out.println(client.getPaymentmode()); pstmt.setString(9, client.getPri()); int i = pstmt.executeUpdate(); if (i == 1) { conn.commit(); return true; } }catch (Exception e) { try { conn.rollback(); } catch (SQLException e1) { e1.printStackTrace(); } }finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; } @Override public boolean delClient(String[] clientid) { Connection conn = ConnectionUtils.getConnection(); String str =""; for(int i=0;i<clientid.length;i++){ if(i==clientid.length-1){ str=str+"'"+clientid[i]+"'"; }else{ str=str+"'"+clientid[i]+"',"; } } String sql = "delete from client where clientid in("+str+")"; try { conn.setAutoCommit(false); Statement stmt = conn.createStatement(); int i = stmt.executeUpdate(sql); System.out.println("所影响的记录数为"+i); if (i >= 1) { conn.commit(); return true; } } catch (SQLException e) { try { conn.rollback(); } catch (SQLException e1) { e1.printStackTrace(); } e.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; } @Override public List<Client> listClients() { Connection conn = ConnectionUtils.getConnection(); String sql = "select * from client"; List<Client> list = new ArrayList<Client>(); try { Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { Client client = new Client(); //clientid,clientname,reducemode,choice,address,linkman,linkphone,paymentmode,pri client.setClientid(rs.getString("clientid")); client.setClientname(rs.getString("clientname")); client.setReducemode(rs.getString("reducemode")); client.setChoice(rs.getString("choice")); client.setAddress(rs.getString("address")); client.setLinkman(rs.getString("linkman")); client.setLinkphone(rs.getString("linkphone")); client.setPaymentmode(rs.getString("paymentmode")); client.setPri(rs.getString("pri")); list.add(client); } } catch (SQLException e) { e.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return list; } @Override public boolean modClient(Client client) { Connection conn = ConnectionUtils.getConnection(); String sql = "update client set clientname='"+client.getClientname()+"',reducemode='"+client.getReducemode()+"',choice='" +client.getChoice()+"',address='"+client.getAddress()+"',linkman='"+client.getLinkman()+"',linkphone='" +client.getLinkphone()+"',paymentmode='"+client.getPaymentmode()+"',pri='"+client.getPri()+"' where clientid='" +client.getClientid()+"'"; System.out.println(sql); try { conn.setAutoCommit(false); Statement stmt = conn.createStatement(); int i = stmt.executeUpdate(sql); System.out.println("所影响的记录数为"+i); if (i == 1) { conn.commit(); return true; } } catch (SQLException e) { try { conn.rollback(); } catch (SQLException e1) { e1.printStackTrace(); } e.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; } public Client findClientById(String clientid) { Connection conn = ConnectionUtils.getConnection(); String sql = "select * from client where clientid="+clientid ; Client client = null; try { Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { client = new Client(); //clientid,clientname,reducemode,choice,address,linkman,linkphone,paymentmode,pri client.setClientid(rs.getString("clientid")); client.setClientname(rs.getString("clientname")); client.setReducemode(rs.getString("reducemode")); client.setChoice(rs.getString("choice")); client.setAddress(rs.getString("address")); client.setLinkman(rs.getString("linkman")); client.setLinkphone(rs.getString("linkphone")); client.setPaymentmode(rs.getString("paymentmode")); client.setPri(rs.getString("pri")); } } catch (SQLException e) { e.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return client; } }