tht.rar_生产 跟踪

package com.thtbase.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Collection; import com.thtbase.entity.Record; import com.thtbase.util.JdbcFactory; public class ProductDaoImpl implements ProductDao{ public boolean insert(Record r)throws Exception { Connection conn = JdbcFactory.getConnection(); PreparedStatement stm = null; String sql = "insert into thtbase values(tht_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; stm = conn.prepareStatement(sql); stm.setString(1, r.getSn()); stm.setString(2, r.getPn()); stm.setString(3, r.getType()); stm.setString(4, r.getSPEC()); stm.setString(5, r.getProductDate()); stm.setString(6, r.getGuestName()); stm.setString(7, r.getContractNumber()); stm.setString(8, r.getROMO()); stm.setString(9, r.getDate()); stm.setString(10, r.getROMO1()); stm.setString(11, r.getDate1()); stm.setString(12, r.getROMO2()); stm.setString(13, r.getDate2()); stm.setString(14, r.getShipmentsDate()); stm.setString(15, r.getRecord()); stm.setString(16, r.getRepareDate()); stm.execute(); return true; } public Collection<Record> query(String sn) throws Exception{ Connection conn = JdbcFactory.getConnection(); PreparedStatement stm = null; ResultSet ret = null; String sql = "select id,sn,pn,type,SPEC,pDate,gName,cNumber,ROMO,date1,ROMO1,date2,ROMO2,date3,sdate,record,rdate from thtbase where sn=?"; stm = conn.prepareStatement(sql); stm.setString(1, sn); ret = stm.executeQuery(); Collection col = new ArrayList(); Record record = null; while(ret.next()){ record = new Record(); record.setId(ret.getInt(1)); record.setSn(ret.getString(2)); record.setPn(ret.getString(3)); record.setType(ret.getString(4)); record.setSPEC(ret.getString(5)); record.setProductDate(ret.getString(6)); record.setGuestName(ret.getString(7)); record.setContractNumber(ret.getString(8)); record.setROMO(ret.getString(9)); record.setDate(ret.getString(10)); record.setROMO1(ret.getString(11)); record.setDate1(ret.getString(12)); record.setROMO2(ret.getString(13)); record.setDate2(ret.getString(14)); record.setShipmentsDate(ret.getString(15)); record.setRecord(ret.getString(16)); record.setRepareDate(ret.getString(17)); col.add(record); } return col; } public Record queryById(Integer id) throws Exception{ Connection conn = JdbcFactory.getConnection(); PreparedStatement stm = null; ResultSet ret = null; String sql = "select id,sn,pn,type,SPEC,pDate,gName,cNumber,ROMO,date1,ROMO1,date2,ROMO2,date3,sdate,record,rdate from thtbase where id=? order by id desc"; stm = conn.prepareStatement(sql); stm.setInt(1, id); ret = stm.executeQuery(); Record record = null; while(ret.next()){ record = new Record(); record.setId(ret.getInt(1)); record.setSn(ret.getString(2)); record.setPn(ret.getString(3)); record.setType(ret.getString(4)); record.setSPEC(ret.getString(5)); record.setProductDate(ret.getString(6)); record.setGuestName(ret.getString(7)); record.setContractNumber(ret.getString(8)); record.setROMO(ret.getString(9)); record.setDate(ret.getString(10)); record.setROMO1(ret.getString(11)); record.setDate1(ret.getString(12)); record.setROMO2(ret.getString(13)); record.setDate2(ret.getString(14)); record.setShipmentsDate(ret.getString(15)); record.setRecord(ret.getString(16)); record.setRepareDate(ret.getString(17)); } return record; } public boolean deleteById(Integer id) { Connection conn = JdbcFactory.getConnection(); PreparedStatement stm = null; String sql ="delete from thtbase where id=?"; try { stm = conn.prepareStatement(sql); stm.setInt(1, id); stm.execute(); return true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return false; } } }