通过一个综合型的例子加深对JDBC操作数据库的增、删、改、查的运用。经典的图书信息录入实例设计数据库CREATETABLE`tb_books`(`id`int(10)unsignedNOTNULLAUTO_I
通过一个综合型的例子加深对JDBC操作数据库的增、删、改、查的运用。
经典的图书信息录入实例
设计数据库
CREATE TABLE `tb_books`( `id` int(10) unsigned NOT NULL AUTO_INCREMENT,`name` varchar(45) NOT NULL,`price` double NOT NULL,`bookCount` int(10) unsigned NOT NULL,`author` varchar(45) NOT NULL,PRIMARY KEY (`id`))
写一个Book类对图书信息进行封装
package com.lixiyu;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;}}
添加（insert）图书信息操作
创建AddBook.jsp页面，用于对添加图书信息进行处理
<%@ page language=”java” contentType=”text/html; charset=GB18030″pageEncoding=”GB18030″%><%@page import=”java.sql.Connection”%><%@page import=”java.sql.DriverManager”%><%@page import=”java.sql.PreparedStatement”%><meta http-equiv=”Content-Type” content
本文来源gao!%daima.com搞$代*!码$网9
=”text/html; charset=GB18030″>
创建insert.jsp，用于创建添加图书信息所需的表单
<%@ page language=”java” contentType=”text/html; charset=UTF-8″pageEncoding=”UTF-8″%><meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
添加图书信息 |
|
| 图书名称： | |
| 价 格： | |
| 数 量： | |
| 作 者： | |
最后运行
查询（select）图书信息操作
创建FindServlet的servlet对象用于查询所有图书的信息。编写doGet()方法，建立数据库连接，并将所有查询数据集合放置HttpServletRequest对象中，将请求转发到jsp页面中：
package com.lixiyu;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;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;/** * Servlet implementation class 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#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubtry{Class.forName(“com.mysql.jdbc.Driver”);String url=”jdbc:mysql://localhost:3306/db_test”;String username=”root”;String password=”lixiyu”;Connection conn=DriverManager.getConnection(url,username,password);Statement stmt=conn.createStatement();//获取statement对象String sql=”select * from tb_books”;ResultSet rs=stmt.executeQuery(sql);List list=new ArrayList();//实例化list对象while(rs.next()){Book book=new Book();book.setId(rs.getInt(“id”));//对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);//将图书集合放置到request中rs.close();//关闭ResultSetstmt.close();//关闭Statementconn.close();//关闭Connection}catch(ClassNotFoundException e){e.printStackTrace();}catch(SQLException e){e.printStackTrace();}request.getRequestDispatcher(“book_list.jsp”).forward(request, response);//请求转发到book_List.jsp}/*** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stub}}
转载请注明原文链接：JDBC操作数据库CRUD综合应用实例
