登录 注册 servlet基础

最新推荐文章于 2023-07-02 18:46:12 发布
最新推荐文章于 2023-07-02 18:46:12 发布
阅读量264 收藏
点赞数
分类专栏： servlet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/Xiaobai_0106/article/details/108762308
版权

工具类 页面与数据库的交换

package org.lizhenhua.util;

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

public class DBHelper {
	static {
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public static Connection getconn() {
		Connection conn = null;

		try {
			conn = DriverManager.getConnection(
					"jdbc:sqlserver://localhost:1433;databaseName=school",
					"sa", "1");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return conn;

	}
  public static void close(Connection conn, PreparedStatement ps ,ResultSet rs){
	  try {
		  if(conn!=null)
		conn.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	 try {
		  if(ps!=null)
		ps.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	 try {
		  if(conn!=null)
		ps.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
  }
}

注册页面

package org.lizhenhua.service;

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.lizhenhua.util.DBHelper;

public class TestServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");

		Connection conn = null;
		conn = DBHelper.getconn();
		PreparedStatement ps = null;

		Boolean isTure = false;

		String userName = request.getParameter("username");
		String pwd = request.getParameter("pwd");
		Integer age = Integer.parseInt(request.getParameter("age"));

		String sql = "insert into Student  values (?,?,?)";
		try {
			ps = conn.prepareStatement(sql);

			ps.setString(1, userName);
			ps.setString(2, pwd);
			ps.setInt(3, age);

			int count = ps.executeUpdate();

			if (count > 0) {
				isTure = true;
			} else {
				isTure = false;
			}
			DBHelper.close(conn, ps, null);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out
				.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		if (isTure) {
			out.println("插入成功");
		
		}else{
			out.println("插入失败");
		}
		out.println("  </BODY>");
		out.println("</HTML>");
		out.flush();
		out.close();
	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public  void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		Operate op = new Operate();

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");

		Connection conn = null;
		conn = DBHelper.getconn();
		PreparedStatement ps = null;

		Boolean isTure = false;

		String userName = request.getParameter("username");
		String pwd = request.getParameter("pwd");
		Integer age = Integer.parseInt(request.getParameter("age"));

		String sql = "insert into Student  values (?,?,?)";
		try {
			ps = conn.prepareStatement(sql);

			ps.setString(1, userName);
			ps.setString(2, pwd);
			ps.setInt(3, age);

			int count = ps.executeUpdate();

			if (count > 0) {
				isTure = true;
			} else {
				isTure = false;
			}
			DBHelper.close(conn, ps, null);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out
				.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		if (isTure) {
			out.println("插入成功");
			
		}else{
			out.println("插入失败");
		}
		out.println("  </BODY>");
		out.println("</HTML>");
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 * 
	 * @throws ServletException
	 *             if an error occurs
	 */

}

登录页面

package org.lizhenhua.service;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

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

import org.lizhenhua.model.Student;
import org.lizhenhua.util.DBHelper;

public class LoginTest extends HttpServlet {

	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 中文编码
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
     
		Connection conn = null;
		conn = DBHelper.getconn();
		PreparedStatement ps = null;

		Boolean isTure = false;
   //  获取页面值
		String userName = request.getParameter("username");
		String pwd = request.getParameter("pwd");

		String sql = "select * from Student where user_name=?  and pwd=?  ";

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out
				.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, userName);
			ps.setString(2, pwd);
			ResultSet rs = ps.executeQuery();
			//设置一个数组
			ArrayList<Student> stuList = new ArrayList<Student>();
			while (rs.next()) {
				//  把页面信息储存道model里面
				Student stu = new Student();
				stu.setId(rs.getInt("id"));
				stu.setUserName(rs.getString("user_name"));
				stu.setPwd(rs.getString("pwd"));
				stu.setAge(rs.getInt("age"));
				// 把信息打包带走
				stuList.add(stu);
			}
			
			//  循环输出
			for(Student stu : stuList){
				out.println(stu.toString());
				out.println("\n");
			}
			
			DBHelper.close(conn, ps, rs);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

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

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 中文编码
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
     
		Connection conn = null;
		conn = DBHelper.getconn();
		PreparedStatement ps = null;

		Boolean isTure = false;
   //  获取页面值
		String userName = request.getParameter("username");
		String pwd = request.getParameter("pwd");

		String sql = "select * from Student  ";

		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out
				.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		try {
			ps = conn.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			//设置一个数组
			ArrayList<Student> stuList = new ArrayList<Student>();
			while (rs.next()) {
				//  把页面信息储存道model里面
				Student stu = new Student();
				stu.setId(rs.getInt("id"));
				stu.setUserName(rs.getString("user_name"));
				stu.setPwd(rs.getString("pwd"));
				stu.setAge(rs.getInt("age"));
				// 把信息打包带走
				stuList.add(stu);
			}
			if(isTrue){
			//  循环输出
			for(Student stu : stuList){
				out.println(stu.toString());
				out.println("\n");
			}
			
			DBHelper.close(conn, ps, rs);
		}else{
		out.println("插入失败");
}} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

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

}

web.xml代码

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
	xmlns="http://java.sun.com/xml/ns/javaee" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <servlet>
    <description>This is the description of my J2EE component</description>
    <display-name>This is the display name of my J2EE component</display-name>
    <servlet-name>testServlet</servlet-name>
    <servlet-class>org.lizhenhua.service.TestServlet</servlet-class>
  </servlet>
  <servlet>
    <description>This is the description of my J2EE component</description>
    <display-name>This is the display name of my J2EE component</display-name>
    <servlet-name>Login</servlet-name>
    <servlet-class>org.lizhenhua.service.LoginTest</servlet-class>
  </servlet>


  <servlet-mapping>
    <servlet-name>testServlet</servlet-name>
    <url-pattern>/testServlet</url-pattern>
  </servlet-mapping>
  <servlet-mapping>
    <servlet-name>Login</servlet-name>
    <url-pattern>/Login</url-pattern>
  </servlet-mapping>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

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 action="testServlet" method="post">
			用户名：
			<input type="text" name="username" /><br/>
			密码：
			<input type="password" name="pwd" /><br/>
			年龄：
			<input type="text" name="age" /><br/>
			<input type="submit" value="注册" />
		</form>
		
		<form action="Login" method="post">
			用户名：
			<input type="text" name="username" /><br/>
			密码：
			<input type="password" name="pwd" /><br/>
			
			<input type="submit" value="登录" />
		</form>
	</body>
</html>

关于页面的跳转

//jsp文件里面添加
<a href="">还没有账号注册<a>  --"里面填写你的jsp文件  例如  index.jsp"
//java代码里面添加
在body里面
response.sendRedirect("");"里面填写你的jsp文件  例如  index.jsp"

关于jsp文件

加载src下面的包
import=“org.lizhenhua.util."
加载sql可以直接使用 Connection 等 s
import="java.sql.”

<body>
		<!-- 这是注释   客户端通过f12可以查到 -->
		<%-- 这也是注释客户端通过f12看不到注释 --%>
		<table border="1px solid red">
		<tr><th>编号</th><th>用户名</th> <th>密码</th></tr>
			<%
				

				Connection conn = null;
				PreparedStatement ps = null;
				conn = DBHelper.getconn();
				String sql = "select * from Student";
				ps = conn.prepareStatement(sql);
				ResultSet rs = null;
				rs = ps.executeQuery();
				try {
					while (rs.next()) {
			%>

			<tr>
				<td>
				<!-- 表达式输出  java 的值    以表格的形式输出 数据库列名下面的值-->
				<%=rs.getInt("id")%></td>
				<%=rs.getString("user_name")%></td>
				<%=rs.getString("pwd")%></td>
				</td>
			</tr>

			<%
				}
				} catch (SQLException e) {

				}
			%>
		</table>
		
	

	</body>
java 用户注册代码_JAVA语言之Servlet案例：用户注册[Java代码]
weixin_32145807的博客
02-20 444
本文主要向大家介绍了JAVA语言的Servlet案例：用户注册，通过具体的内容向大家展示，希望对大家学习JAVA语言有所帮助。数据库准备：CREATE DATABASE web;USE web;CREATE TABLE `user` (`uid` VARCHAR(64) NOT NULL,`username` VARCHAR(20) DEFAULT NULL,`password` VARCHAR(...
jsp+servlet实现简单的登录注册
04-14
【标题】"jsp+servlet实现简单的登录注册"是关于Web开发的一个基础教程，主要涉及到Java服务器页面（JSP）和Servlet技术的结合使用，用于构建用户登录和注册功能。在这个项目中，开发者会学习如何利用这两者来处理...
servlet 注册登陆
09-07
servlet 注册登陆 里面有login register showinfo errorPage 等JSP的基本范例.
一个简单的Servlet注册实例
weixin_30555753的博客
12-15 135
我们在利用Servlet进行web开发的时候 ,运行的不是 JSP页面 而实际上是一个 Java类的对象 。这个类的对象从 javax.sevlet.http.HttpServlet ;这个类是基于HTTP的 Servlet类 我们自己写的 Servlet应该从 这个类派生而来 . 通过我们自己编写的类 以及对web.xml的部署 ，进行web的流程控制 ，实现用户与服务器的交...
Servlet注册
ilymtm的博客
04-14 239
<!--注册servlet--> <servlet> <servlet-name>hello</servlet-name> <servlet-class>com.wang.servlet.HelloServlet</servlet-class> </servlet> <!--servlet请求路径--> <servlet-mapping> <servlet-name&g.
注册页面的servlet
09-26 297
package cn.itcast.travel.web.servlet;import cn.itcast.travel.domain.ResultInfo;import cn.itcast.travel.domain.User;import cn.itcast.travel.service.UserService;import cn.itcast.travel.service.impl...
Servlet+mysql+tomcat实现简单登录和注册
09-07
在本项目中，"Servlet+mysql+tomcat实现简单登录和注册"，主要涉及了Web开发中的几个核心技术，包括Servlet、JSP、MySQL数据库以及Tomcat服务器。下面将详细阐述这些知识点及其相互间的配合。 1. **Servlet**： ...
MVC.rar_MVC 登录_MVC登录注册_jsp登录注册mvc_servlet用户注册_登录注册
09-22
在描述中提到的"在jsp中用bean和servlet联合实现用户注册、登录"，这是在Java Web开发中常见的一种实践。JSP（JavaServer Pages）是动态网页技术，用于创建视图部分，而Servlet是Java编写的服务器端程序，主要处理...
JSP+Servlet + JDBC+MySQL 注册和登录
08-28
在IT行业中，构建基于Web的用户注册和登录系统是一项基础且重要的任务，通常涉及前端界面、后端逻辑处理以及数据库交互。在这个项目中，“JSP+Servlet + JDBC+MySQL 注册和登录”就是一个典型的技术栈，用于实现这样...
Jsp+Servlet实现简单登录注册查询
10-14
在本文中，我们将探讨如何使用JSP（JavaServer Pages）和Servlet技术来实现一个简单的登录注册查询系统。JSP是Java的一种动态网页技术，而Servlet则是用于处理HTTP请求的Java类。结合这两者，我们可以创建一个用户...
基于servlet的登录注册界面
03-30
通过servlet响应请求，连接mysql数据库，有一些注册判断，ajax用户名查重等小功能，还有filter编码过滤器，本人也才学没多久，仅供参考。
servlet实现登录注册等源码
06-05
采用servlet+mysql+jdbc实现后台注册登录上传头像等
jsp+servlet实现最基本的注册登陆功能
02-21
使用jsp，servlet实现的注册和登陆功能源码和数据库，详细介绍网址http://www.cnblogs.com/biehongli/p/6424406.html
servlet登录注册
weixin_45940457的博客
10-22 244
package xyz.jrkang.util; import java.sql.*; public class DbHelper { // 1.加载驱动 private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=school";
基于servlet简单注册
脚踏实地
03-06 401
项目结构如下： 配置web.xml设置注册页面请求处理 &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:s...
Spring Boot注册Servlet三大组建（Servlet、Filter、Listener）
IT1995的博客
04-18 5168
目录 理论 演示及代码 理论 在Spring Boot中使用下面3个函数可以注册Servlet、Filter、Listener ServletRegistrationBean FilterRegistrationBean ServletListenerRegistrationBean 演示及代码 首先是Servlet请求： 注册Filter后的现象：...
Eclipse内servlet用户密码登陆实现
菜鸟拥有不太多的知识
11-11 2675
JSP代码 <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body>
浅学Servlet笔记(顺带实现注册、登录的简单小项目)
最新发布
Destiny_Di的博客
07-02 1504
简单学习Servlet，分享一个实现注册登录功能的小项目
注册servlet的两种方式
是微风，是晚霞，是无可替代
03-08 3079
注册servlet的两种方式1. 在web.xml文件中注册2. 在servlet类前面直接使用@WebServlet注解注册Servlet 1. 在web.xml文件中注册 <?xml version="1.0" encoding="UTF-8"?> <web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值