userinfo.java

新闻发布系统

package com.Bean;

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

import com.DB.DBConnection;

public class UserInfo 
{
	public int id;
	public String userName;
	public String userPassword;
	public String userSex;
	public int quanxianID;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getQuanxianID() {
		return quanxianID;
	}
	public void setQuanxianID(int quanxianID) {
		this.quanxianID = quanxianID;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getUserPassword() {
		return userPassword;
	}
	public void setUserPassword(String userPassword) {
		this.userPassword = userPassword;
	}
	public String getUserSex() {
		return userSex;
	}
	public void setUserSex(String userSex) {
		this.userSex = userSex;
	}
	//添加
	public boolean addUser(UserInfo user)
	{
		String str="insert into userInfo values(?,?,?,?)";
		DBConnection db=new DBConnection();
		Connection c=db.getCon();
		try {
			db.ps=c.prepareStatement(str);
			db.ps.setString(1, this.userName);
			db.ps.setString(2, this.userPassword);
			db.ps.setString(3, this.userSex);
			db.ps.setInt(4, this.quanxianID);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//删除
	public boolean delUser(String sid)
	{
		String str="delete from userInfo where id="+sid;
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.st.executeUpdate(str);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//更新
	public boolean upUser(UserInfo user)
	{
		String str="update userInfo set userName=? userPassword=? userSex=? quanxianID=?  where id=?";
		DBConnection db=new DBConnection();
		Connection c=db.getCon();
		try {
			db.ps=c.prepareStatement(str);
			db.ps.setString(1, this.userName);
			db.ps.setString(2, this.userPassword);
			db.ps.setString(3, this.userSex);
			db.ps.setInt(4, this.quanxianID);
			db.ps.setInt(5, this.id);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//查询
	public ArrayList selUser()
	{
		ArrayList arr=new ArrayList();
		UserInfo user=null;
		String str="select * from userInfo";
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.rs=db.st.executeQuery(str);
			while(db.rs.next())
			{
				user=new UserInfo();
				user.setId(db.rs.getInt(1));
				user.setUserName(db.rs.getString(2));
				user.setUserPassword(db.rs.getString(3));
				user.setUserSex(db.rs.getString(4));
				user.setQuanxianID(db.rs.getInt(5));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return arr;
	}
}