dongtai.java

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

package com.isoftstone.banktearm1.dao;
import java.sql.*;
import java.util.ArrayList;
import java.util.Date;

import com.isoftstone.banktearm1.vo.*;	
import com.isoftstone.banktearm1.db.DB;
public class DongTai extends DB {

	public ArrayList dongTai()throws Exception{
		ArrayList list=new ArrayList();
		Connection con=this.getConnection();
		Statement stmt=con.createStatement();
		ResultSet rs=stmt.executeQuery("SELECT DISTINCT UnitName+':'+DepartmentName AS str, dep.DepartmentId FROM dep, unit WHERE mid(dep.DepartmentId,1,2)=cstr(unit.unitid)");
		while(rs.next()){
			XinjianVo1 m=new XinjianVo1();
			m.setStr(rs.getString(1));
			m.setDepartmentID(rs.getInt(2));
			list.add(m);
			
			
			
			
		}
		if(rs!=null)
			rs.close();
		if(stmt!=null)
		stmt.close();
		if(con!=null)
		con.close();
		return list;
		
	}
	public int getIdId(){
		int a=0;
		try{
	    Connection con=this.getConnection();
		Statement stmt=con.createStatement();
		ResultSet rs=stmt.executeQuery("select max(ID)+1 from emp");
		rs.next();
	    a=rs.getInt(1);
	    if(rs!=null)
			rs.close();
		if(stmt!=null)
		stmt.close();
		if(con!=null)
		con.close();
		}
		catch (Exception f){f.printStackTrace();}
		return a;
	}
	public void tianJia(BankTeam1EmpVo vo){
		try{ Connection con=this.getConnection();
		Statement stmt=con.createStatement();
		
		int a=vo.getId() ;
		int b=vo.getWorkerId();
		String c=vo.getName();
		String d=vo.getSex();
		String e=vo.getBirthday();
		String f=vo.getDepartment();
		String g=vo.getJobName();
		String h=vo.getPassword();System.out.println("insert into emp values("+a+","+b+",'"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"')");
		stmt.executeUpdate("insert into emp values("+a+","+b+",'"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"')");
	
	if(stmt!=null)
	stmt.close();
	if(con!=null)
	con.close();
		}
		catch(Exception g){g.printStackTrace();}
		
	}
  public int getWorkID()
  {int a=0;
	try{ 
		Connection con=this.getConnection();
		Statement stmt=con.createStatement();
		ResultSet rs=stmt.executeQuery("select WorkerID from emp");
		int temp=1;
		while(rs.next()){ 
			int temp1=rs.getInt(1)%1000;
			if(temp<temp1){ 
				temp=temp1;
			}
		}
		a=temp+1;
	   if(rs!=null)
			rs.close();
		if(stmt!=null)
		stmt.close();
		if(con!=null)
		con.close();
	   }
	   catch(Exception e){e.printStackTrace();}
		
		 return a;
  }


}