adminbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

public class AdminBean {
	private String admin;

	private String psw;

	private String pswss;

	private int id;

	private String photo;

	public void setPhoto(String s) {
		photo = s;
	}

	public String getPhoto() {
		return photo;
	}

	public int getId() {
		return id;
	}

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

	public String getAdmin() {
		return admin;
	}

	public void setAdmin(String admin) {
		this.admin = admin;
	}

	public String getPsw() {
		return psw;
	}

	public void setPsw(String psw) {
		this.psw = psw;
	}

	public String getPswss() {
		return pswss;
	}

	public void setPswss(String pswss) {
		this.pswss = pswss;
	}

	public boolean hasLogin(String admin) { // 检查该管理员是否已经注册
		boolean f = true;
		String sql = "select admin from admin where admin ='" + admin + "'";
		SqlBean db = new SqlBean();
		try {
			ResultSet rs = db.executeQuery(sql);
			if (rs.next()) {
				f = false;
			} else {
				f = true;
			}
		} catch (Exception e) {
			e.getMessage();
		}
		return f;
	}

	public ResultSet getAdmins() {
		String sql = "select * from admin";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAdmin(int id) {
		String sql = "select * from admin where id='" + id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public void updateAdmin() {

		String sql = "update admin " + " set admin='" + admin + "',psw='" + psw
				+ "' where id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void updatePhoto() {
		String sql = "update admin set a_photo='" + photo + "' where a_id='"
				+ id + "'";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);
	}

	public void deleteAdmin() {
		String user = "admin";
		String sql0 = "select ask_id from ask where u_id='" + id
				+ "'and ans_sort='" + user + "'";
		String sql = "delete  from answer where ans_id ='" + id
				+ "'and ans_sort='" + user + "' ";
		String sql1 = "delete  from ask where u_id ='" + id + "'and ask_sort='"
				+ user + "' ";

		String sql4 = "delete  from admin where id ='" + id + "' ";

		SqlBean db = new SqlBean();
		try {
			ResultSet rs = db.executeQuery(sql0);
			while (rs.next()) {
				int ask_id = rs.getInt(1);
				String sql5 = "delete  from answer where ask_id ='" + ask_id
						+ "'";
				db.executeDelete(sql5);
			}
		} catch (SQLException e) {
		} catch (NullPointerException e){}
		db.executeDelete(sql);
		db.executeDelete(sql1);

		db.executeDelete(sql4);
	}

	public int deleteAdmin(int id) {
		int num = 0;
		String user = "admin";
		String sql0 = "select ask_id from ask where u_id='" + id
				+ "'and ans_sort='" + user + "'";
		String sql = "delete  from answer where ans_id ='" + id
				+ "'and ans_sort='" + user + "' ";
		String sql1 = "delete  from ask where u_id ='" + id + "'and ask_sort='"
				+ user + "' ";

		String sql4 = "delete  from admin where id ='" + id + "' ";

		SqlBean db = new SqlBean();
		try {
			ResultSet rs = db.executeQuery(sql0);
			while (rs.next()) {
				int ask_id = rs.getInt(1);
				String sql5 = "delete  from answer where ask_id ='" + ask_id
						+ "'";
				db.executeDelete(sql5);
			}
		} catch (SQLException e) {
		}catch (NullPointerException e){}
		db.executeDelete(sql);
		db.executeDelete(sql1);

		num = db.executeDelete(sql4);
		return num;
	}

	public void addAdmin() {
		String sql = "insert into admin(admin,psw)" + "VALUES('" + admin
				+ "','" + psw + "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}

}