创建数据库，连接数据库，绘制界面，读取数据库信息 数据库表： ~~~ CREATE TABLE `xuesheng` ( `xuehao` varchar(20) NOT NULL, `xingming` varchar(10) DEFAULT NULL, `xingbie` varchar(2) DEFAULT NULL, `nianling` int(8) DEFAULT NULL, `jiguan` varchar(10) DEFAULT NULL, `yxmc` varchar(10) DEFAULT NULL, PRIMARY KEY (`xuehao`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ~~~  Test.java ~~~ package studysystem; import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; public class Test extends JFrame { JPanel mb1,mb2; JLabel bq1;//标签 JTextField wbk1;//文本框 JButton an1,an2,an3,an4;//按钮 JTable bg1; //表格 JScrollPane gd1;//滚动条 Vector ziduan,jilu;//字段和记录两个集合类 PreparedStatement ps=null; Connection ct=null; //声明Connection对象 ResultSet rs=null; public static void main(String[] args) { Test xs=new Test(); } public Test() { mb1=new JPanel(); bq1=new JLabel("请输入姓名"); wbk1=new JTextField(10); an1=new JButton("查询"); mb1.add(bq1); mb1.add(wbk1); mb1.add(an1); mb2=new JPanel(); an2=new JButton("添加"); an3=new JButton("修改"); an4=new JButton("删除"); mb2.add(an2); mb2.add(an3); mb2.add(an4); ziduan =new Vector(); ziduan.add("学号"); ziduan.add("姓名"); ziduan.add("性别"); ziduan.add("年龄"); ziduan.add("籍贯"); ziduan.add("所在院系"); jilu =new Vector(); try { //加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); ct=DriverManager.getConnection("jdbc:mysql://122.14.200.136:3306/javadb","root","6a133f0024"); ps=ct.prepareStatement("select * from xuesheng"); rs=ps.executeQuery(); while(rs.next()){ Vector hang=new Vector(); hang.add(rs.getString(1)); hang.add(rs.getString(2)); hang.add(rs.getString(3)); hang.add(rs.getInt(4)); hang.add(rs.getString(5)); hang.add(rs.getString(6)); jilu.add(hang); } } catch (Exception e) { }finally{//关闭资源 try { if(rs!=null) { rs.close(); } if(ps!=null) { ps.close(); } if(ct!=null) { ct.close(); } } catch (Exception e2){} } //JTable 后面的括号先记录后字段 bg1=new JTable(jilu,ziduan); gd1=new JScrollPane(bg1); this.add(gd1); this.add(mb1,"North"); this.add(mb2,"South"); this.setTitle("学生管理系统"); this.setSize(500,400); this.setLocation(201,181); this.setResizable(false); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setVisible(true); } } ~~~