uses.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 uses {
    private int id;
    private String ygbh;
    private String name;
    private String passwd;
    private String js;

    public void uses() {
    }

    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 getYgbh() {
        return ygbh;
    }

    public void setYgbh(String anew) {
        this.ygbh = anew;
    }

    public String getName() {
        return name;
    }

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

    public String getPasswd() {
        return passwd;
    }

    public void setPasswd(String anew) {
        this.passwd = anew;
    }

    public String getJs() {
        return js;
    }

    public void setJs(String anew) {
        this.js = anew;
    }

    public boolean excute() throws Exception {
        String Str = "Select * From users 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");
                ygbh = rs.getString("ygbh");
                name = rs.getString("name");
                passwd = rs.getString("passwd");
                js = rs.getString("js");
            }
            rs.close();
            dbc.close();
            return true;
        }
        catch (SQLException sqle) {
            return false;
        }
    }

    public void Edit(HttpServletRequest request) throws Exception {
        id = StrFun.getInt(request, "id");
        ygbh = StrFun.getString(request, "ygbh");
        name = StrFun.getString(request, "name");
        passwd = StrFun.getString(request, "passwd");
        js = StrFun.getString(request, "js");
        String Str = "Update users set ygbh='" + ygbh + "' ,name='" + name + "' ,passwd='" + passwd + "' ,js='" + js + "'  where id=" + id;
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

    public void Add(HttpServletRequest request) throws Exception {
        ygbh = StrFun.getString(request, "ygbh");
        name = StrFun.getString(request, "name");
        passwd = StrFun.getString(request, "passwd");
        js = StrFun.getString(request, "js");

        String Str = "insert into users(ygbh,name,passwd,js) values('" + ygbh + "','" + name + "','" + passwd + "','" + js + "')";
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

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

}