tocompadddao.java

实现银行系统中某个部门的计算机设备管理、公共信息管理、权限用户管理、系统设置等,为系统的安全正常运行提供保障

package com.isoftstone.banktearm1.dao;

import java.sql.*;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.StringTokenizer;

import com.isoftstone.banktearm1.db.DB;
import com.isoftstone.banktearm1.to.ToCompAddTo;
import com.isoftstone.banktearm1.vo.BankTeam1CompVo;
import com.isoftstone.banktearm1.vo.BankTeam1Dep2Vo;
import com.isoftstone.banktearm1.vo.BankTeam1DepVo;

public class ToCompAddDao extends DB
{
	public void ToCompAddDao(BankTeam1CompVo vo) throws Exception{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		ToCompAddDao a=new ToCompAddDao();
			int c=a.FindMax1()+1;
		System.out.println("insert into comp values("+c+","+0+",'"+vo.getComputerType()+"','"+vo.getCpu()+"','"+vo.getMemory()+"','"+vo.getHarddisk()+"','"+vo.getOs()+"','','','"+vo.getIpAddress()+"','"+vo.getMacAddress()+"',"+2+",'"+vo.getUserName()+"','','"+vo.getHouseId()+"','"+vo.getDutyPeople()+"','"+vo.getUse()+"','"+vo.getBuyTime()+"','"+vo.getUseTime()+"','"+vo.getWhichUse()+"')");
		stmt.executeUpdate("insert into comp values("+c+","+0+",'"+vo.getComputerType()+"','"+vo.getCpu()+"','"+vo.getMemory()+"','"+vo.getHarddisk()+"','"+vo.getOs()+"','','','"+vo.getIpAddress()+"','"+vo.getMacAddress()+"',"+2+",'"+vo.getUserName()+"','','"+vo.getHouseId()+"','"+vo.getDutyPeople()+"','"+vo.getUse()+"','"+vo.getBuyTime()+"','"+vo.getUseTime()+"','"+vo.getWhichUse()+"')");
		
		this.closs(stmt, cn);
	}
	public String FindDep()throws Exception
	  
	{  
		Connection cn=this.getConnection();
		BankTeam1CompVo vo=new BankTeam1CompVo();
		String str=vo.getDepid();
		System.out.println(str);
			StringTokenizer fenxi=new StringTokenizer(str,":");
			String varriqi=fenxi.nextToken();
			String kecheng=fenxi.nextToken();
			System.out.println(kecheng);
		Statement stmt=cn.createStatement();
		System.out.println(varriqi);
		System.out.println(kecheng);
		ResultSet rs=stmt.executeQuery("select * from dep where DepartmentName='"+kecheng+"'");
		String bb=null;
		while(rs.next())
		{
			 bb=rs.getString(2);
			
		}
		System.out.println(bb);
		
	   this.closs(rs, stmt, cn);
	   return bb;
		
	}
	public int FindMax()throws Exception
	{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		ResultSet rs=stmt.executeQuery("select max(NumberID) from comp");
		int n=0;
		while(rs.next())
		{
			 n=rs.getInt(1);
			
		}
		System.out.println(n);
		this.closs(rs, stmt, cn);
		return n;
		
	}
	public int Bianhao() throws Exception
	{
		ToCompAddDao a=new ToCompAddDao();
		int b=Integer.parseInt(a.FindDep());
		int c=a.FindMax();
		int d=b*10000+c%10000+1;
		System.out.println(d);
		return d;
	}
	public ArrayList getDepartment()throws Exception{
		ArrayList mylist=new ArrayList();
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		ResultSet rs=null;
		
		String sql="select distinct UnitName+':'+DepartmentName AS str, dep.DepartmentId from dep, unit"+
		           " where mid(dep.DepartmentId,1,2)=cstr(unit.unitid)";
		rs=stmt.executeQuery(sql);
		BankTeam1Dep2Vo vo=new BankTeam1Dep2Vo();
      while(rs.next()){
        	
        	vo.setDepartmentName(rs.getString(1));
            vo.setDepartmentId(Integer.parseInt(rs.getString(2)));
            System.out.println(vo.getDepartmentId());
            System.out.println(vo.getDepartmentName());
           mylist.add(vo);
           System.out.println("--------------");
			System.out.println();
		}		
        
		if(rs!=null){rs.close();}
		if(stmt!=null){stmt.close();}
		if(cn!=null){cn.close();}
		return mylist;
		}
	public int FindMax1()throws Exception
	{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		ResultSet rs=stmt.executeQuery("select max(ID) from comp");
		int n=0;
		while(rs.next())
		{
			 n=rs.getInt(1);
			
		}
		System.out.println(n);
		this.closs(rs, stmt, cn);
		return n;
		
	}
	public static void main(String args[]) throws Exception
	{
		ToCompAddDao a=new ToCompAddDao();
		a.getDepartment();
	}
}