Spring三层框架实现的javaweb用户登陆系统

一、WebContent中新建一个form表单：

<form action="http://localhost:8080/mini/login" method="post">
	  <div class="form-group has-feedback">
	       <input type="text" name="username" class="form-control" placeholder="用户名">
	       <span class="glyphicon glyphicon-envelope form-control-feedback"></span>
	   </div>
	   <div class="">
		    <input type="password" name="password" class="form-control"placeholder="密码">
		    <span class="glyphicon glyphicon-lock form-control-feedback"></span>
		</div>
		     <div class="row">
				 <label><input type="checkbox"> 记住 下次自动登录</label></div>
		     </div>
			 <div class="col-xs-4">
			     <button type="submit" class="btn btn-primary btn-block btn-flat">登录</button>
			 </div>
		</div>
	</form>

二、新建一个实体类，添加get、set和toString方法：

package com.soou.ssm.model;

public class User {
	private int id;
	private String username;
	private String userno;
	private String pwd;
	private String position;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getUserno() {
		return userno;
	}
	public void setUserno(String userno) {
		this.userno = userno;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		
		this.pwd = pwd;
	}
	public String getPosition() {
		return position;
	}
	public void setPosition(String position) {
		this.position = position;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", userno=" + userno + ", pwd=" + pwd + ", position="
				+ position + ", age=" + age + "]";
	}
}

三、在controller包下新建一个类：

@Controller
public class LoginController {
	@Autowired
	UserService userService;
	@RequestMapping(value="login",method=RequestMethod.POST)
	@ResponseBody
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String username=request.getParameter("username");
		String password=request.getParameter("password");
		UserService userService=new UserService();
		User user= userService.login(username,password);
		if(user!=null) {
			System.out.println("登陆成功,进入首页");
			request.getRequestDispatcher("/index.jsp").forward(request, response);
		}else {
			//调用自己页面
			System.out.println("登陆失败");
			request.getRequestDispatcher("/login.jsp").forward(request, response);
		}	
	}
}

四、service包下新建一个类：

@Service
public class UserService {
	UserDao userDao=new UserDao();
    public User login(String userno,String pwd) {
    	return userDao.login(userno,pwd);
    }
 }

五、Dao包下新建一个类，方法如下：

public User login(String userno,String pwd) {
    	String sql="select * from k_user where userno='"+userno+"'and pwd='"+pwd+"'";
    	//String sql="select * from k_user where userno=?'and pwd=?";
    	try {
    		//获得数据库连接
    		this.conn=this.getConn();
    		//获得命令执行对象
			this.ps=conn.prepareStatement(sql);
			//执行命令
			this.rs=ps.executeQuery(sql);
			//处理结果
			if(rs.next()) {
			    String username=rs.getString("username");
				String position=rs.getString("position");
			    int age=rs.getInt("age");
				int id=rs.getInt("id");
				User user=new User();
				user.setId(id);
				user.setUsername(username);
				user.setUserno(userno);
				user.setPwd(pwd);
				user.setPosition(position);
				user.setAge(age);
				return user;
			}	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			this.closeAll();
		}
    	return null;
    }   

**数据库连接配置：**

public class BaseDao {
	private String driver="com.mysql.cj.jdbc.Driver";
	private String url="jdbc:mysql://localhost:3306/wisdom?useUnicode = true＆characterEncoding = utf-8＆useSSL = false&serverTimezone = GMT";
	private String name="root";
	private String pass="root";
	Connection conn;
	PreparedStatement ps;
	ResultSet rs;
	public Connection getConn() {
		try {
			Class.forName(driver);//鍔犺浇椹卞姩
			return DriverManager.getConnection(url,name,pass);
		}catch(Exception e) {	
			e.printStackTrace();
		}
		return null;	
	}
	public void closeAll(){
		try {
			if(rs!=null) {
				rs.close();
				rs=null;		
			}
			if(ps!=null) {
				ps.close();
				ps=null;
			}
			if(conn!=null) {
				conn.close();
				conn=null;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

叮~，进入首页啦…