scanuser.java

这是我我完成的java的课程设计,是一个宾馆管理系统

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.Rectangle;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;

public class ScanUser implements ActionListener{
		  JFrame fm=new JFrame("浏览用户");
		  Statement ps;
		  ResultSet rs;
		  Connection con;
		  String url;
		  JScrollPane jScrollPane1 = new JScrollPane();
		  Object[][] rowData = new Object[2][3];
		  String[] columnNames = {
		      "用户名", "密码", "最后登录时间"};
		  JTable jTable1 = new JTable(rowData, columnNames);
		  JButton ok = new JButton();
		  JButton cancel = new JButton();
          int i=0;
		
		private void Init(){	
			fm.getContentPane().setLayout(null);
		    jScrollPane1.setBounds(new Rectangle(2, 10, 433, 185));
		    ok.setBounds(new Rectangle(100, 209, 90, 34));
		    ok.setFont(new java.awt.Font("Dialog", 0, 15));
		    ok.setText("查询");
		    ok.addActionListener(new ok_actionAdapter(this));
		    cancel.setBounds(new Rectangle(220, 209, 90, 34));
		    cancel.setFont(new java.awt.Font("Dialog", 0, 15));
		    cancel.setText("退出");
		    cancel.addActionListener(new cancel_actionAdapter(this));
		 
		    jScrollPane1.getViewport().add(jTable1, null);
		    fm.getContentPane().add(jScrollPane1, null);
		    fm.getContentPane().add(ok, null);
		    fm.getContentPane().add(cancel, null);
			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize(); 
			fm.setLocation( 
				(screen.width - fm.getWidth()) / 2, 
				(screen.height - fm.getHeight()) / 2);

		    fm.setBounds(400, 250, 450, 350);
			fm.setVisible(true);
			
}
		void ok_actionPerformed(ActionEvent e) {
			try {
			       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			      Connection con = DriverManager.getConnection(
			          "jdbc:odbc:Hotel");

			      ps = con.createStatement(ResultSet.
			                               TYPE_SCROLL_INSENSITIVE,
			                               ResultSet.CONCUR_READ_ONLY);

			      rs = ps.executeQuery("select * from Admin");
				while (rs.next()) {
				               rowData[i][0] = rs.getString("LoginName");
				               rowData[i][1] = rs.getString("LoginPassword");
				               rowData[i][2] = rs.getString("LeastLoginDate");
				               i = i + 1;
				               fm.repaint();
				             }
						}
			catch (Exception err){
				               String err1 = err.getMessage();
				               JOptionPane.showMessageDialog(null, err);
				             }
        }
		void cancel_actionPerformed(ActionEvent e) {
			fm.dispose();
			
		}
		public void actionPerformed(ActionEvent e){
			Init();
		}	
}
class ok_actionAdapter implements java.awt.event.ActionListener {
ScanUser adaptee;

ok_actionAdapter(ScanUser adaptee) {
this.adaptee = adaptee;
}

public void actionPerformed(ActionEvent e) {
adaptee.ok_actionPerformed(e);
}
}

class cancel_actionAdapter implements java.awt.event.ActionListener {
	ScanUser adaptee;

	cancel_actionAdapter(ScanUser adaptee) {
	this.adaptee = adaptee;
	}

	public void actionPerformed(ActionEvent e) {
	adaptee.cancel_actionPerformed(e);
	}
	}