jsp第七周作业

用户表： uid (主键，自动增长) uname upwd

使用分层实现注册。（必做）

使用分层实现登录。（选做）

index.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>My JSP 'index.jsp' starting page</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">    
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  
  <body>
    <form name="form1" method="post" action="control.jsp" >
        <table>
        <tr>    
            <td>学号：</td>
                <td> <input type="text" name="sid" id="userName"  ></td>
            </tr>
            <tr>    
                <td>用户名：</td>
                <td> <input type="text" name="uname" id="userName"  ></td>
            </tr>
            <tr>    
                 <td>密码：</td>
                <td><input type="password" name="upwd" id="pwd"></td>
            </tr>
            
            <tr>    
                <td colspan="2"><input type="submit" value="注册"></td>
            </tr>
        </table>
    </form>
  </body>
</html>

　　Student.java

package com.liu.dao;

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

import com.liu.bean.Stu;

public class StuDao {
    // 学生数据访问类

    // 添加学生
    public int addStu(Stu s) {
        int i = 0;

        try {
            // 加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            // 建立连接
            Connection con = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/mysql", "root", "root");
            // 写SQL语句
            String sql = "insert into stu values(?,?,?)";
            // 执行
            PreparedStatement ps = con.prepareStatement(sql);
            ps.setInt(1, s.getSid());
            ps.setString(2, s.getUname());
            ps.setString(3, s.getUpwd());
            i = ps.executeUpdate();

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return i;

    }


    // 登录


}

　　user.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page language="java" import="java.util.*"%>
<%@ page import ="java.sql.*"%>
<%@page import="com.jjy.dao.jspdataDao"%>
<%@page import="com.jjy.bean.jspdata"%>
<html>
<head>
    <title>欢迎你</title>
</head>
<body>
<%
    request.setCharacterEncoding("utf-8");
    jspdata u= new jspdata();
    String uname = request.getParameter("name");uname.trim();
    u.setUname(uname);
    String upwd = request.getParameter("password");upwd.trim();
    u.setUpwd(upwd);
    jspdataDao ss=new jspdataDao();
    if(ss.queryUers(u)>0){
%><p>欢迎<%=uname%></p><%
}else{%> <p>输入错误</p><a href="index.jsp"><button>返回</button></a>
<%
    }
%>
 
</body>
</html>