jsp注册（mysql数据库）

最新推荐文章于 2023-05-09 18:26:45 发布

yuehailin

最新推荐文章于 2023-05-09 18:26:45 发布

阅读量759

点赞数 1

本文链接：https://blog.csdn.net/yuehailin/article/details/75194694

版权

注册并存入数据库其实说白了就是从网页的表单中获取信息并存入数据库，我们来看一个简单的示例

index.jsp

<%--
  Created by IntelliJ IDEA.
  User: yuehailin
  Date: 2017/7/15
  Time: 8:29

--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!-- 导入的三个包真的很重要，切记不要忘记 -->
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.PreparedStatement" %>

<!-- 解决中文乱码的问题 -->
<%request.setCharacterEncoding("UTF-8"); %>

<!DOCTYPE>
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <title>Insert title here</title>
</head>
<script language="javascript">
    function isValid(form)
    {
        if (form.username.value=="")
        {
            alert("用户名不能为空");
            return false;
        }
        if (form.pwd.value!=form.pwd2.value)
        {
            alert("两次输入的密码不同！");
            return false;
        }
        else  if (form.pwd.value=="")
        {
            alert("用户密码不能为空！");
            return false;
        }
        else return true;
    }
</script>
</head>

<body>

  <body bgcolor="#e3e3e3">
  <h2>用户注册</h2>
  <form action="check2.jsp" method="post" onSubmit="return isValid(this);">
    <table>
      <tr><td>用户名:</td><td><input type="text" name="username" size="20"/></td></tr>
      <tr><td>输入密码:</td><td><input type="text" name="pwd" size="20"/></td></tr>
      <tr><td>再次确认密码:</td><td><input type="text"name="pwd2" size="20"/></td><tr>
      <tr><td><input type="submit" value="注册"/><td><input type="reset" value="重置"/>
    </table>
  </form>

<br>
</body>
</html>

check2.jsp

<%--
  Created by IntelliJ IDEA.
  User: yuehailin
  Date: 2017/7/15
  Time: 22:39
 
--%>
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=utf-8"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
    <base href="<%=basePath%>">

    <title>检验注册页面</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>
<br>
<%
    request.setCharacterEncoding("utf-8");
    String users=request.getParameter("username");
    String pass=request.getParameter("pwd");
%>
<%
    String driver = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://localhost:3306/bbs";
    String use = "root";
    String password = "123";
    Class.forName(driver);
    Connection conn= DriverManager.getConnection(url,use,password);
    PreparedStatement sql =conn.prepareStatement("insert into user1(username,password)values(?,?)");
    sql.setString(1,users);
    sql.setString(2,pass);
    int rtn=sql.executeUpdate();
    sql.close();
    conn.close();
%>

</body>
</html>