loginaction.java

学校期间做的实践项目

package com.sw06701.action;

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.sw06701.dao.Linkdb;
import com.sw06701.formbean.LoginBean;
import com.sw06701.util.Url;

/**
 * 
 */
public class LoginAction {

	public static void doValue(HttpServletRequest request,
			HttpServletResponse response) {
		
		//获取数据
		String uid = request.getParameter("uid");
		String pwd = request.getParameter("pwd");
		//封装数据
		LoginBean result = new LoginBean();
		result.setUid(uid);
		result.setPassword(pwd);
		
		Url.doForward(request, response, result, "/web/frame/mainframe.jsp");
	}
	/**
	 * 判断用户是否存在
	 * @return
	 */
	public static boolean valuser(LoginBean lbean){
		try {
			Linkdb linkdb = new Linkdb();
			String sql = "select * from tabsysuser where userid='"
				+lbean.getUid()+"' and pwd='"+lbean.getPassword()+"'";
			ResultSet rs = linkdb.executeQuery(sql);
			while (rs.next()) {
				return true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}
	/**
	 * 获取系统所有人员
	 * @return
	 */
	public static List getalluserlist(){
		List resultList = new ArrayList();
		try {
			Linkdb linkdb = new Linkdb();
			String sql = "select a.userid,a.username,a.email,b.privname " +
					"from tabsysuser a ,basepriv b where a.basepriv = b.privid;";
			ResultSet rs = linkdb.executeQuery(sql);
			while (rs.next()) {
				LoginBean lbean = new LoginBean();
				lbean.setUid(rs.getString("userid"));
				lbean.setUsername(rs.getString("username"));
				lbean.setEmail("email");
				lbean.setPrivname("privname");
				resultList.add(lbean);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return resultList;
	}
}