user.java

web版的进销存系统

package jxc.web;
import jxc.com.DBConnect;
import java.lang.String;
import jxc.util.StrFun;
import java.sql.*;
import javax.servlet.http.*;
/**
 * Title:       明细单信息
 * Description:
 * Copyright:    Copyright (c) 2007
 * Company:      torch
 * @author:		 wind
 * @version 1.0
 */
public class User{
	private int id;
	private String username;
	private String usname;
	private String passwd;
	private String js;
	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 getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getUsname() {
		return usname;
	}
	public void setUsname(String usname) {
		this.usname = usname;
	}
	public String  getPasswd() {
		return passwd;
	}
	public void setPasswd(String anew) {
		this.passwd=anew;
	}		
	public String getJs() {
		return js;
	}
	public void setJs(String js) {
		this.js = js;
	}
	
	public boolean excute() throws Exception {
		String Str="Select * From uses 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"); 
				usname=rs.getString("usname"); 
				username=rs.getString("username"); 
				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"); 
		usname=StrFun.getString(request,"usname"); 
		username=StrFun.getString(request,"username"); 
		passwd=StrFun.getString(request,"passwd");
		js=StrFun.getString(request,"js");
		
		String Str="Update uses set usname='"+usname+"' ,username='"+username+"' ,passwd='"+passwd+"' ,js='"+js+"'  where id="+id;
		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}
	
	public void Add(HttpServletRequest request) throws Exception {
		usname=StrFun.getString(request,"usname"); 
		username=StrFun.getString(request,"username"); 
		passwd=StrFun.getString(request,"passwd");
		js=StrFun.getString(request,"js");
		
		String Str="Insert into uses(usname,username,passwd,js) values('"+usname+"','"+username+"','"+passwd+"','"+js+"')";
		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}
	
	public void Del() throws Exception {
		String Str="Delete From uses where Id="+id;
		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}

}