<%@ 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>
package com.ee.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.resource.cci.ResultSet; import com.ee.bean.User; public class UserDao { public int addUser(User u){ int i=0; try { Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=utf8", "root", "12345678"); String sql="insert into user2(name,password) values(?,?)"; PreparedStatement ps=con.prepareStatement(sql); ps.setString(1, u.getUname()); ps.setString(2, u.getUpwd()); i=ps.executeUpdate(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return i; } public int selectUser(User u){ int n=0; try{ Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=utf8", "root", "12345678"); String sql="select name,password from user2 where name=?and password =?"; PreparedStatement ps=con.prepareStatement(sql); ps.setString(1, u.getUname()); ps.setString(2, u.getUpwd()); n=ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } return n; } }
<%@ page contentType="text/html; charset=utf-8" language="java"%> <html lang="zh-CN"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>登录</title> <link href="css/bootstrap.min.css" rel="stylesheet"> </head> <body> <nav class="navbar navbar-default"> <div class="container-fluid"> <div class="navbar-header"> <a class="navbar-brand" href="./">jsp作业</a> </div> <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"> <ul class="nav navbar-nav navbar-right"> <li><a href="login.jsp">登录</a></li> </ul> </div> </div> </nav> <div class="container"> <div class="row"> <div class="col-md-4"> </div> <div class="col-md-4"> <form class="form-signin" method="post" action="login-check.jsp"> <h2 class="form-signin-heading">登录到jsp作业</h2> <label for="">用户名</label> <input type="text" name="username" id="username" class="form-control" placeholder="请输入用户名" required autofocus><br> <label for="">密码</label> <input type="password" name="password" id="password" class="form-control" placeholder="请输入密码" required> <div class="checkbox"> <label> <input type="checkbox" value="remember-me" checked="checked"> 记住密码 </label> </div> <button type="submit" class="btn btn-primary" id="btn-login">登录</button> <a href="reg.jsp" class="btn btn-default">注册</a> </form> </div> <div class="col-md-4"> </div> </div> </body> </html>