display.java

电子日历

package re;

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

public class Display extends JFrame implements ActionListener {

 JLabel jlabel = new JLabel("显示数据库中的数据");
 JTable jtable = new JTable();
 JScrollPane jscrollpane = new JScrollPane(jtable);//将表格加个滚动条
 JButton display = new JButton("显示数据列表");
 
  Display(){
  super("备忘录");
  this.setLayout(new BorderLayout());
  this.add(jlabel,BorderLayout.NORTH);
  this.add(jscrollpane,BorderLayout.CENTER);
  this.add(display,BorderLayout.SOUTH);
  display.addActionListener(this);
  this.setSize(250,200); //设置JFrame窗口大小
  this.setVisible(true);//设置窗口显示true
  
 }
 
 public void actionPerformed(ActionEvent e) {
  if(e.getSource()==display){
   String[] col = { "密钥", "日期", "事件" };
   DefaultTableModel mm= new DefaultTableModel(col,0); //定义一个表的模板
   
   try {
    Class.forName("org.apache.derby.jdbc.ClientDriver"); //加载access数据库驱动
   } catch (ClassNotFoundException e1) {
    e1.printStackTrace();
   }
   try{
   Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/Calender"); //建立连接这里Calender为数据库名
   Statement stmt = conn.createStatement();
   ResultSet rs=stmt.executeQuery("select * from \"Calender\"");//将查询得到的结果集给rs
   while(rs.next()){
      String key = rs.getString("key");
      String date = rs.getString("date");
      String event = rs.getString("event");
      String[] str_row={key,date,event}; //将一行的数据存在str_row 字符串数组里
      mm.addRow(str_row);//添加在表模板中
   }
   jtable.setModel(mm);//将jtable这个表 设置为刚刚定义的模板
   this.add(jscrollpane); //将加载了表的滚动条在JFrame中显示
   }catch(SQLException e1){
   e1.getStackTrace();
   }
  }
 }
}