JDBC实现从数据库中读取信息以表格的形式展示

package com.entity;

import java.sql.Date;

public class Title {
　　　　/**
　　　　　*下面这四个属性为数据库表中的四个属性
　　　　　*/
    private int id;   
    private String name;
    private String creator;
    private Date createTime;
    
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getCreator() {
        return creator;
    }
    public void setCreator(String creator) {
        this.creator = creator;
    }
    public Date getCreateTime() {
        return createTime;
    }
    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }
    public Title(int id, String name, String creator, Date createTime) {
        super();
        this.id = id;
        this.name = name;
        this.creator = creator;
        this.createTime = createTime;
    }
}

package com.dao;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import com.entity.Title;

public class TitleDaO {
    public List readTitle(){
        List<Title> list =new ArrayList<Title>();
        Connection con=null;
        PreparedStatement psmt=null;
        ResultSet rs=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/news","root","1234");
            String sql="select * from title";
            psmt=con.prepareStatement(sql);
            rs=psmt.executeQuery();
            
            while(rs.next())
            {
                int id=rs.getInt("id");
                String name=rs.getString("name");
                String creator=rs.getString("creator");
                Date createTime=rs.getDate("createTime");
                Title tl=new Title(id, name, creator, createTime);
                list.add(tl);
            }
            
        } catch (Exception e) {
            e.printStackTrace();
        }finally
        {
            try {
                if(rs!=null)
                {
                    rs.close();
                }
                if(psmt!=null)
                {
                    psmt.close();
                }
                if(con!=null)
                {
                    con.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        return list;
    }
    
}