user.java

新闻发布系统 jsp制作。可应用与毕业设计

package com.newsIssueSystem.javaBean;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class User {
	private int id;
	private String loginName;
	private String userName;
	private String password;
	private int sex;
	private String birthday;
	private int roleid;
	private String rolename;



	public String getBirthday() {
		return birthday;
	}

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

	public int getId() {
		return id;
	}

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

	public String getLoginName() {
		return loginName;
	}

	public void setLoginName(String loginName) {
		this.loginName = loginName;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public int getRoleid() {
		return roleid;
	}

	public void setRoleid(int roleid) {
		this.roleid = roleid;
	}

	public String getRolename() {
		return rolename;
	}

	public void setRolename(String rolename) {
		this.rolename = rolename;
	}

	public int getSex() {
		return sex;
	}

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

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	/*
	 * 判断用户是否登陆
	 * */
	public boolean isLogin(String loginName,String pwd,int roleid)
	{
		DBConnection con=new DBConnection();
		String sql="select *  from UserTable   where loginname='"+loginName+"' and pwd='"+pwd+"' and roleid="+roleid;
		
		try {
			con.sta=con.getCon().createStatement();
			con.rs=con.sta.executeQuery(sql);
			while(!con.rs.next())
			{
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		con.closeCon();
		return true;
	}

	/*
	 * 得到用户的所有信息 
	 * */
	public List getAllUser()
	{
		DBConnection con = new DBConnection();
		String sql = "select UserTable.*,Roles.rolename  from UserTable inner join Roles on Roles.roleid=UserTable.roleid";
		List lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				User a = new User();
				a.setId(con.rs.getInt(1));
				a.setLoginName(con.rs.getString(2));
				a.setUserName(con.rs.getString(3));
				a.setPassword(con.rs.getString(4));
				a.setSex(con.rs.getInt(5));
				a.setBirthday(con.rs.getString(6));
				a.setRoleid(con.rs.getInt(7));
				a.setRolename(con.rs.getString(8));
				
				lst.add(a);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}
	

	
	/*
	 * 得到已经登陆的用户的信息
	 * */
	public List getLoginuser(String loginname)
	{
		DBConnection con = new DBConnection();
		String sql = "select * from UserTable inner join Roles on Roles.roleid=UserTable.roleid where UserTable.loginname='"+loginname+"'";
		ArrayList lst = new ArrayList();
		try {
			con.sta = con.getCon().createStatement();
			con.rs = con.sta.executeQuery(sql);
			while (con.rs.next()) {
				User a = new User();
				a.setId(con.rs.getInt(1));
				a.setLoginName(con.rs.getString(2));
				a.setUserName(con.rs.getString(3));
				a.setPassword(con.rs.getString(4));
				a.setSex(con.rs.getInt(5));
				a.setBirthday(con.rs.getString(6));
				a.setRoleid(con.rs.getInt(7));
				
				lst.add(a);
			}
			con.rs.close();
			con.closeCon();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			con.closeCon();
			return null;
		}
		return lst;
	}
	
//	/*
//	 * 增加用户\用户注册
//	 * */	
//	public boolean inserUser() 
//	{
//		
//	}
//	
//	/*
//	 * 删除用户
//	 * */
//	public boolean deleteUser()
//	{
//		
//	}
//	
//	/*
//	 * 修改用户
//	 * */
//	public boolean updateUser()
//	{
//		
//	}
	
}