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>
  14. 		
  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">
  35. 							
  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>
  67. 				
  68. 				<div class="row-fluid">
  69. 					<div id="footer" class="span12">
  70. 						2012 &copy; UniAdmin.</div>
  71. 				</div>
  72. 			</div>
  73. 		</div>
  74. 		
  75. 		
  76.             
  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;
  22.    
  23.     public FindServlet() {
  24.         super();
  25.     }
  27. 	
  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驱动
  43. 		   
  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;
  55. 	        
  56. 	        List<User> list = new ArrayList<User>();
  57. 	        
  58. 	        while (resultSet.next()){
  59. 	        	User myuser = new User();
  60. 	        	
  61. 	            id = resultSet.getInt(1);
  62. 	            myuser.setId(id);
  63. 	            
  64. 	            account = resultSet.getString(2);
  65. 	            myuser.setAccount(account);
  66. 	            
  67. 				name = resultSet.getString(3);
  68. 				myuser.setUsername(name);
  69. 				
  70. 				tel = resultSet.getString(4);	
  71. 				myuser.setTel(tel);
  72. 				
  73. 				list.add(myuser);
  74. 	        }
  75. 	        
  76. 	        request.setAttribute("list", list);
  77. 		        
  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. 		}
  92. 		
  93. 		request.getRequestDispatcher("tables.jsp")  
  94.         .forward(request, response); 
  95. 	}
  97. 	
  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;
  8. 	
  9. 	public void setId(Integer id){
  10. 		this.id = id;
  11. 	}
  12. 	
  13. 	public Integer getId(){
  14. 		return id;
  15. 	}
  16. 	
  17. 	public void setAccount(String account){
  18. 		this.account = account;
  19. 	}
  20. 	
  21. 	public String getAccount(){
  22. 		return account;
  23. 	}
  24. 	
  25. 	public void setUsername(String username){
  26. 		this.username = username;
  27. 	}
  28. 	
  29. 	public String getUsername(){
  30. 		return username;
  31. 	}
  32. 	
  33. 	public void setTel(String tel){
  34. 		this.tel = tel;
  35. 	}
  36. 	
  37. 	public String getTel(){
  38. 		return tel;
  39. 	}
  40. }





posted @ 2017-01-17 15:02  糖饼好吃  阅读(933)  评论(0)    收藏  举报