planjdbc.java

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

package com.gensou.dao.sheji.plan;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.gensou.logic.View.BuliaotongjiService;
import com.gensou.logic.View.QueryViewService;
import com.gensou.util.DBHelp;


public class PlanJDBC {
   public List addplansucai(Integer id){
	    List list=new ArrayList();
		DBHelp db=DBHelp.getInstance();
		Connection con=db.getConnection("DAO");
	   try{
			Statement stm=con.createStatement();
			ResultSet rs=stm.executeQuery("select peijianxinxi_id,pinming,caizhi,guige,sum(heji) pheji from peijiantongjis where id="+id+" group by peijianxinxi_id");
			while(rs.next()){
				QueryViewService query=new QueryViewService();
				query.setCaizhi(rs.getString("caizhi"));
				query.setGuige(rs.getString("guige"));
				query.setHeji(rs.getInt("pheji"));
				query.setPeijianxinxiId(rs.getString("peijianxinxi_id"));
				query.setPinming(rs.getString("pinming"));
				list.add(query);
			   }
			stm.close();
			db.freeConnection("DAO",con);
			
	   }catch(Exception e){
		   e.printStackTrace();
		   db.freeConnection("DAO",con);
	   }
			return list; 
   }
   
   public List querysucaiplan(Integer id,int bili){
	   List lists=new ArrayList();
	   List list=addplansucai(id);
	   for(int i=0;i<list.size();i++){
		   QueryViewService query=(QueryViewService)list.get(i);
		   int hiji=query.getHeji()*bili/100;
		   if(hiji==0){
			   hiji=1;
		   }
		   query.setHeji((query.getHeji()+hiji));
		   lists.add(query);
	   }
	return lists;
   }
   
   public List addbuliao(Integer id){
	    List list=new ArrayList();
		DBHelp db=DBHelp.getInstance();
		Connection con=db.getConnection("DAO");
	   try{
			Statement stm=con.createStatement();
			ResultSet rs=stm.executeQuery("select * from buliaoheji where id="+id+"");
			while(rs.next()){
				BuliaotongjiService query=new BuliaotongjiService();
				query.setBuguige(rs.getString("buguige"));
				query.setHeji(rs.getLong("yubuliang"));
				query.setSucaixinxiid(rs.getString("sucaixinxi_id"));
				list.add(query);
			   }
			stm.close();
			db.freeConnection("DAO",con);
			
	   }catch(Exception e){
		   e.printStackTrace();
		   db.freeConnection("DAO",con);
	   }
			return list; 
  }
  
  public List querybuliao(Integer id,int bili){
	   List lists=new ArrayList();
	   List list=addbuliao(id);
	   for(int i=0;i<list.size();i++){
		   BuliaotongjiService query=(BuliaotongjiService)list.get(i);
		   double buliang=query.getHeji();
		   int yongbu=(int)buliang;
		   System.out.println(yongbu);
		   yongbu=yongbu+(yongbu*bili/100+1);
		   System.out.println(yongbu);
		   buliang=(double)yongbu;
		   System.out.println(buliang);
		   query.setHeji(buliang);
		   lists.add(query);
	   }
	return lists;
  }
   
  /*public static void main(String[] arge){
	  Integer id=11;
	  int bili=10;
	  List list=querybuliao(id,bili);
	  for(int i=0;i<list.size();i++){
		  BuliaotongjiService query=(BuliaotongjiService)list.get(i);
		  System.out.print(query.getSucaixinxiid()+" ");
		  System.out.println(query.getHeji()); 
		  
	  }
		  
  }*/
}