jsp基础JDBC小项目

/** * */ package model.dao; /** * @author Administrator * */ import java.sql.*; import java.util.*; import model.entity.*; public class StorageDao extends BaseDao { private Connection con = null; private PreparedStatement pstmt = null; private ResultSet rs = null; private String sql = ""; /** * 向数据库中插入一条记录 */ public boolean insertStor(Storage stor){ sql = "INSERT INTO　TBL_STORAGE VALUES(?,"+stor.getPrice()+",?,?,?,?)"; String[] param = {stor.getName(),stor.getType(), ""+stor.getNumber(),stor.getMakeTime(), ""+stor.getUseDay()}; return this.executeSql(sql, param); } /** * 从数据库中删除一条记录 */ public boolean deleteStor(int id){ sql = "DELETE FROM TBL_STORAGE WHERE id="+id; return this.executeSql(sql, null); } /** * 更新一条记录 */ public boolean updateStor(Storage stor){ sql = "UPDATE TBL_STORAGE SET name=?,price="+stor.getPrice() +",type=?,number=?,makeTime=?,useDay=? WHERE id=?"; String[] param = {stor.getName(),stor.getType(), ""+stor.getNumber(),stor.getMakeTime(), ""+stor.getUseDay(),""+stor.getId()}; return this.executeSql(sql, param); } /** * 按照主键查询记录 */ public Storage findStor(int id){ sql = "SELECT * FROM TBL_STORAGE WHERE id = "+id; Storage stor = null; try { con = this.getCon(); pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); if (rs.next()) { //实例化对象 stor = new Storage(); //给对象封装相关属性值 stor.setId(id); stor.setName(rs.getString(2)); stor.setPrice(rs.getFloat(3)); stor.setType(rs.getString(4)); stor.setNumber(rs.getInt(5)); stor.setMakeTime(rs.getString(6)); stor.setUseDay(rs.getInt(7)); } } catch (Exception e) { // TODO: handle exception System.out.println("StorageDao.findStor(id)出现异常"+e); }finally{ this.closeAll(rs, pstmt, con); } return stor; } /** * 查询所有记录 */ public List findStor(){ sql = "SELECT * FROM TBL_STORAGE"; List list = new ArrayList(); try { con = this.getCon(); pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { //**************实例化对象********************** Storage stor = new Storage(); //给对象封装相关属性值 stor.setId(rs.getInt(1)); stor.setName(rs.getString(2)); stor.setPrice(rs.getFloat(3)); stor.setType(rs.getString(4)); stor.setNumber(rs.getInt(5)); stor.setMakeTime(rs.getString(6)); stor.setUseDay(rs.getInt(7)); list.add(stor);//把已经封装好的对象放到List中 } } catch (Exception e) { // TODO: handle exception System.out.println("StorageDao.findStor()出现异常"+e); }finally{ this.closeAll(rs, pstmt, con); } return list; } }