Spring_SSH_JSP_Entity_Service

1.目录结构

2.jar包

3.User

package com.cloud.oss.domain.model;

/**
 * @author cloud
 * @Date 2016年5月26日
 * @Version 1.0
 * @Description
 */
public class User {
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public String getUsername() {
        return username;
    }

    public String getPassword() {
        return password;
    }

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

    public void setUsername(String username) {
        this.username = username;
    }

    public void setPassword(String password) {
        this.password = password;
    }

}

 

4.UserService

package com.cloud.oss.domain.service;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.cloud.oss.domain.model.User;

/**
 * @author cloud
 * @Date 2016年5月26日
 * @Version 1.0
 * @Description
 */
public class UserService {
    public boolean exists(User user) throws SQLException, ClassNotFoundException{

        //数据库操作
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/spring","root","root");

        //检查数据库中用户名是否已经存在
        String sqlQuery = "select count(*) from user where username = ?";
        PreparedStatement psQuery = conn.prepareStatement(sqlQuery);
        psQuery.setString(1,user.getUsername());
        ResultSet rs = psQuery.executeQuery();
        rs.next();
        int count = rs.getInt(1);
        psQuery.close();
        conn.close();
        if(count > 0){
            return true;
        }
        return false;
    }
    
    public void save(User user) throws ClassNotFoundException, SQLException{
        //数据库操作
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/spring","root","root");
        //如果不存在就往数据库中插入一条记录
        String sqlInsert = "insert into user values (null,?,?)";
        PreparedStatement psInsert = conn.prepareStatement(sqlInsert);
        psInsert.setString(1, user.getUsername());
        psInsert.setString(2,user.getPassword());
        psInsert.executeUpdate();
        psInsert.close();
        conn.close();
    }
}

 

5.regieter.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>用户注册逻辑</title>
  </head>
  <body>
      <form method="post" action="registerHandle.jsp">
          用户名：<input type="text" name="username">
          密码：<input type="password" name="password">
          确认密码：<input type="passwordConfirm" name="passwordConfirm">
          <input type="submit" value="注册">
      </form>
  </body>
</html>

 

6.registerHandle.jsp

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%@ page import="com.cloud.oss.domain.service.UserService" %>
<%@ page import="com.cloud.oss.domain.model.User" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

//获取参数
String username = request.getParameter("username");
String password = request.getParameter("password");
String passwordConfirm = request.getParameter("passwordConfirm");

UserService service = new UserService();
User user = new User();
user.setUsername(username);
user.setPassword(password);
if(service.exists(user)){
    response.sendRedirect("fail.jsp");
    return;
}
service.save(user);
response.sendRedirect("success.jsp");
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>用户注册</title>
  </head>
  <body>
  </body>
</html>

 

7.success.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>用户注册逻辑</title>
  </head>
  <body>
      注册成功
  </body>
</html>

 

8.fail.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>用户注册逻辑</title>
  </head>
  <body>
      注册失败
  </body>
</html>

 





 







            

            
posted @ 
2016-05-26 15:11 
桃源仙居 
阅读(112) 
评论(0) 
 
收藏 
举报