天天看点
返回

JSP+Servlet+JavaBean+JDBC

tables.jsp

  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

  2. <%@ page import="java.sql.DriverManager" %>

  3. <%@ page import="java.sql.PreparedStatement" %>

  4. <%@ page import="java.sql.ResultSet" %>

  5. <%@ page import="java.sql.SQLException" %>

  6. <%@ page import="java.sql.Connection" %>

  7. <%@ page import="java.sql.Statement" %>

  8. <%@ page import="model.User" %>

  9. <%@ page import="javax.servlet.http.HttpServletRequest" %>

  10. <!DOCTYPE html>

  11. <html lang="en">

  12. <%@ include file="menu.jsp" %>

  13. <body>

  15. <div id="content">

  16. <div id="content-header">

  17. <h1>Tables</h1>

  18. <div class="btn-group">

  19. <a class="btn btn-large tip-bottom" title="Manage Files"><i class="icon-file"></i></a>

  20. <a class="btn btn-large tip-bottom" title="Manage Users"><i class="icon-user"></i></a>

  21. <a class="btn btn-large tip-bottom" title="Manage Comments"><i class="icon-comment"></i><span class="label label-important">5</span></a>

  22. <a class="btn btn-large tip-bottom" title="Manage Orders"><i class="icon-shopping-cart"></i></a>

  23. </div>

  24. </div>

  25. <div id="breadcrumb">

  26. <a href="#" title="Go to Home" class="tip-bottom"><i class="icon-home"></i> Home</a>

  27. <a href="#" class="current">Tables</a>

  28. </div>

  29. <div class="container-fluid">

  30. <div class="row-fluid">

  31. <div class="span12">

  33. <div class="widget-box">

  34. <div class="widget-title">

  36. <h5>Dynamic table</h5>

  37. </div>

  38. <div class="widget-content nopadding">

  39. <table class="table table-bordered data-table">

  40. <thead>

  41. <tr>

  42. <th>ID</th>

  43. <th>USER</th>

  44. <th>NAME</th>

  45. <th>TEL</th>

  46. </tr>

  47. </thead>

  48. <tbody>

  49. <%

  50. List<User> list = new ArrayList<User>();

  51. list = (List<User>)request.getAttribute("list");

  52. for (User user : list){

  53. %>

  54. <tr>

  55. <td><%=user.getId() %></td>

  56. <td><%=user.getAccount() %></td>

  57. <td><%=user.getUsername() %></td>

  58. <td><%=user.getTel() %></td>

  59. </tr>

  60. <%} %>

  61. </tbody>

  62. </table>

  63. </div>

  64. </div>

  65. </div>

  66. </div>

  68. <div class="row-fluid">

  69. <div id="footer" class="span12">

  70. 2012 &copy; UniAdmin.</div>

  71. </div>

  72. </div>

  73. </div>

  77. <script src="js/jquery.min.js"></script>

  78. <script src="js/jquery.ui.custom.js"></script>

  79. <script src="js/bootstrap.min.js"></script>

  80. <script src="js/jquery.uniform.js"></script>

  81. <script src="js/select2.min.js"></script>

  82. <script src="js/jquery.dataTables.min.js"></script>

  83. <script src="js/unicorn.js"></script>

  84. <script src="js/unicorn.tables.js"></script>

  85. </body>

  86. </html>

web.xml

  1. <?xml version="1.0" encoding="UTF-8"?>

  2. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">

  3. <display-name>web_project</display-name>

  4. <welcome-file-list>

  5. <welcome-file>welcome.jsp</welcome-file>

  6. </welcome-file-list>

  7. <servlet>

  8. <servlet-name>FindServlet</servlet-name>

  9. <servlet-class>servlet.FindServlet</servlet-class>

  10. </servlet>

  11. <servlet-mapping>

  12. <servlet-name>FindServlet</servlet-name>

  13. <url-pattern>/FindServlet</url-pattern>

  14. </servlet-mapping>

  15. </web-app>

