admin.java

基于JAVA新闻发部系统

package com.mybean;

import java.sql.SQLException;

public class admin {
	private int id;
	private String adminname;
	private String password;
	private int roleid;
	public String getAdminname() {
		return adminname;
	}
	public void setAdminname(String adminname) {
		this.adminname = adminname;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	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 boolean selectAdmin()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		
		
		String sql="select * from administrators where a_name='"+this.adminname+"' and a_password='"+this.password+"' and roleid="+this.roleid+"";
		try {
			dbc.rs=dbc.sta.executeQuery(sql);
			while(dbc.rs.next())
			{
				dbc.rs.getInt(1);
			    dbc.rs.getString(2);
				dbc.rs.getString(3);
				dbc.rs.getInt(4);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		dbc.close();
		return true;
	}
	public boolean findAdmin()
	{
		DBConnection dbc=new DBConnection();
		if(dbc.getCon()==null)
		{
			dbc.getCon();
		}
		String str="select * from administrators where a_name='"+this.adminname+"'";
		try {
			dbc.rs=dbc.sta.executeQuery(str);
			while(dbc.rs.next())
			{
				return true;
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return false;
	}
}