HTML混合JAVA(可跳转页面的)的简单书写

最新推荐文章于 2023-03-15 17:37:20 发布

SunnyTXM

最新推荐文章于 2023-03-15 17:37:20 发布

阅读量402

点赞数

分类专栏：教程向文章标签： mysql jsp java

本文链接：https://blog.csdn.net/SunnyTXM/article/details/108866882

版权

教程向专栏收录该内容

2 篇文章 0 订阅

订阅专栏

本文展示了如何使用JSP和Servlet进行数据交互。通过JSP页面连接数据库，从users表中检索数据并展示在表格中。同时，提供了一个Servlet实例，演示了用户注册过程，包括接收参数、插入数据到数据库以及根据操作结果重定向至相应页面。

摘要由CSDN通过智能技术生成

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.Connection"%>
<%@page import="org.cst.util.DBUtil"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet"%>
<%
	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>

		<table border="1px solid ">
			<tr>
				<th>
					id
				</th>
				<th>
					姓名
				</th>
				<th>
					年龄
				</th>
				<th>
					用户名
				</th>
				<th>
					密码
				</th>
			</tr>
			
			<%
				Connection conn = DBUtil.getconn();
				
				String sql = "select * from users";
				
				PreparedStatement ps = conn.prepareStatement(sql);
				
				ResultSet rs = ps.executeQuery();
				while (rs.next()) {//循环,显示查询内容
			%>
			
			<tr>
				<td><%=rs.getInt("id")%></td>
				<td><%=rs.getString("name")%></td>
				<td><%=rs.getInt("age")%></td>
				<td><%=rs.getString("user_name")%></td>
				<td><%=rs.getString("pwd")%></td>
			</tr>
			<%
				}
				DBUtil.close(conn, ps, rs);
			%>
		</table>




	</body>
</html>

HTML和JAVA的简单书写

链接SQL数据库的书写–

package org.cst.servlet;

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 javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.cst.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");
		
		String userName = request.getParameter("userName");//获取用户名
		String pwd = request.getParameter("pwd");//获取密码
		String name=request.getParameter("name");//获取姓名
		String agestr=request.getParameter("age");//获取年龄
		Integer age =Integer.parseInt(agestr);//转换数据类型
		
		Connection conn = DBUtil.getconn();
		ResultSet rs = null;
		boolean isTrue = true;
		
		
		String sql ="insert into users(name,pwd,age,user_name) values(?,?,?,?);";//sql语句
		
		PreparedStatement ps=null;
		
			try {
			ps = conn.prepareStatement(sql);
			
			ps.setString(1, name);//第一个？内容
			ps.setString(2, pwd);//第二个？内容
			ps.setInt(3, age);//第三个？内容
			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, rs);
		response.setContentType("text/html");
		
		PrintWriter out = response.getWriter();
		if (isTrue) {
			
			response.sendRedirect("login.jsp");//成功，跳转登录页面
		} else {
			response.sendRedirect("index.jsp");//失败，重新注册
		}
		out.flush();
		out.close();
	}
}