package mywork;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dx.sql.dataset.*;
import com.borland.javax.sql.*;
import com.borland.dx.dataset.*;
import java.sql.*;
import com.borland.dbswing.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2007</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/
public class Frame1 extends JFrame {
JPanel contentPane;
JMenuBar jMenuBar1 = new JMenuBar();
JMenu jMenuFile = new JMenu();
JMenuItem jMenuFileExit = new JMenuItem();
JMenu jMenuHelp = new JMenu();
JMenuItem jMenuHelpAbout = new JMenuItem();
XYLayout xYLayout1 = new XYLayout();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JTextField jTextField1 = new JTextField();
JPasswordField jPasswordField1 = new JPasswordField();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
//Construct the frame
public Frame1() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK);
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel) this.getContentPane();
contentPane.setLayout(xYLayout1);
this.setSize(new Dimension(423, 315));
this.setTitle("Frame Title");
jMenuFile.setText("File");
jMenuFileExit.setText("Exit");
jMenuFileExit.addActionListener(new Frame1_jMenuFileExit_ActionAdapter(this));
jMenuHelp.setText("Help");
jMenuHelpAbout.setText("About");
jMenuHelpAbout.addActionListener(new Frame1_jMenuHelpAbout_ActionAdapter(this));
jButton1.setVerifyInputWhenFocusTarget(true);
jButton1.setText("Enter");
jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
jButton2.setText("Exit");
jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
jTextField1.addActionListener(new Frame1_jTextField1_actionAdapter(this));
jPasswordField1.setSelectionStart(1);
jPasswordField1.setText("");
jPasswordField1.addActionListener(new Frame1_jPasswordField1_actionAdapter(this));
jLabel1.setText("password:");
jLabel2.setText("USER ID:");
jLabel3.setFont(new java.awt.Font("Dialog", 1, 20));
jLabel3.setForeground(Color.red);
jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
jLabel3.setHorizontalTextPosition(SwingConstants.TRAILING);
jLabel3.setText("用户登录");
jMenuFile.add(jMenuFileExit);
jMenuHelp.add(jMenuHelpAbout);
jMenuBar1.add(jMenuFile);
jMenuBar1.add(jMenuHelp);
contentPane.add(jTextField1, new XYConstraints(108, 97, 185, 30));
contentPane.add(jLabel1, new XYConstraints(28, 152, 66, 28));
contentPane.add(jLabel2, new XYConstraints(28, 99, 64, 27));
contentPane.add(jLabel3, new XYConstraints(105, 20, 195, 39));
contentPane.add(jButton1, new XYConstraints(91, 213, 87, 40));
contentPane.add(jButton2, new XYConstraints(194, 213, 88, 40));
contentPane.add(jPasswordField1, new XYConstraints(110, 152, 184, 28));
this.setJMenuBar(jMenuBar1);
}
//File | Exit action performed
public void jMenuFileExit_actionPerformed(ActionEvent e) {
System.exit(0);
}
//Help | About action performed
public void jMenuHelpAbout_actionPerformed(ActionEvent e) {
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e);
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
jMenuFileExit_actionPerformed(null);
}
}
void jButton1_actionPerformed(ActionEvent e) {
String id = jTextField1.getText();
String pwd = jPasswordField1.getText();
if (id.equals("") || pwd.equals("")) {
return;
}
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动
Connection con = DriverManager.getConnection("jdbc:odbc:myodbc"); //建立程序与数据库的联系
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql = "select * from logininfo where username=" + id + " and password=" + pwd +
"";
System.out.println(sql);
ResultSet rs = stmt.executeQuery(sql); //建立ResultSet(结果集)对象，并执行SQL覾uFFFD\uFFFD
if (!rs.next()) {
System.out.println("not found");
rs.close();
stmt.close();
con.close();
return;
}
System.out.println("ok");
rs.close();
sql = "insert into loginlog (username, logintime,bumen,xingbie) values ("+ id + ", '" + (new java.util.Date().toString()) +"','bumen' ,'男')";
stmt.executeUpdate(sql);
stmt.close();
con.close();
this.hide();
Dialog1 d = new Dialog1(this, "", true);
d.frame1 = this;
d.id = id;
d.pwd = pwd;
d.queryDataSet1.closeStatement();
d.queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
d.database1,
"SELECT * from loginlog where username=" + id, null, true, Load.ALL));
d.queryDataSet1.open();
d.show();
this.show();
} catch (Exception ex) {
ex.printStackTrace();
}
}
void jButton2_actionPerformed(ActionEvent e) {
System.exit(0);
}
void jPasswordField1_actionPerformed(ActionEvent e) {
}
void jTextField1_actionPerformed(ActionEvent e) {
}
}
class Frame1_jMenuFileExit_ActionAdapter implements ActionListener {
Frame1 adaptee;
Frame1_jMenuFileExit_ActionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuFileExit_actionPerformed(e);
}
}
class Frame1_jMenuHelpAbout_ActionAdapter implements ActionListener {
Frame1 adaptee;
Frame1_jMenuHelpAbout_ActionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuHelpAbout_actionPerformed(e);
}
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame1_jPasswordField1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jPasswordField1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jPasswordField1_actionPerformed(e);
}
}
class Frame1_jTextField1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jTextField1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jTextField1_actionPerformed(e);
}
}
