javabean文件源代码
package DatabaseAccess;
import java.sql.*;
/**
*
* @author Admin
*/
public class DatabaseAccess {
private String drv="com.mysql.jdbc.Driver";//数据库驱动类
private String url="jdbc:mysql://localhost:3306/web?characterEncoding=utf8";//数据库地址
private String usr="root";
private String pwd="123456";
private Connection conn=null;
private Statement stm=null;
private ResultSet rs=null;
/**
*用于链接Mysql数据库
*构造方法
*无
*/
public DatabaseAccess(){
try{
Class.forName(drv); //加载数据库驱动程序
conn=DriverManager.getConnection(url,usr,pwd); //链接数据库
stm=conn.createStatement();
}catch(Exception e){
System.out.println(e.toString());
}
}
/**
*用于更新数据库中的数据
*String类型
*boolean类型
*/
public boolean update(String sql){
boolean b = false;
try{
stm.executeUpdate(sql);
b = true;
}catch(Exception e){
System.out.println(e.toString());
}
return b;
}
/**
*用于查询数据库中的数据
*String类型
*ResultSet类型
*/
public ResultSet query(String sql){
try{
rs = stm.executeQuery(sql);
}catch(Exception e){
System.out.println(e.toString());
}
return rs;
}
public void close(){
try{
if(rs!=null){
conn.close();
}
if(stm!=null){
conn.close();
}
if(conn!=null){
conn.close();
}
}catch(Exception ex){
System.out.println(ex);
}
}
}
servlet文件
package DatabaseOperation;
import DatabaseAccess.DatabaseAccess;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author sw
*/
@WebServlet(name = "Getdata", urlPatterns = {"/Getdata"})
public class Getdata extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code>
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String sql="select * from user order by id";
ResultSet rs = null;
DatabaseAccess db = new DatabaseAccess();
rs = db.query(sql);
request.setAttribute("r", rs);
request.getRequestDispatcher("seek.jsp").forward(request, response);
db.close();
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
/* TODO output your page here. You may use following sample code. */
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
利用jsp显示
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<%
ResultSet rs=(ResultSet)request.getAttribute("r");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>数据</title>
</head>
<body>
<center>
<h1>user表</h1>
<table border="1" cellpaddind="5" bordercolor="blue" style="border-color: ">
<tr>
<td>ID</td><td>姓名</td><td>密码</td><td>邮箱</td>
</tr>
<%
if(rs!=null){
while (rs.next()){
out.print("<tr>");
for(int i=1;i<=4;i++) {
out.print("<td>" + rs.getString(i) + "</td>");
}
out.print("</tr>");
}
}
%>
</table>
</center>
</body>
</html>