commdao.java

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

package com.isoftstone.banktearm1.dao;
/*
 * 公共类,用于04作成
 */
import com.isoftstone.banktearm1.db.DB;
import com.isoftstone.banktearm1.vo.BankTeam1EmpVo;

import java.sql.*;
public class CommDao extends DB {
	public void executeSql(String sql) throws SQLException, ClassNotFoundException{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		stmt.execute(sql);
		if(stmt!=null){
			stmt.close();
		}
		if(cn!=null){
			cn.close();
		}
	}
	public BankTeam1EmpVo isEmp(String workerId,String password)throws SQLException, ClassNotFoundException{
		BankTeam1EmpVo myvo=new BankTeam1EmpVo();
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		ResultSet rs;
		String sql="select * from emp where WorkerID="+Integer.parseInt(workerId);
		rs=stmt.executeQuery(sql);
		if(rs.next()){
			if(password.equals(rs.getString("password"))){
				myvo.setId(rs.getInt("id"));
				myvo.setWorkerId(rs.getInt("WorkerID"));
				myvo.setName(rs.getString("Name"));
				myvo.setSex(rs.getString("sex"));
				myvo.setBirthday(rs.getDate("Birthday"));
				myvo.setDepartment(rs.getString("department"));
				myvo.setJobName(rs.getString("JobName"));
				myvo.setPassword(password);
			}
			else{
				throw new SQLException("用户密码错误,请重新输入");
			}
		}
		else{
			throw new SQLException("没有此用户");
		}
		if(rs!=null){
			rs.close();
		}
		if(stmt!=null){
			stmt.close();
		}
		if(cn!=null){
			cn.close();
		}
		return myvo;
	}
}