cmpadddao.java

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

package com.isoftstone.banktearm1.dao;

import java.sql.*;

import com.isoftstone.banktearm1.db.DB;
import com.isoftstone.banktearm1.vo.BankTeam1CompVo2;

public class CmpAddDao extends DB {
	public void addCmp(BankTeam1CompVo2 vo) throws SQLException, ClassNotFoundException{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		System.out.println("insert into comp values("+vo.getId()+","+vo.getNumberId()+",'"+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("+vo.getId()+","+vo.getNumberId()+",'"+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 int FindMaxId()throws Exception
	{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		ResultSet rs=stmt.executeQuery("select max(ID)+1 as maxid from comp");
		int n=0;
		rs.next();
	    n=rs.getInt("maxid");

		this.closs(rs, stmt, cn);
		return n;
	}
	public int getNextCmpNumber(String deptId)throws Exception{
		Connection cn= this.getConnection();
		Statement stmt=cn.createStatement();
		String sql="select cstr(max(mid(cstr(NumberID),5,6))) as a from comp";
	    ResultSet rs = stmt.executeQuery(sql);
	    rs.next();
	    String maxid=rs.getString("a");
	    String maxid2="";
	    int i=Integer.parseInt(maxid)+1;
	    if(i<10){
	    	maxid2="0"+String.valueOf(i);
	    }
	    else{
	    	maxid2=String.valueOf(i);
	    }
	    String workId=deptId+maxid2;
		if(stmt!=null){
			stmt.close();
			}
		if(cn!=null){
			cn.close();
			}
		return  Integer.parseInt(workId);
	}
}