本文共 5382 字，大约阅读时间需要 17 分钟。

MySQL数据库表信息

#创建数据库create DATABASE STUDENT;#使用student数据库use student;#建表create table stu_info(id int(10) not null PRIMARY key auto_increment,name VARCHAR(20) not null,fromSchool varchar(50) not null,region VARCHAR(50) not null);#插入数据insert into stu_info VALUES(1,'ganxiang','第一中学','贵州');

Java代码

实体类代码

package ShowDbData;import java.sql.ParameterMetaData;/** * @program: Training * @description: stu_info实体类 * @create: 2021-01-06 09:35 **/public class Stu_info {
       private Integer id;    private String name;    private String fromSchool;    private String region;    public Integer getId() {
           return id;    }    public void setId(Integer id) {
           this.id = id;    }    @Override    public String toString() {
           return "Stu_info{" +                "id=" + id +                ", name='" + name + '\'' +                ", fromSchool='" + fromSchool + '\'' +                ", region='" + region + '\'' +                '}';    }    public String getName() {
           return name;    }    public void setName(String name) {
           this.name = name;    }    public String getFromSchool() {
           return fromSchool;    }    public void setFromSchool(String fromSchool) {
           this.fromSchool = fromSchool;    }    public String getRegion() {
           return region;    }    public void setRegion(String region) {
           this.region = region;    }}

主要代码

package ShowDbData;/** * @program: Training * @description: 直接展示从数据库中获取的数据 ----on esgyn * @create: 2021-01-06 15:06 **/import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.*;import java.util.LinkedList;import java.util.List;public class ShowData {
       //获取数据库中的数据并以list返回    private static List
   
     getDbData() throws ClassNotFoundException, SQLException {
           //1,注册驱动信息        Class.forName("com.mysql.cj.jdbc.Driver");        //2,获取连接对象        String url ="jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8";        Connection conn= DriverManager.getConnection(url,"root","123456");        String sql="select id,name,fromSchool,region from stu_info";        //3,连接对象conn的方法prepareStatement获取SQL语句的预编译对象        PreparedStatement parameter =conn.prepareStatement(sql);        //4,执行sql        ResultSet result =parameter.executeQuery();        //返回的数据List        LinkedList
    
      list =new LinkedList<>();        while (result.next()){
               Stu_info stu_info =new Stu_info();            stu_info.setId(result.getInt("id"));            stu_info.setName(result.getString("name"));            stu_info.setFromSchool(result.getString("fromSchool"));            stu_info.setRegion(result.getString("region"));            list.add(stu_info);            System.out.println("id:"+result.getObject("id")+" "+"name:"+result.getObject("name")+" "                    +"fromSchool:"+result.getString("fromSchool")+" "+"region:"+result.getString("region"));        }        result.close();        parameter.close();        conn.close();        return list;    }    //创建窗口，以列表展示从数据库中获取的数据    private static void showFrame(List
     
       list){
           //1，设定窗口        JFrame frame =new JFrame("从mysql中获取数据并展示~");        frame.setLocation(700,400);        frame.setSize(500, 300);        frame.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);        //2,添加table        JTable table =null;        String [] index={
   "id","name","fromSchool","region"};        Object [][] data=new Object[list.size()][index.length];        //3,向data中添加数据        for (int i = 0; i < list.size(); i++) {
               Stu_info stu_info =list.get(i);            data[i][0]=stu_info.getId();            data[i][1]=stu_info.getName();            data[i][2]=stu_info.getFromSchool();            data[i][3]=stu_info.getRegion();        }        //4,创建一个默认的表格模型        DefaultTableModel defaultModel = new DefaultTableModel(data, index);        table=new JTable(defaultModel);        table.setBackground(Color.cyan);        table.setPreferredScrollableViewportSize(new Dimension(100, 80));//JTable的高度和宽度按照设定        table.setFillsViewportHeight(true);        //5，给表格设置滚动条        JScrollPane jScrollPane = new JScrollPane();        jScrollPane.setViewportView(table);        Font font = new Font("宋体", Font.BOLD, 13);        //添加button        JButton button =new JButton("查询");        button.setBounds(50,10,50,30);        //添加label        JLabel label =new JLabel("点击按钮，查询MySQL数据库中的数据：");        label.setFont(font);        label.setBounds(1,10,240,30);        //通过panel组合button，label        JPanel panel =new JPanel();        panel.setBackground(Color.GRAY);        panel.setSize(200,100);        panel.add(label);        panel.add(button);        //6，添加表格、滚动条到容器中        frame.add(panel, BorderLayout.NORTH);        frame.setVisible(true);        button.addActionListener(new ActionListener() {
               @Override            public void actionPerformed(ActionEvent e) {
                   frame.add(jScrollPane,BorderLayout.CENTER);                frame.setVisible(true);            }        });    }    public static void main(String[] args) throws SQLException, ClassNotFoundException {
   //        getDbData();        showFrame(getDbData());    }}
     
    
   

展示结果

转载地址：http://drqzi.baihongyu.com/