adduser.java

本远程教育系统是采用jsp技术配合SqlServer 2000数据库和Tomcat服务器开发的动态交互式网站。基本实现了用户管理

package condb;
import java.sql.*;
import condb.ConDB;
import condb.UserMode;
public class AddUser{
	private String user_id;
	private String user_realname;
	private String user_password;	
	private int user_age;
	private String user_sex;
	private String qianzi;
	private String user_type;
	public AddUser(){
		user_id="";
		user_realname="";
		user_password=""; 		
		user_age=0; 
		user_sex=""; 
		qianzi="";
		user_type="0";
	}
	public void setMode(UserMode usermode){
		this.user_id = usermode.getUser_id();
		this.user_realname = usermode.getUser_realname();
		this.user_password = usermode.getUser_password();
		this.user_age = usermode.getUser_age();
		this.user_sex = usermode.getUser_sex();
		this.qianzi = usermode.getQianzi();
		this.user_type = usermode.getUser_type();	
	}
	public int add(){
		int i = 0;
		String sql = "insert into users values('"+user_id+"','"
			+user_password+"','"+user_realname+"','"+user_sex+"',"
			+user_age+",'"+user_type+"','"+qianzi+"')";
		ConDB condb = new ConDB();
		Statement stmt =condb.getStmtread();
		try{
			i=stmt.executeUpdate(sql);
		}
		catch(Exception e){
			System.err.println(e.getMessage());
			i--;
		}
		condb.close();
		return i;
	}
}