package example.servlet.book;
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.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import example.bean.book.Book;
/**
* Servlet implementation class FindServlet
*/
public class FindServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @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/db_book?useUnicode=true&characterEncoding=utf-8";
// 数据库用户名
String username = "root";
// 数据库密码
String password = "";
// 创建Connection连接
Connection conn = DriverManager.getConnection(url, username,
password);
// 添加图书信息的SQL语句
String sql = "select * from tb_books";
// 获取Statement
Statement statement = conn.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
List<Book> list = new ArrayList<Book>();
while (resultSet.next()) {
Book book = new Book();
book.setId(resultSet.getInt("id"));
book.setName(resultSet.getString("name"));
book.setPrice(resultSet.getDouble("price"));
book.setBookCount(resultSet.getInt("bookCount"));
book.setAuthor(resultSet.getString("author"));
list.add(book);
}
request.setAttribute("list", list);
resultSet.close();
statement.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
request.getRequestDispatcher("book_list.jsp")
.forward(request, response);
}
/**
* @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);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
JdbcConnection
共27个文件
class:6个
java:6个
jsp:3个
5星 · 超过95%的资源 需积分: 35 1.0k 下载量 40 浏览量
2016-06-23
11:28:25
上传
评论 21
收藏 730KB RAR 举报
温馨提示
JdbcConnection 项目通过jsp+servlet+tomcat+mysql实现了对数据库的增删改查等功能,
资源推荐
资源详情
资源评论
收起资源包目录
JdbcConnection.rar (27个子文件)
JdbcConnection
WebContent
META-INF
MANIFEST.MF 39B
WEB-INF
web.xml 2KB
lib
mysql-connector-java-5.1.6-bin.jar 687KB
javax.servlet.jar 65KB
book_list.jsp 2KB
index.jsp 2KB
addbook.jsp 2KB
.settings
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.wst.common.project.facet.core.xml 305B
org.eclipse.wst.common.component 496B
org.eclipse.wst.jsdt.ui.superType.container 49B
.jsdtscope 503B
org.eclipse.jdt.core.prefs 364B
src
example
dao
book
ConnectionFactory.java 937B
BookJdbcDao.java 924B
bean
book
Book.java 831B
servlet
book
UpdateServlet.java 2KB
FindServlet.java 2KB
DeleteServlet.java 2KB
.project 1KB
.classpath 588B
build
classes
example
dao
book
BookJdbcDao.class 1KB
ConnectionFactory.class 1KB
bean
book
Book.class 1KB
servlet
book
FindServlet.class 3KB
UpdateServlet.class 2KB
DeleteServlet.class 2KB
共 27 条
- 1
伟雪无痕
- 粉丝: 96
- 资源: 22
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
前往页