package BeanPackage;
import java.sql.*;
public class Staff {
String name,sex,department,profession; //员工基本信息
int id,age;
Connection con;
Statement sql;
ResultSet rs;
public Staff()
{
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //用纯java方式加载数据库
}
catch(Exception e){
System.out.println("加载数据库失败。 错误信息："+e); //抛出异常信息
}
}
public void getMessage(int id)
{
try{
String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=factory"; //数据库的链接
con=DriverManager.getConnection(uri,"Staff","54321"); //员工用户登陆数据库
sql=con.createStatement(); //创建对象
rs=sql.executeQuery("SELECT * FROM Staff WHERE ID=this.id"); //查询该员工的所有基本信息
}
catch(Exception e){
System.out.println("链接数据库失败。 错误信息："+e);
}
}
public void setId() //设置id，id项员工不可修改
{
try {
id=rs.getInt(1);
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setName(String name)
{
try {
if(this.name.equals(rs.getString(2))){ //判断名字是否被修改，被修改则进而修改数据库中对应的项目
name=this.name;
}
else {
int m=sql.executeUpdate("UPDATE Staff SET Name='"+this.name+"' WHERE ID=id");
}
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setSex(String sex)
{
try {
if(this.sex.equals(rs.getString(3))){
sex=this.sex;
}
else {
int m=sql.executeUpdate("UPDATE Staff SET Sex='"+this.sex+"' WHERE ID=id");
}
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setDepartment(String department)
{
try {
if(this.department.equals(rs.getString(5))){
department=this.department;
}
else {
int m=sql.executeUpdate("UPDATE Staff SET Department='"+this.department+"' WHERE ID=id");
}
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setProfession(String profession)
{
try {
if(this.profession.equals(rs.getString(6))){
profession=this.profession;
}
else {
int m=sql.executeUpdate("UPDATE Staff SET Profession='"+this.profession+"' WHERE ID=id");
}
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setAge(int age)
{
try {
if(this.age==rs.getInt(4)){
age=this.age;
}
else {
int m=sql.executeUpdate("UPDATE Staff SET Age='"+this.age+"' WHERE ID=id");
}
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public int getId()
{
return id;
}
public String getName()
{
return name;
}
public String getSex()
{
return sex;
}
public String getDepartment()
{
return department;
}
public int getAge()
{
return age;
}
public String getProfession()
{
return profession;
}
int month,absence;
float salary,basesalary,premium;
ResultSet ra,re;
public void setMonth(int month)
{
month=this.month;
int n=month+2;
try {
ra=sql.executeQuery("SELECT * FROM Attendance WHERE Id=id");
absence=ra.getInt(n);
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setSalary()
{
try
{
re=sql.executeQuery("SELECT * FROM Salary WHERE Id=id");
if(absence==0)
{
sql.executeUpdate("UPDATE Salary SET NoAbsence=200 WHERE ID=id");
salary=re.getFloat(3)+re.getFloat(4)+200;
}
else
{
salary=re.getFloat(3)+re.getFloat(4)-absence*50;
}
sql.executeUpdate("UPDATE Salary SET Salary='"+salary+"' WHERE ID=id");
}
catch (SQLException e)
{
System.out.println("错误信息："+e);
}
}
public void setBasesalary()
{
try {
basesalary=re.getFloat(3);
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public void setPremium()
{
try {
premium=re.getFloat(4);
}
catch (SQLException e) {
System.out.println("错误信息："+e);
}
}
public float getBasesalary()
{
return basesalary;
}
public float getpremium()
{
return premium;
}
public float getSalary()
{
return salary;
}
}
database.zip （25个子文件） 
database 
SalaryManager.mdf 3MB SalaryManager_log.ldf 1.75MB DataBase src BeanPackage BeanClass.java 4KB QueryBean.java 1KB Staff.java 4KB BeanClass2.java 2KB .project 1KB WebRoot META-INF MANIFEST.MF 36B WEB-INF web.xml 371B classes BeanPackage BeanClass2.class 3KB QueryBean.class 3KB BeanClass.class 5KB Staff.class 5KB lib 
mssqlserver.jar 66KB msbase.jar 280KB sqljdbc4.jar 525KB msutil.jar 58KB mysql-connector-java-5.1.6-bin.jar 687KB mysql-connector-java-3.1.6-bin.jar 382KB Absence.jsp 1KB admin.jsp 768B login.jsp 866B Information.jsp 1KB .mymetadata 297B .classpath 831B .myeclipse 资源评论
