userinfo.java

jsp编程的源代码

package com.mybean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;

import com.myopdb.DBCon;

public class UserInfo {

	private int userid;
	private String logionname;

	private String nickname;

	private String usertype;

	private String sex;

	private String likes;

	private String userpwd;

	private String email;
	
	private String regiondate;
	private String findpassword;
	private String daan;

	private Connection con = null;

	private PreparedStatement prestmt = null;
    private Statement stmt=null;

	private ResultSet rs = null;

	DBCon dbo = new DBCon();

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getuserPwd() {
		return userpwd;
	}

	public void setuserPwd(String userpwd) {
		this.userpwd = userpwd;
	}

	public String getLikes() {
		return likes;
	}

	public void setLikes(String likes) {
		this.likes = likes;
	}

	public String getLogionname() {
		return logionname;
	}

	public void setLogionname(String logionname) {
		this.logionname = logionname;
	}

	public String getNickname() {
		return nickname;
	}

	public void setNickname(String nickname) {
		this.nickname = nickname;
	}

	public String getSex() {
		return sex;
	}

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

	public String getUsertype() {
		return usertype;
	}

	public void setUsertype(String usertype) {
		this.usertype = usertype;
	}
	
	public String getFindpassword() {
		return findpassword;
	}

	public void setFindpassword(String findpassword) {
		this.findpassword = findpassword;
	}

	public String getRegiondate() {
		return regiondate;
	}

	public void setRegiondate(String regiondate) {
		this.regiondate = regiondate;
	}

	//修改用户权限
	public boolean updateUser(UserInfo user)
	{
		if(this.con==null)
		{
			this.con=dbo.getCon();
		}
		String sql="update userinfo set usertype='"+user.getUsertype()+"'where userid="+user.getUserid()+"";
		try {
			this.stmt=con.createStatement();
			stmt.executeUpdate(sql);
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	// 添加用户
	public boolean addUser(UserInfo user) {
		
		if (this.con == null) {
			this.con = dbo.getCon();
		}
		String sql = "insert into userinfo values(?,?,?,?,?,?,?,?,?,?)";
		java.util.Date date=new Date();
		String temp=date.toLocaleString();
		
		try {
			this.prestmt = con.prepareStatement(sql);
			prestmt.setString(1, user.getUsertype());
			prestmt.setString(2, user.getLogionname());
			prestmt.setString(3, user.getuserPwd());
			prestmt.setString(4, user.getNickname());
			prestmt.setString(5, user.getSex());
			prestmt.setString(6, user.getLikes());
			prestmt.setString(7, user.getEmail());
			prestmt.setString(8,temp);
			prestmt.setString(9,user.getFindpassword());
			prestmt.setString(10,user.getDaan());
			prestmt.executeUpdate();
			return true;

		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
	}

	public ArrayList searchUser(UserInfo user) {
		ArrayList<Object> lst = new ArrayList<Object>();
		String sql = "select nickname,usertype,userid from userinfo where logionname=? and userpwd=?";
		if (this.con == null) {
			this.con = dbo.getCon();
		}
		try {
			this.prestmt = con.prepareStatement(sql);
			prestmt.setString(1, user.getLogionname());
			prestmt.setString(2, user.getuserPwd());
			this.rs = prestmt.executeQuery();
			while (rs.next()) {
				lst.add(rs.getString(1));
				lst.add(rs.getString(2));
				lst.add(rs.getInt(3));
			}

		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}
		return lst;
	}

	public boolean deleteUser(UserInfo user) {

		String sql = "delete from userinfo where userid=?";
		if (this.con == null) {
			this.con = dbo.getCon();
		}
		try {
			this.prestmt = con.prepareStatement(sql);
			prestmt.setInt(1, user.getUserid());
			prestmt.executeUpdate();
			return true;

		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
	}
	public int selectUserid()
	{
		String sql = "select max(userid) from userinfo ";
		if (this.con == null) {
			this.con = dbo.getCon();
		}
		try {
			stmt=con.createStatement();
			this.rs=stmt.executeQuery(sql);
            rs.next();
            return rs.getInt(1);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return -1;
			
		}
	}

	public String getDaan() {
		return daan;
	}

	public void setDaan(String daan) {
		this.daan = daan;
	}

	public int getUserid() {
		return userid;
	}

	public void setUserid(int userid) {
		this.userid = userid;
	}
  

}