【菜鸟之旅】jsp + tomcat + java 实现简单的从…

2018-06-24 00:01:59来源：未知阅读 ()

通过网上查找资料和求助大神帮助，终于完成了简单的数据有后台传递到前台的操作。

左图，是网页显示结果，右图是数据库中的数据。

工程目录结构

数据库实体类主要包含了数据库中对应的表的字段（Table.java）。

 1 package demo4.entity;
 2 
 3 public class Table {
 4 
 5     private String id;
 6     private String name;
 7     private int age;
 8     private String sex;
 9     
10     public Table(){}
11     
12     public Table(String id, String name, int age, String sex){
13         this.id = id;
14         this.name = name;
15         this.age = age;
16         this.sex = sex;
17     }
18 
19     public String getId() {
20         return id;
21     }
22 
23     public void setId(String id) {
24         this.id = id;
25     }
26 
27     public String getName() {
28         return name;
29     }
30 
31     public void setName(String name) {
32         this.name = name;
33     }
34 
35     public int getAge() {
36         return age;
37     }
38 
39     public void setAge(int age) {
40         this.age = age;
41     }
42 
43     public String getSex() {
44         return sex;
45     }
46 
47     public void setSex(String sex) {
48         this.sex = sex;
49     }
50     
51     
52 }

数据库操作类： (TableDao.java)

package demo4.dao;

import java.sql.*;
import java.util.*;

import demo4.entity.*;

public class TableDao {
    
    public List readTable(){
        List<Table> list = new ArrayList<Table>();
        Connection conn = null;
        PreparedStatement stat = null;
        ResultSet rs = null;
        try{
            Class.forName("com.mysql.jdbc.Driver");
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }
        
        try {
            conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo01","root","root");
            String sql = "select * from user_info";
            stat = conn.prepareStatement(sql);
            rs=stat.executeQuery();
            while(rs.next()){
                
                String id = rs.getString("id");
                String name =  rs.getString("name");
                int age = rs.getInt("age");
                String sex = rs.getString("sex");
                
                Table t1 = new Table(id, name, age, sex);
                list.add(t1);
                
            }
            
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                if(rs!=null){
                    rs.close();
                }
                if(stat!=null){
                    stat.close();
                }
                if(conn!=null){
                    conn.close();
                }
                
            } catch (SQLException e2) {
                e2.printStackTrace();
            }
        }
        
        return list;
    }

}

页面（index.jsp）:

<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
  <%@page import="demo4.dao.TableDao,demo4.entity.Table"%>
  <%
  String path = request.getContextPath();
  String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Show Table</title>
</head>
<style>
.bbody{
 margin-left:300px;
 margin-top:100px
}
.bbody > table {
 height:200px;
 width:400px;
}
td{
 text-align:center;
}

</style>
<body>
<div class="bbody">
    <table border="1">
        <tr >
            <td>Id</td>
            <td>Name</td>
            <td>Age</td>
            <td>Sex</td>
        </tr>
         <%
            TableDao dao=new TableDao();
            List<Table> list =dao.readTable();  
            for(Table tl:list)
            {%>
          <tr>
              <td><%=tl.getId() %></td>
              <td><%=tl.getName() %></td>
              <td><%=tl.getAge() %></td>
              <td><%=tl.getSex() %></td>
           </tr>
             <%}
                   %>
    </table>
    </div>
</body>
</html>