第七周作业

用户表:  uid (主键,自动增长)   uname  upwd

使用分层实现注册。(必做)

1.注册界面

<%@ 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="mysql.jsp" >
        <table>
        
            <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>

2.跳转界面

<%@page import="com.gd.dao.StuDao"%>
<%@page import="com.gd.bean.Stu"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    Stu s = new Stu();
    
    String uname = request.getParameter("uname");
    s.setUname(uname);
    String upwd = request.getParameter("upwd");
    s.setUpwd(upwd);
    
    StuDao sd=new StuDao();
    if(sd.addStu(s)>0){
        request.getRequestDispatcher("ok.jsp").forward(request,response);
    }else{
        request.getRequestDispatcher("no.jsp").forward(request,response);
    }
    
    
    
%>

3.表的建立并给sid添加主键及自动增长代码

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50045
Source Host           : localhost:3306
Source Database       : mysql

Target Server Type    : MYSQL
Target Server Version : 50045
File Encoding         : 65001

Date: 2021-04-18 21:55:25
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `stu`
-- ----------------------------
DROP TABLE IF EXISTS `stu`;
CREATE TABLE `stu` (
  `sid` int(10) NOT NULL auto_increment,
  `uname` varchar(10) default NULL,
  `upwd` int(10) default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of stu
-- ----------------------------
INSERT INTO `stu` VALUES ('1', 'zs', '567');
INSERT INTO `stu` VALUES ('2', 'ff', '555');
INSERT INTO `stu` VALUES ('3', 'hh', '357');
INSERT INTO `stu` VALUES ('4', 'tt', '567');
INSERT INTO `stu` VALUES ('5', 'rr', '999');
INSERT INTO `stu` VALUES ('6', 'ty', '1111');
INSERT INTO `stu` VALUES ('7', 'xx', '123');

 

posted @ 2021-04-19 19:30  梦醒117  阅读(8)  评论(0编辑  收藏