Today i had already done last year exam on computer .
============================
here is the DBoperator
============================
import java.sql.*;
import java.io.FileReader;
import java.io.File;
import java.io.BufferedReader;
import java.io.*;
/**
*
Title:
*
*
Description:
*
*
Copyright: Copyright (c) 2007
*
*
Company:
*
* @author not attributable
* @version 1.0
*/
public class DataOperator {
StuFrm frm;
public DataOperator(StuFrm frm) {
this.frm = frm;
selectall();
}
public void selectall() {
String Resource = "sun.jdbc.odbc.JdbcOdbcDriver";
boolean flag = false;
try {
Class.forName(Resource);
} catch (ClassNotFoundException ex1) {
}
Connection con = null;
try {
con = DriverManager.getConnection("jdbc:odbc:my");
} catch (SQLException ex2) {
}
String sql = "select * from stu";
Statement stmt = null;
try {
stmt = con.createStatement();
} catch (SQLException ex3) {
}
ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
while (rs.next()) {
frm.txtDisplay.append("学号: " + rs.getInt("StuId")+" ");
frm.txtDisplay.append("姓名: " + rs.getString("stuname")+" ");
frm.txtDisplay.append("性别: " + rs.getString("stusex")+" ");
frm.txtDisplay.append("年龄" + rs.getInt("stuage")+" ");
frm.txtDisplay.append(" ");
}
} catch (SQLException ex4) {
}
}
}
==============================
here is the Frame,but not same as yesterday's
==============================
import java.awt.BorderLayout;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.*;
import javax.swing.JOptionPane;
/**
*
Title:
*
*
Description:
*
*
Copyright: Copyright (c) 2007
*
*
Company:
*
* @author not attributable
* @version 1.0
*/
public class StuFrm extends JFrame {
public StuFrm() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
getContentPane().setLayout(null);
jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel1.setText("学生信息");
jLabel1.setBounds(new Rectangle(68, 49, 95, 30));
jButton1.setBounds(new Rectangle(119, 346, 99, 25));
jButton1.setText("保存为文本");
jButton1.addActionListener(new StuFrm_jButton1_actionAdapter(this));
jButton2.setBounds(new Rectangle(304, 346, 99, 25));
jButton2.setText("查询数据库");
jButton2.addActionListener(new StuFrm_jButton2_actionAdapter(this));
jScrollPane2.setBounds(new Rectangle(185, 19, 230, 59));
this.getContentPane().add(jLabel1);
this.getContentPane().add(jScrollPane1);
this.getContentPane().add(jButton1);
this.getContentPane().add(jButton2);
this.getContentPane().add(jScrollPane2);
jScrollPane2.getViewport().add(txtnew);
jScrollPane1.getViewport().add(txtDisplay);
jScrollPane1.setBounds(new Rectangle(89, 105, 314, 210));
this.setTitle("查询学生信息");
this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
this.setSize(700, 600);
this.setResizable(false);
this.setVisible(true);
}
public static void main(String[] args) {
new StuFrm();
}
JLabel jLabel1 = new JLabel();
JScrollPane jScrollPane1 = new JScrollPane();
JTextArea txtDisplay = new JTextArea();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JScrollPane jScrollPane2 = new JScrollPane();
JTextArea txtnew = new JTextArea();
public void jButton2_actionPerformed(ActionEvent e) {
DataOperator d=new DataOperator(this);
}
public void jButton1_actionPerformed(ActionEvent e) {
FileWriter fr = null;
try {
fr = new FileWriter("save.txt");
} catch (IOException ex3) {
}
BufferedWriter br = new BufferedWriter(fr);
try {
br.write(txtDisplay.getText());
FileReader fd=new FileReader("save.txt");
BufferedReader bf=new BufferedReader(fd);
System.out.println("bf.read()=" + bf.readLine());
} catch (IOException ex2) {
}
try {
br.close();
} catch (IOException ex1) {
}
try {
fr.close();
} catch (IOException ex) {
}
JOptionPane.showMessageDialog(this, "保存在项目目录下");
this.dispose();
}}
class StuFrm_jButton1_actionAdapter implements ActionListener {
private StuFrm adaptee;
StuFrm_jButton1_actionAdapter(StuFrm adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class StuFrm_jButton2_actionAdapter implements ActionListener {
private StuFrm adaptee;
StuFrm_jButton2_actionAdapter(StuFrm adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10395457/viewspace-927006/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10395457/viewspace-927006/