FindSerlvet.java

  1. package servlet;

  3. import java.io.IOException;

  4. import java.sql.Connection;

  5. import java.sql.DriverManager;

  6. import java.sql.PreparedStatement;

  7. import java.sql.ResultSet;

  8. import java.sql.SQLException;

  9. import java.util.ArrayList;

  10. import java.util.List;

  12. import javax.servlet.ServletException;

  13. import javax.servlet.annotation.WebServlet;

  14. import javax.servlet.http.HttpServlet;

  15. import javax.servlet.http.HttpServletRequest;

  16. import javax.servlet.http.HttpServletResponse;

  18. import model.User;

  20. public class FindServlet extends HttpServlet {

  21. private static final long serialVersionUID = 1L;

  23. public FindServlet() {

  24. super();

  25. }

  28. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

  29. Connection conn = null;

  30. PreparedStatement ps = null;

  31. ResultSet resultSet = null;

  32. String sql;

  33. // MySQL的JDBC URL编写方式：jdbc:mysql://主机名称：连接端口/数据库的名称?参数=值

  34. // 避免中文乱码要指定useUnicode和characterEncoding

  35. // 执行数据库操作之前要在数据库管理系统上创建一个数据库，名字自己定，

  36. // 下面语句之前就要先创建javademo数据库

  37. String url = "jdbc:mysql://localhost:3306/s61?"

  38. + "user=root&password=&useUnicode=true&characterEncoding=UTF8";

  39. try {

  40. // 之所以要使用下面这条语句，是因为要使用MySQL的驱动，所以我们要把它驱动起来，

  41. // 可以通过Class.forName把它加载进去，也可以通过初始化来驱动起来，下面三种形式都可以

  42. Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动

  44. System.out.println("成功加载MySQL驱动程序");

  45. // 一个Connection代表一个数据库连接

  46. conn = DriverManager.getConnection(url);

  47. // Statement里面带有很多方法，比如executeUpdate可以实现插入，更新和删除等

  48. sql = "select a.F01 as id,a.F02 as user,b.F02 as name,a.F04 as tel from s61.t6110 a,s61.t6141 b where a.F01=b.F01 ";

  49. ps = conn.prepareStatement(sql);

  50. resultSet = ps.executeQuery();

  51. Integer id = null;

  52. String account = null;

  53. String name = null;

  54. String tel = null;

  56. List<User> list = new ArrayList<User>();

  58. while (resultSet.next()){

  59. User myuser = new User();

  61. id = resultSet.getInt(1);

  62. myuser.setId(id);

  64. account = resultSet.getString(2);

  65. myuser.setAccount(account);

  67. name = resultSet.getString(3);

  68. myuser.setUsername(name);

  70. tel = resultSet.getString(4);

  71. myuser.setTel(tel);

  73. list.add(myuser);

  74. }

  76. request.setAttribute("list", list);

  78. } catch (SQLException e) {

  79. System.out.println("MySQL操作错误");

  80. e.printStackTrace();

  81. } catch (Exception e) {

  82. e.printStackTrace();

  83. } finally {

  84. try {

  85. resultSet.close();

  86. ps.close();

  87. conn.close();

  88. } catch (SQLException e) {

  89. e.printStackTrace();

  90. }

  91. }

  93. request.getRequestDispatcher("tables.jsp")

  94. .forward(request, response);

  95. }

  98. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

  99. doGet(request, response);

  100. }

  102. }

User.java

  1. package model;

  3. public class User {

  4. private Integer id;

  5. private String account;

  6. private String username;

  7. private String tel;

  9. public void setId(Integer id){

  10. this.id = id;

  11. }

  13. public Integer getId(){

  14. return id;

  15. }

  17. public void setAccount(String account){

  18. this.account = account;

  19. }

  21. public String getAccount(){

  22. return account;

  23. }

  25. public void setUsername(String username){

  26. this.username = username;

  27. }

  29. public String getUsername(){

  30. return username;

  31. }

  33. public void setTel(String tel){

  34. this.tel = tel;

  35. }

  37. public String getTel(){

  38. return tel;

  39. }

  40. }

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/tangbinghaochi/p/6293150.html

java 数据库 javascript
上一篇: Tomcat发布项目之后访问不到？
下一篇: oracle like多条件查询

继续阅读