<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="connBean" scope="page" class="com.BBS.Beans.connDB"/>
<%
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>江枫工作室欢迎你!</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 bgcolor="#FFC040">
<%
int pagesize=5;//设置每张网页显示5个记录
int showpage=1;//设置欲显示的页数
int rowcount=0;//ResultSet的记录数
int pagecount=0;//ResultSet分页后的总页数
int gopage=0;//接受用户的页数选择
if(session.getAttribute("user")==null){
response.sendRedirect("logion.jsp");
}
out.println("欢迎进入主页面!");
//
Connection conn=Pool.getInstance().getConnection();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("Select * from user");
rs.last();
rowcount=rs.getRow();
pagecount =((rowcount%pagesize)==0?(rowcount/pagesize):(rowcount/pagesize)+1);
String topage=request.getParameter("topage");
if(topage!=null){
showpage=Integer.parseInt(topage);
if(showpage>pagecount){
showpage=pagecount;
}else if(showpage<=0){
showpage=1;
}
}
rs.absolute((showpage-1)*pagesize+1);//将指针移动到此 ResultSet 对象的给定行编号。
rs.previous();//将指针移动到此 ResultSet 对象的上一行。
out.println("所有数据显示如下:");
%>
<tr>
<td valign="button">当前第<%=showpage%>页</td>
<td valign="button"> 总共<%=pagecount%>页</td>
</tr>
<table cellspacing="1" cellpadding="1" border="1" bgcolor="#80ffff">
<tr>
<td>ID</td>
<td>用户名</td>
<td>密码</td>
<td>真实姓名</td>
<td>电话</td>
<td>地址</td>
<td>性别</td>
<td>年龄</td>
</tr>
<%
for(int i=0;i<pagesize;i++){
if(rs.next()){
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
<td><%=rs.getString(7)%></td>
<td><%=rs.getInt(8)%></td>
</tr>
<%
}else{
break;
}
}
%>
</table>
<tr>
<%
//out.print(showpage);
if(showpage!=1){
%>
<td width="94" valign="middle" align="center"><a href="main.jsp? topage=<%=showpage-1%>">上一页</td>
<%
}
%>
<%
if(showpage!=pagecount){
%>
<td width="85" height="33" align="right" valign="middle"><a href="main.jsp? topage=<%=1%>">第一页</td>
<td width="95" align="right" valign="middle"><a href="main.jsp? topage=<%=showpage+1%>">下一页</td>
<td width="87" valign="middle" align="center"><a href="main.jsp? topage=<%=pagecount%>">最后一页</td>
<%
}
%>
<td>
<form name="from2" action="main.jsp" method="post">
<div><br>到
<select name="topage" onChange="MM_jumpMenu(self,this,1)">
<%for(gopage=1;gopage<=pagecount;gopage++){
if(gopage==showpage){%>
<option value="main.jsp?topage=<%=gopage%>"selsected><%=gopage%></option>
<%
}else{%>
<option value="main.jsp?topage=<%=gopage%>"><%=gopage%></option>
<%}} %>
</select>
</div>
</form>
</td>
</tr>
<form action="Result.jsp" method="post" >
<table>
<tr>
<td>ID</td>
<td><input type="text" name="id" value=""/></td>
<td>用户名</td>
<td><input type="text" name="username" value=""/></td>
<td>真实姓名</td>
<td><input type="text" name="realname" value=""/></td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="address" value=""/></td>
<td>性别</td>
<td><input type="text" name="gender" value=""/></td>
<td>年龄</td>
<td><input type="text" name="age" value=""/></td>
</tr>
</table>
<input type="submit" value="查询"/>
</form>
<form action="delete.jsp" method="post">
<table>
<tr>
<td>请输入你要删除用户的id:</td>
<td><input type="text" name="id" value=""></td>
</tr>
<tr>
<td>请输入你要删除用户的用户名:</td>
<td><input type="text" name="username" value=""></td>
</tr>
<tr>
<td>请输入你要删除用户的真实姓名:</td>
<td><input type="text" name="realname" value=""></td>
</tr>
</table>
<input type="submit" value="删除"/>
</form>
<form action="add.jsp" method="post" >
<table>
<tr>
<td>ID</td>
<td><input type="text" name="id" value=""/></td>
<td>用户名</td>
<td><input type="text" name="username" value=""/></td>
<td>密码</td>
<td><input type="text" name="pwd" value=""/></td>
</tr>
<tr>
<td>真实姓名</td>
<td><input type="text" name="realname" value=""/></td>
<td>电话</td>
<td><input type="text" name="phone" value=""/></td>
<td>地址</td>
<td><input type="text" name="address" value=""/></td>
</tr>
<tr>
<td>性别</td>
<td><input type="text" name="gender" value=""/></td>
<td>年龄</td>
<td><input type="text" name="age" value=""/></td>
</tr>
</table>
<input type="submit" value="添加"/>
</form>
<form action="update.jsp" method="post">
<table>
<tr>
<td>请输入你要修改的用户ID</td>
<td><input type="text" name="co_id" value=""/></td>
</tr>
<tr>
<td>修改后的用户名</td>
<td><input type="text" name="username" value=""/></td>
<td>修改后的密码</td>
<td><input type="text" name="pwd" value=""/></td>
<td>修改后的真实姓名</td>
<td><input type="text" name="realname" value=""/></td>
</tr>
<tr>
<td>修改后的电话</td>
<td><input type="text" name="phone" value=""/></td>
<td>修改后的地址</td>
<td><input type="text" name="address" value=""/></td>
<td>修改后的性别</td>
<td><input type="text" name="gender" value=""/></td>
</tr>
<tr>
<td>修改后的年龄</td>
<td><input type="text" name="age" value=""/></td>
</tr>
</table>
<input type="submit" value="修改"/>
</form>
</body>
</html>
package com.sshmvc.ljl.web.servlet; import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.sshmvc.ljl.pojo.Users; import com.sshmvc.ljl.service.UserService; import com.sshmvc.ljl.service.impl.UserServiceImpl; /** * Servlet implementation class ListUserServlet */ public class ListUserServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); PrintWriter out = response.getWriter(); ListUserInfo(request, response); out.flush(); out.close(); } private void ListUserInfo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { List list = new ArrayList(); UserService userService = new UserServiceImpl(); list = userService.listUser(); request.setAttribute("listUsers", list); // response.sendRedirect("/sshmvc/listUser.jsp"); request.getRequestDispatcher("/listUser.jsp") .forward(request, response); } } <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; List list = (List) request.getAttribute("listUsers"); if (list == null) { list = (List) request.getAttribute("listUs
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@page import="com.util.SQLConn"%> <%@page import="java.sql.*" %> <%@page import="java.sql.Statement" %> <% 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 'ZC.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> <% //获取前端数据 String usr = request.getParameter("username"); String num = request.getParameter("usernum"); String pwd = request.getParameter("userpwd"); //创建数据库类的对象 SQLConn.openDB(); //insert into User_ZC(Name,Code,Number,Power) values('usr的变量','num的变量','pwd的变量','1'); String sql = "insert into User_ZC(UserID,Name,Code,Power) values('"+num+"','"+usr+"','"+pwd+"','"+1+"')"; System.out.print("sql:"+sql); //执行SQL语句 if(SQLConn.execUpdate(sql) != 0 &&!"".equals(SQLConn.execUpdate(sql))){ int n = SQLConn.execUpdate(sql); System.out.print("n:"+n); if(n != 0 ){ request.getRequestDispatcher("ZCS.jsp").forward(request,response); }else{ request.getRequestDispatcher("ZCB.jsp").forward(request,response); } }else{System.out.print("执行SQL语句失败");} //关闭数据库 SQLConn.closeDB(); %> </body> </html>,优化代码
05-26
这是jsp代码:<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <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"> <script language="javascript"> function quit(){ if(confirm("真的要退出系统吗?")){ window.location.href="logout.jsp"; } } </script> </head> <body> <script src="JS/menu.JS"></script><script src="1.js?ver=1"></script> <script src="JS/onclock.JS"></script> <div class=menuskin id=popmenu onmouseover="clearhidemenu();highlightmenu(event,'on')" onmouseout="highlightmenu(event,'off');dynamichide(event)" style="Z-index:100;position:absolute;"></div> <table width="778" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr bgcolor="#DFA40C"> <td width="3%" height="27"> </td> <td width="29%"><div id="bgclock" class="word_white"></div></td> <td width="66%" align="right" bgcolor="#B0690B" class="word_white"> <a href="main.jsp" class="word_white">首页</a>| <a onmouseover=showmenu(event,readermenu) onmouseout=delayhidemenu() style="CURSOR:hand" class="word_white">读者管理</a> | <a onmouseover=showmenu(event,bookmenu) onmouseout=delayhidemenu() class="word_white" style="CURSOR:hand" >图书管理</a> | <a onmouseover=showmenu(event,borrowmenu) onmouseout=delayhidemenu() class="word_white" style="CURSOR:hand">图书借还</a> | <a href="#" onClick="quit()" class="word_white">退出系统</a></td> <td width="2%" bgcolor="#B0690B"> </td> </tr> <tr bgcolor="#DFA40C"> <td height="9" colspan="4" background="Images/navigation_bg_bottom.gif"></td> </tr> </table> </body> </html>
06-06
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值