使用JDBC查询数据
来源:互联网 发布:2017淘宝禁售商品明细 编辑:程序博客网 时间:2024/05/19 18:48
Book:
package com.home.web.dto;public class Book { private int id; private String name; private double price; private int bookCount; private String author; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public double getPrice() { return price; } public void setPrice(double price) { this.price = price; } public int getBookCount() { return bookCount; } public void setBookCount(int bookCount) { this.bookCount = bookCount; } public String getAuthor() { return author; } public void setAuthor(String author) { this.author = author; }}
package com.home.web.servlet;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;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 com.home.web.dto.Book;/** * Servlet implementation class AddServlet */@WebServlet("/FindServlet")public class FindServlet extends HttpServlet {private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public FindServlet() { super(); }/** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/test"; Connection conn = DriverManager.getConnection(url, "root", "123456"); Statement stmt = conn.createStatement(); String sql = "select * from t_books"; ResultSet rs = stmt.executeQuery(sql); List<Book> list = new ArrayList<>(); while (rs.next()) { Book book = new Book(); book.setId(rs.getInt("id")); book.setName(rs.getString("name")); book.setPrice(rs.getDouble("price")); book.setBookCount(rs.getInt("bookCount")); book.setAuthor(rs.getString("author")); list.add(book); } request.setAttribute("list", list); rs.close(); stmt.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } request.getRequestDispatcher("result.jsp").forward(request, response);}/** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response);}}
index.jsp:
<%@page import="java.net.URLDecoder"%><%@ 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><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>添加图书</title></head><body><a href="FindServlet">查看所有图书</a></body></html>
result.jsp:
<%@page import="java.sql.*"%><%@ page language="java" import="java.util.*" autoFlush="true"import="com.home.web.dto.*" 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><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><table align="center" width="450"><tr><td colspan="5" align="center"><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></tr><% List<Book> list = (List<Book>) request.getAttribute("list"); if (list == null || list.size() < 1) { out.println("没有数据!"); } 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></tr><% } }%></table></body></html>
0 0
- 使用JDBC查询数据
- Spring JDBC 怎样使用like查询数据
- 使用 jdbc 从数据库中查询数据
- JDBC查询数据
- JDBC数据查询
- java中使用ehcache对jdbc查询数据进行缓存
- java使用jdbc查询mysql数据最简单的例子
- 使用JDBC完成动态验证、采用MVC完成数据查询
- 关于Java中使用JDBC连接查询数据表中的数据
- java项目中使用JDBC连接mysql数据库查询数据
- java中使用JDBC连接mysql数据库查询数据
- jdbc查询数据库中数据
- jdbc 查询数据时出错
- JDBC查询数据库中的数据
- jdbc编程之数据查询
- JDBC编程之数据查询
- JDBC 实效数据分页查询
- JDBC--数据的查询准备工作
- IO流_输出语句用字符缓冲流改进
- Hibernate一对一外键关联双向/单向映射
- sleep()和wait()方法与对象锁、锁池、等待池
- 18-19 目录IO
- Lesson2 软件测试之测试理论概述(2)
- 使用JDBC查询数据
- Joda-Time代替Date和Calendar
- java代码块知识详解及应用实例
- sublime初识
- 【Oracle学习】之 约束
- Common Converter Connection Formats
- LeetCode 500 Keyboard Row
- Hwadee实训--day01
- 最大公共子序列,最大子段和(动态规划)