今日总结：javascript实现浏览功能
servlet部分：
package servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import dao.Dao;
import javabean.Guke;
@WebServlet("/LiuallServlet")
public class LiuallServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Dao dao=new Dao();
request.setCharacterEncoding("utf-8");
List<Guke> guke=dao.liulanall();
request.setAttribute("guke",guke);
request.getRequestDispatcher("liulanguke.jsp").forward(request, response);
}
Dao部分：
public List<Guke> liulanall() {
List<Guke> list1=new ArrayList<>();
Connection con=DBUtil.getConn();
PreparedStatement pstmt=null;
ResultSet rs=null;
try {
String sql="select * from guke ";
pstmt=con.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next()) {
String identity=rs.getString("identity");
String guname=rs.getString("guname");
String gusex=rs.getString("gusex");
String gunumber=rs.getString("gunumber");
String guaddress=rs.getString("guaddress");
Guke guke=new Guke(identity,guname,gusex,gunumber,guaddress);
list1.add(guke);
}
}catch(SQLException e) {
e.printStackTrace();
}finally {
DBUtil.close(rs,pstmt, con);
}
return list1;
}
html部分：
<%@page import="javabean.Guke"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>房产经纪功能页</title>
</head>
<body>
<style type="text/css">
.menu3{
background-color:#F5DEB3;
width:500px;
height:300px;
position:relative;
top:0px;
}
</style>
<table border="1px">
<tr>
<th>身份号码</th>
<th>姓名</th>
<th>性别</th>
<th>手机号</th>
<th>家庭地址</th>
<th>删除</th>
</tr>
<%
List<Guke> guke=(List<Guke>)request.getAttribute("guke");
for(Guke x:guke){
%>
<tr>
<td><%=x.getIdentity() %></td>
<td><%=x.getGuname() %></td>
<td><%=x.getGusex() %></td>
<td><%=x.getGunumber() %></td>
<td><%=x.getGuaddress() %></td>
<td><a href="DeleteServlet?method=<%=x.getGuname() %>">删除</a></td>
</tr>
<%
}
%>
</table>
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 25岁的心里话
· 闲置电脑爆改个人服务器（超详细） #公网映射 #Vmware虚拟网络编辑器
· 零经验选手，Compose 一天开发一款小游戏！
· 因为Apifox不支持离线，我果断选择了Apipost！
· 通过 API 将Deepseek响应流式内容输出到前端