交通事故的记录与统计信息管理系统.zip

package com.dao.impl; import java.sql.Connection; import java.sql.Date; 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.dao.UserDao; import com.util.DBUtil; import com.pojo.Lili; import com.pojo.User; /** * * @author Administrator * */ public class UserDaoImpl implements UserDao { DBUtil db = new DBUtil(); Connection conn = db.openConnection(); PreparedStatement ps = null; public boolean login(User user) { String sql = "select username,password from lili where username=? and password=?"; try { ps = conn.prepareStatement(sql); ps.setString(1, user.getUsername()); ps.setString(2, user.getPassword()); ps.executeQuery(); ResultSet rs = ps.executeQuery(); while (rs.next()) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { db.closeConn(conn); } return false; } public void add(Lili lili) { String sql = "insert into zll values(null,?,?,?,?)"; try { ps = conn.prepareStatement(sql); ps.setString(2, lili.getAddress()); ps.setString(3, lili.getReason()); ps.setString(4, lili.getReasult()); ps.setString(1, lili.getTime()); ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { db.closeConn(conn); } } /** * @author Administrator * 淇敼璁板綍 */ public void modify(Lili lili) { String sql = "update zll set time=?,address=?,reason=?,reasult=? where id=?"; try { ps = conn.prepareStatement(sql); ps.setString(1, lili.getTime()); ps.setString(2, lili.getAddress()); ps.setString(3, lili.getReason()); ps.setString(4, lili.getReasult()); ps.setInt(5, lili.getId()); ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); System.out.println("淇敼鏁版嵁澶辫触锛�"); } finally { db.closeConn(conn); } } /** * @author Administrator * 鏌ユ壘涓�潯璁板綍 */ public Lili find(int id) { String sql = "select * from zll where id = ?"; Lili lili = new Lili(); try { System.out.println(id); ps = conn.prepareStatement(sql); ps.setInt(1, id); ps.executeQuery(); ResultSet rs = ps.executeQuery(); while (rs.next()) { lili.setId(rs.getInt("id")); lili.setTime(rs.getString("time")); lili.setAddress(rs.getString("address")); lili.setReason(rs.getString("reason")); lili.setReasult(rs.getString("reasult")); } } catch (Exception e) { e.printStackTrace(); System.out.println("鏌ヨ澶辫触锛�"); } finally { db.closeConn(conn); } return lili; } /** * * @author Administrator * 鍒犻櫎涓�潯璁板綍 */ public void delete(int id) { String sql = "delete from zll where id =?"; try { ps = conn.prepareStatement(sql); ps.setInt(1, id); ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { db.closeConn(conn); } } /** * @author Administrator * 鏌ヨ鎵�湁璁板綍 * */ public List<Lili> findAll() { String sql = "select * from zll"; List<Lili> list = new ArrayList<Lili>(); try { Statement ps = conn.createStatement(); ResultSet rs = ps.executeQuery(sql); while (rs.next()) { Lili lili = new Lili(); lili.setId(rs.getInt("id")); lili.setAddress(rs.getString("address")); lili.setReason(rs.getString("reason")); lili.setTime(rs.getString("time")); lili.setReasult(rs.getString("reasult")); list.add(lili); } } catch (Exception e) { e.printStackTrace(); } finally { db.closeConn(conn); } return list; } }