81,094
社区成员
发帖
与我相关
我的任务
分享
package jdbcConnection;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.RequestDispatcher;
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 org.apache.jasper.tagplugins.jstl.core.Out;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
/**
* Servlet implementation class UpdateServlet
*/
@WebServlet("/FindServlet")
public class FindServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public FindServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//response.getWriter().append("Served at: ").append(request.getContextPath());
//PrintWriter out=response.getWriter();
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/javaweb?useSSL=false";
String username="root";
String password="1223360222";
Connection conn=(Connection) DriverManager.getConnection(url,username,password);
Statement stmt=(Statement) conn.createStatement();
String sql="SELECT * FROM tb_bbok";
//out.print("hello world");
ResultSet rs=stmt.executeQuery(sql);
List<Book>list=new ArrayList<Book>();
while(rs.next()){
Book book=new Book();
book.setId(rs.getInt("id"));
book.setName(rs.getString("name"));
//out.println(rs.getInt("id"));
book.setPrice(rs.getFloat("price"));
book.setBookCount(rs.getInt("bookcount"));
//out.println(rs.getInt("bookcount")+111);
book.setAuthor(rs.getString("author"));
list.add(book);
}
request.setAttribute("list", list);
rs.close();
stmt.close();
conn.close();
//out.close();
}catch(ClassNotFoundException ex){
ex.printStackTrace();
}catch(SQLException ex){
ex.printStackTrace();
}
RequestDispatcher rd=request.getRequestDispatcher("bookQuery.jsp");
rd.forward(request, response);
}
}
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.util.List" %>
<%@ page import="jdbcConnection.Book" %>
<%@ page import="jdbcConnection.ConnectOption" %>
<%@ page import="jdbcConnection.FindServlet" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>查询书籍</title>
</head>
<body>
<%request.setCharacterEncoding("utf-8"); %>
<table align="center" width="450" border="1">
<tr>
<td align="center" colspan="6">
<h2>所有图书信息</h2>
</td>
</tr>
<tr align="center">
<td><b>ID</b></td>
<td><b>图书名称</b></td>
<td><b>价格</b></td>
<td><b>数量</b></td>
<td><b>作者</b></td>
<td><b>修改数量</b></td>
</tr>
<%
//获取图书集合
//ConnectOption co=new ConnectOption();
//ist<Book>list=co.Query();
List<Book>list=(List<Book>)request.getAttribute("list");
String names=(String)request.getAttribute("name");
out.print(names+"111");
if(list == null || list.size()<1){
out.print("没有数据");
}
else{
for(Book book :list){
%>
<tr align="center">
<td><%=book.getId() %></td>
<td><%=book.getName() %></td>
<td><%=book.getPrice() %></td>
<td><%=book.getBookCount() %></td>
<td><%=book.getAuthor() %></td>
<td>
<form action="UpdateServlet" method="post" onsubmit="return check(this)">
<input type="hidden" name="id" value="<%=book.getId() %>">
<input type="text" name="bookCount" size="3">
<input type="submit" value="修改">
</form>
</td>
</tr>
<%
}
}
%>
</table>
</body>
</html>