毕业设计：基于jsp的药品进销存管理系统

package com.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.dbhelp.DBHelp; import com.data.OrderformInfo; public class OrderformDaoImpl implements OrderformDao { public List<OrderformInfo> findAllOrderforms(String userId,String orderState) { String sql="select * from orderforminfo where USER_ID=? and ORDER_STATE=?"; ResultSet rs = new DBHelp().queryMsg(sql,userId,orderState); List<OrderformInfo> orderforms = new ArrayList<OrderformInfo>(); try { while(rs.next()){ OrderformInfo orderform = new OrderformInfo(); orderform.setOrderNo(rs.getString("ORDER_NO")); orderform.setUserId(rs.getString("USER_ID")); orderform.setConsigneeName(rs.getString("CONSIGNEE_NAME")); orderform.setConsigneeTel(rs.getString("CONSIGNEE_TEL")); orderform.setConsigneeAddress(rs.getString("CONSIGNEE_ADDRESS")); orderform.setMedNo(rs.getString("MED_NO")); orderform.setMedName(rs.getString("MED_NAME")); orderform.setIhealthPrice(rs.getString("IHEALTH_PRICE")); orderform.setBuyNum(rs.getString("BUY_NUM")); orderform.setTotalPrice(rs.getString("TOTAL_PRICE")); orderform.setDelivery(rs.getString("DELIVERY")); orderform.setOrderState(rs.getString("ORDER_STATE")); orderforms.add(orderform); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return orderforms; } @Override public OrderformInfo findOrderform(String userId, String medNo, String orderState) { // TODO Auto-generated method stub String sql="select * from orderforminfo where USER_ID=? and MED_NO=? and ORDER_STATE=?"; ResultSet rs = new DBHelp().queryMsg(sql,userId,medNo,orderState); OrderformInfo orderform = new OrderformInfo(); try { while(rs.next()){ orderform.setOrderNo(rs.getString("ORDER_NO")); orderform.setUserId(rs.getString("USER_ID")); orderform.setConsigneeName(rs.getString("CONSIGNEE_NAME")); orderform.setConsigneeTel(rs.getString("CONSIGNEE_TEL")); orderform.setConsigneeAddress(rs.getString("CONSIGNEE_ADDRESS")); orderform.setMedNo(rs.getString("MED_NO")); orderform.setMedName(rs.getString("MED_NAME")); orderform.setIhealthPrice(rs.getString("IHEALTH_PRICE")); orderform.setBuyNum(rs.getString("BUY_NUM")); orderform.setTotalPrice(rs.getString("TOTAL_PRICE")); orderform.setDelivery(rs.getString("DELIVERY")); orderform.setOrderState(rs.getString("ORDER_STATE")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return orderform; } @Override public boolean deleteOrderform(String orderNo) { // TODO Auto-generated method stub String sql = "delete from orderforminfo where ORDER_NO = ?"; boolean boo = new DBHelp().exeSQL(sql,orderNo); return boo; } @Override public boolean updateOrderformMedicineNum(String orderNo, String buyNum) { // TODO Auto-generated method stub String sql = "update orderforminfo set BUY_NUM = ?,TOTAL_PRICE = IHEALTH_PRICE*? where ORDER_NO = ?"; boolean boo = new DBHelp().exeSQL(sql,buyNum,buyNum,orderNo); return boo; } @Override public boolean updateOrderformConsignee(String userId,String consigneeName, String consigneeTel,String consigneeAddress,String delivery) { String sql = "update orderforminfo set CONSIGNEE_NAME = ?,CONSIGNEE_TEL = ?,CONSIGNEE_ADDRESS = ?,DELIVERY = ? where USER_ID = ?"; boolean boo = new DBHelp().exeSQL(sql,consigneeName,consigneeTel,consigneeAddress,delivery,userId); return boo; } @Override public boolean updateOrderformState(String userId, String orderState) { // TODO Auto-generated method stub String sql = "update orderforminfo set ORDER_STATE = ? where USER_ID = ?"; boolean boo = new DBHelp().exeSQL(sql,orderState,userId); return boo; } @Override public boolean AddOrderform(String orderNo, String userId, String consigneeName, String consigneeTel, String consigneeAddress, String medNo, String medName, String ihealthPrice, String buyNum, String totalPrice, String delivery, String orderState) { // TODO Auto-generated method stub String sql = "insert into orderforminfo values(?,?,?,?,?,?,?,?,?,?,?,?)"; boolean boo = new DBHelp().exeSQL(sql,orderNo,userId,consigneeName,consigneeTel, consigneeAddress,medNo,medName,ihealthPrice,buyNum,totalPrice,delivery,orderState); return boo; } public static void main(String[] args) { System.out.println(new OrderformDaoImpl().findAllOrderforms("1","0").size()); System.out.println(new OrderformDaoImpl().deleteOrderform("4")); System.out.println(new OrderformDaoImpl().updateOrderformMedicineNum("6", "7")); System.out.println(new OrderformDaoImpl().updateOrderformConsignee("1", "liang", "15110401917", "shanxi", "shunfeng")); System.out.println(new OrderformDaoImpl().updateOrderformState("sd", "0")); String orderno = String.valueOf(System.currentTimeMillis()); System.out.println(new OrderformDaoImpl().AddOrderform(orderno, "1", "250", "123456", "shanxi", "001","asdfasdf", "30", "10", "300", "shengtong", "0")); System.out.println("num:"+new OrderformDaoImpl().findOrderform("250", "001", "0").getOrderNo()); } }