2020-09-24

chhuen

于 2020-09-24 13:03:21 发布

阅读量76

点赞数

本文链接：https://blog.csdn.net/chhuen/article/details/108771989

版权

1：先建一个DBUtil工具类

package org.cyt.util;

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

public class DBUtil {
   static {
       try {
           Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

} catch (ClassNotFoundException e) {
e.printStackTrace();

}
}

   public static Connection getConn() {
       Connection conn = null;
       try {
           conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=work","sa","1");
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
       return conn;

}

public static void close(java.sql.Connection conn, PreparedStatement ps,
ResultSet rs) {

       try {
           if (conn != null)
               conn.close();
       } catch (SQLException e1) {
           // TODO Auto-generated catch block
           e1.printStackTrace();
       }
       try {
           if (ps != null)
               ps.close();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
       try {
           if (rs != null)
               rs.close();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
   }
}

2：创建一个Java文件

package org.cyt;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.cyt.util.DBUtil;

public class RegServlet extends HttpServlet {

   public void doGet(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException {
       doPost(request, response);
   }

   public void doPost(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException {
       request.setCharacterEncoding("utf-8");
       response.setCharacterEncoding("utf-8");
       response.setContentType("text/html");

       String name = request.getParameter("name");
       String ageStr = request.getParameter("age");
       String pwd = request.getParameter("pwd");
       String userName = request.getParameter("userName");
       // Integer age = Integer.parseInt("ageStr");

       boolean isTrue = false;
       Connection conn = DBUtil.getConn();
       String sql = "insert into Student values(?,?,?,?)";

       PreparedStatement ps = null;
       try {
           ps = conn.prepareStatement(sql);
           ps.setString(1, name);
           ps.setString(2, ageStr);
           ps.setString(3, pwd);
           ps.setString(4, userName);

           int count = ps.executeUpdate();
           if (count > 0) {
               isTrue = true;
           } else {
               isTrue = false;
           }

} catch (SQLException e) {
e.printStackTrace();

       }
       DBUtil.close(conn, ps, null);
       response.setContentType("text/html;charset=utf-8");
       PrintWriter out = response.getWriter();
       out.println("<!DOCTYPE HTML PUBLTC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
       out.println("<HTML>");
       out.println("<HEAD><TITLE>A Servlet</TITLE></HEAD>");
       out.println("<BODY>");
       if (isTrue) {
           out.println("<h1 style ='color:green'>注册成功!<h1>");
       } else {
           out.println("<h1 style ='color:red'>注册失败!<h1>");
       }

       out.println("</BODY>");
       out.println("</HTML>");
       out.flush();
       out.close();
   }
}

3：创建一个jsp文件

<!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">
   
</head>

<body>
<form action="<%=basePath%>regServlet" method="post">
姓名：
<input type="text" name="name"/>
<br/>
年龄：
<input type="text" name="age"/>
<br/>

密码：
<input type="password" name="pwd"/>
<br/>
用户名：
<input type="text" name="userName"/>
<br/>

<input type="submit" value="注册">
</form>
</body>
</html>

启动Tomcat，在浏览器输入http://127.0.0.1:8080/Lesson11进行访问

chhuen

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
2020-09-24

1：先建一个DBUtil工具类package org.cyt.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class DBUtil { static { try { Cl...
复制链接

扫一扫