admin.java

新闻采用在线编辑器

					}
			}
			if(!foundErr){
				password = MD5.toMD5(password);
				answer = MD5.toMD5(answer);
			}
			if(!foundErr){
				dbc.prepareStatement("INSERT INTO admin (name,password,sex,email,qq,phone,question,answer,date) VALUES (?,?,?,?,?,?,?,?,Now())");
				dbc.setBytes(1,name.getBytes("GBK"));
				dbc.setBytes(2,password.getBytes("GBK"));
				dbc.setBytes(3,sex.getBytes("GBK"));
				dbc.setBytes(4,email.getBytes("GBK"));
				dbc.setInt(5,qq);
				dbc.setBytes(6,phone.getBytes("GBK"));
				dbc.setBytes(7,question.getBytes("GBK"));
				dbc.setBytes(8,answer.getBytes("GBK"));
				//dbc.setBytes(9,dat.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
			}
			if(foundErr) throw new Exception(errMsg);
			}

		/**
		* 修改管理员信息
		*/
		public static void editAdmin(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			String name = ParamUtils.getString(request,"name","");
			String password = ParamUtils.getString(request,"password","");
			String repassword = ParamUtils.getString(request,"repassword","");
			String question = ParamUtils.getString(request,"question","");
			String sex = ParamUtils.getString(request,"sex","");
			String answer = ParamUtils.getString(request,"answer","");
			String email = ParamUtils.getString(request,"email","");
			int qq = ParamUtils.getInt(request,"qq",0);
			String phone = ParamUtils.getString(request,"phone","");
			DBConnect dbc = new DBConnect();
			if(name.equals("") || name==null){
				errMsg = errMsg + "□ 您没有输入用户名！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(password.equals("") || password==null){
				errMsg = errMsg + "□ 您没有输入密码！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(repassword.equals("") || repassword==null){
				errMsg = errMsg + "□ 您没有输入确认密码！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(email.equals("") || email==null){
				errMsg = errMsg + "□ 您没有输入email！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(qq<=0){
				errMsg = errMsg + "□ 您没有输入qq号码！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(phone.equals("") || phone==null){
				errMsg = errMsg + "□ 您没有输入电话号码！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(question.equals("") || question==null){
				errMsg = errMsg + "□ 您没有输入忘记密码提示问题！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(answer.equals("") || answer==null){
				errMsg = errMsg + "□ 您没有输入问题答案！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(!password.equals(repassword)){
				errMsg = errMsg + "□ 您两次输入的密码不一致！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(!foundErr){
				password = MD5.toMD5(password);
				answer = MD5.toMD5(answer);
			}
			if(!foundErr){
				dbc.prepareStatement("UPDATE admin SET password=?,sex=?,email=?,qq=?,phone=?,question=?,answer=? WHERE name=?");
				dbc.setBytes(1,password.getBytes("GBK"));
				dbc.setBytes(2,sex.getBytes("GBK"));
				dbc.setBytes(3,email.getBytes("GBK"));
				dbc.setInt(4,qq);
				dbc.setBytes(5,phone.getBytes("GBK"));
				dbc.setBytes(6,question.getBytes("GBK"));
				dbc.setBytes(7,answer.getBytes("GBK"));
				dbc.setBytes(8,name.getBytes("GBK"));
				dbc.executeUpdate();
				dbc.close();
			}
			if(foundErr) throw new Exception(errMsg);
			}

		/**
		* 添加管理员
		*/
		public static void addAdmin(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			int user_id = ParamUtils.getInt(request,"user_id",0);
			int clas = ParamUtils.getInt(request,"clas",0);
			if(user_id<=0){
				errMsg = errMsg + "□ 您没有输入序号!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			/**if(clas<=0){
				errMsg = errMsg + "□ 您没有输入级别!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}*/
			if(!foundErr){
				DBConnect dbc = new DBConnect();
				dbc.prepareStatement("UPDATE admin SET clas=? WHERE user_id=?");
				dbc.setInt(1,clas);
				dbc.setInt(2,user_id);
				dbc.executeUpdate();
				dbc.close();
			}
			if(foundErr) throw new Exception(errMsg);
			}

		/**
		* 读取所有管理员基本信息
		*/
		public Vector adminAll(){
			DBConnect dbc = null;
			Vector adminVector = new Vector();
			try{
			dbc  = new DBConnect();
			dbc.prepareStatement("Select * from admin");
			ResultSet rs = dbc.executeQuery();
			while(rs.next()){
				Admin admin = new Admin();
				admin.setuser_id(rs.getString("user_id"));
				admin.setname(rs.getString("name"));
				admin.setsex(rs.getString("sex"));
				admin.setqq(rs.getString("qq"));
				admin.setemail(rs.getString("email"));
				admin.setphone(rs.getString("phone"));
				admin.setclas(rs.getString("clas"));
				admin.setdat(rs.getString("date"));
				admin.setnews_coun(rs.getString("news_coun"));
				adminVector.add(admin);
			}
			}
			catch(Exception e){
				System.err.println(e+"error");
			}
			finally{
				try{
					dbc.close();
				}
				catch(Exception e){
					e.printStackTrace();
				}
			}
			return adminVector;
	 	}

	 	/**
		* 忘记管理员密码一
		*/
		public static void forgetAdmin(HttpServletRequest request) throws Exception {
		boolean foundErr = false;
		String errMsg="";
		String name = ParamUtils.getString(request,"name","");
		ResultSet rs;
		if(name.equals("") || name==null){
			errMsg = errMsg + "□ 您没有输入用户名！<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
			foundErr = true;
		}
		if(!foundErr){
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM admin WHERE name = ?");
			dbc.setBytes(1,name.getBytes("GBK"));
			rs =  dbc.executeQuery();
		if(rs.next()){
			String clas=rs.getString("clas");
			Admin user=new Admin();
			user.setname(name);
			user.setpassword(rs.getString("password"));
			user.setclas(rs.getString("clas"));
			user.setuser_id(rs.getString("user_id"));
			user.setsex(rs.getString("sex"));
			user.setqq(rs.getString("qq"));
			user.setemail(rs.getString("email"));
			user.setphone(rs.getString("phone"));
			user.setquestion(rs.getString("question"));
			user.setanswer(rs.getString("answer"));
			HttpSession session=request.getSession(true);
			GetSession.addAdminSession(session,user);
			rs.close();
			dbc.close();

			}
		else{
			errMsg = errMsg +"□ 您输入的用户名错误！<br>□ 五秒钟后会自动返回登录页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
			foundErr = true;
		}
		}
		if(foundErr) throw new Exception(errMsg);
		}
		/**
		* 删除管理员
		*/
		public static void delAdmin(HttpServletRequest request) throws Exception {
			boolean foundErr = false;
			String errMsg="";
			int user_id = ParamUtils.getInt(request,"user_id",0);
			if(user_id<=0){
				errMsg = errMsg + "□ 您没有输入序号!<br>□ 五秒钟后会自动返回上一页。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
				foundErr = true;
			}
			if(!foundErr){
				DBConnect dbc = new DBConnect();
				dbc.prepareStatement("delete from admin WHERE user_id=?");
				dbc.setInt(1,user_id);
				dbc.executeUpdate();
				dbc.prepareStatement("alter table admin drop user_id");
				dbc.executeUpdate();
				dbc.prepareStatement("alter table admin add user_id TINYINT auto_increment primary key");
				dbc.executeUpdate();
				dbc.close();
			}
			if(foundErr) throw new Exception(errMsg);
			}


	}