personnel.java

毕业设计源代码

package JXC.web;

import JXC.Com.DBConnect;
import JXC.util.StrFun;

import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Title:       明细单信息
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      torch
 *
 * @version 1.0
 * @author: wind
 */
public class personnel {
    private int id;
    private String bh;
    private String name;
    private String sex;
    private String birthday;
    private String workday;
    private String post;
    private String business;
    private String diploma;
    private String pay;
    private String department;
    private String card;
    private String memo;

    public void personnel() {
    }

    public int getId() {
        return id;
    }

    public void setId(int anew) {
        this.id = anew;
    }

    public void setId(String anew) {
        if (anew != null)
            this.id = Integer.parseInt(anew);
    }

    public String getBh() {
        return bh;
    }

    public void setBh(String anew) {
        this.bh = anew;
    }

    public String getName() {
        return name;
    }

    public void setName(String anew) {
        this.name = anew;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String anew) {
        this.sex = anew;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String anew) {
        this.birthday = anew;
    }

    public String getWorkday() {
        return workday;
    }

    public void setWorkday(String anew) {
        this.workday = anew;
    }

    public String getPost() {
        return post;
    }

    public void setPost(String anew) {
        this.post = anew;
    }

    public String getBusiness() {
        return business;
    }

    public void setBusiness(String anew) {
        this.business = anew;
    }

    public String getDiploma() {
        return diploma;
    }

    public void setDiploma(String anew) {
        this.diploma = anew;
    }

    public String getPay() {
        return pay;
    }

    public void setPay(String anew) {
        this.pay = anew;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String anew) {
        this.department = anew;
    }

    public String getCard() {
        return card;
    }

    public void setCard(String anew) {
        this.card = anew;
    }

    public String getMemo() {
        return memo;
    }

    public void setMemo(String anew) {
        this.memo = anew;
    }

    public boolean excute() throws Exception {
        String Str = "Select * From personnel where Id=" + id;
        try {
            DBConnect dbc = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            ResultSet rs = dbc.executeQuery(Str);
            if (rs.next()) {
                id = rs.getInt("id");
                bh = rs.getString("bh");
                name = rs.getString("name");
                sex = rs.getString("sex");
                birthday = rs.getString("birthday");
                workday = rs.getString("workday");
                post = rs.getString("post");
                business = rs.getString("business");
                diploma = rs.getString("diploma");
                pay = rs.getString("pay");
                department = rs.getString("department");
                card = rs.getString("card");
                memo = rs.getString("memo");
            }
            rs.close();
            dbc.close();
            return true;
        }
        catch (SQLException sqle) {
            return false;
        }
    }

    public void Edit(HttpServletRequest request) throws Exception {
        id = StrFun.getInt(request, "id");
        bh = StrFun.getString(request, "bh");
        name = StrFun.getString(request, "name");
        sex = StrFun.getString(request, "sex");
        birthday = StrFun.getString(request, "birthday");
        workday = StrFun.getString(request, "workday");
        post = StrFun.getString(request, "post");
        business = StrFun.getString(request, "business");
        diploma = StrFun.getString(request, "diploma");
        pay = StrFun.getString(request, "pay");
        department = StrFun.getString(request, "department");
        card = StrFun.getString(request, "card");
        memo = StrFun.getString(request, "memo");
        String Str = "Update personnel set bh='" + bh + "' ,name='" + name + "' ,sex='" + sex + "' ,birthday='" + birthday + "' ,workday='" + workday + "' ,post='" + post + "' ,business='" + business + "' ,diploma='" + diploma + "' ,pay='" + pay + "' ,department='" + department + "' ,card='" + card + "' ,memo='" + memo + "'  where id=" + id;
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

    public void Add(HttpServletRequest request) throws Exception {
        bh = StrFun.getString(request, "bh");
        name = StrFun.getString(request, "name");
        sex = StrFun.getString(request, "sex");
        birthday = StrFun.getString(request, "birthday");
        workday = StrFun.getString(request, "workday");
        post = StrFun.getString(request, "post");
        business = StrFun.getString(request, "business");
        diploma = StrFun.getString(request, "diploma");
        pay = StrFun.getString(request, "pay");
        department = StrFun.getString(request, "department");
        card = StrFun.getString(request, "card");
        memo = StrFun.getString(request, "memo");
        String Str = "Insert into personnel(bh,name,sex,birthday,workday,post,business,diploma,pay,department,card,memo) " +
                " values('" + bh + "','" + name + "','" + sex + "','" + birthday + "','" + workday + "','" + post + "','" + business + "','" + diploma + "','" + pay + "','" + department + "','" + card + "','" + memo + "')";

        System.out.println("==personnel.java===" + Str);
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

    public void Del() throws Exception {
        String Str = "Delete From personnel where Id=" + id;
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

}