import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import javax.swing.JComponent;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.HeadlessException;
import java.awt.Rectangle;
import java.awt.Dimension;
import java.awt.Font;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JTextField;
import javax.swing.JButton;
public class MyJdbc extends JFrame {
private static final long serialVersionUID = 1L;
private JPanel jContentPane = null;
private JLabel jLabel = null;
private JLabel jLabel1 = null;
private JTextField jTextField = null;
private JTextField jTextField1 = null;
private JButton jButton = null;
private JButton jButton1 = null;
public static int i=0;
public static MyJdbc single=null;
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
jTextField = new JTextField();
jTextField.setBounds(new Rectangle(199, 21, 151, 54));
jTextField.setHorizontalAlignment(JTextField.CENTER);
jTextField.setText("");
jTextField.setFont(new Font("Dialog", Font.PLAIN, 18));
}
return jTextField;
}
/**
* This method initializes jTextField1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField1() {
if (jTextField1 == null) {
jTextField1 = new JTextField();
jTextField1.setBounds(new Rectangle(199, 90, 151, 54));
jTextField1.setHorizontalAlignment(JTextField.CENTER);
jTextField1.setFont(new Font("Dialog", Font.PLAIN, 18));
}
return jTextField1;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setBounds(new Rectangle(37, 162, 97, 48));
jButton.setFont(new Font("Dialog", Font.BOLD, 24));
jButton.setText("确定");
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
// String uid=jTextField.getText();
// String upass=jTextField1.getText();
// try {
// Class.forName("oracle.jdbc.driver.OracleDriver");
// Connection conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");
//
// //sql
// String sql="select * from login where sname='" + uid + "'and pass='" + upass+ "'";
//// result
// PreparedStatement psmt= conn.prepareStatement(sql);
// ResultSet res = psmt.executeQuery();
// if(res.next())
// {
// System.out.println(res.getString(1));
// System.out.println(res.getString(2));
// res.getString(1);
// System.out.println("login ok");
// JOptionPane.showMessageDialog(null, "登陆成功");
//
// // TestDia t= new TestDia(null);
// //t.setVisible(true);
// }else
// {
// System.out.println("login error");
// JOptionPane.showMessageDialog(null, "登陆失败");
//
// }
// } catch (ClassNotFoundException e1) {
// // TODO 帺?惗惉 catch ?
// e1.printStackTrace();
// }
//
// catch (SQLException e1) {
// // TODO 帺?惗惉 catch ?
// e1.printStackTrace();
// }
//
//
String uid=jTextField.getText();
String upass=jTextField1.getText();
// String flag="0";
// flag=testdb.connect(uid,upass);
//
// if(flag.equals("1"))
//
// {
// //System.out.println("login ok");
// //JOptionPane.showMessageDialog(null, "登陆成功");
//
//
// search t=new search();
//
// t.setVisible(true);
//
// single.setVisible(false);
DBConnected.connect();
String sql="select * from login where sname='" + uid + "' and pass='" + upass+ "'";
ResultSet res=DBConnected.getMsg(sql);
try {
if(res.next())
{
//JOptionPane.showMessageDialog(null, "登陆成功");
search t=new search();
t.setVisible(true);
single.setVisible(false);
}
else
{System.out.println("login 4");
JOptionPane.showMessageDialog(null, "登陆失败");}
} catch (HeadlessException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//
// //System.out.println("actionPerformed()");
// String name=jTextField.getText();
// String pass=jTextField1.getText();
// String url="jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid";
// try {
// Class.forName("oracle.jdbc.driver.OracleDriver");
// } catch (ClassNotFoundException e1) {
// // TODO Auto-generated catch block
// e1.printStackTrace();
// }
// try {
// Connection conn=DriverManager.getConnection(url);
// String sql="select * from login where sname='"+name+"' and "+"pass='"+pass+"'";
// PreparedStatement psmt= conn.prepareStatement(sql);
// ResultSet res = psmt.executeQuery();
// if(res.next())
// {
// System.out.println(res.getString(1));
// System.out.println(res.getString(2));
// res.getString(1);
//// System.out.println("login ok");
// //TestDia t= new TestDia(null);
// //t.setVisible(true);
// System.out.println("login ok");
// JOptionPane.showMessageDialog(null, "登陆成功");
// }else
// {
// System.out.println("login error");
// JOptionPane.showMessageDialog(null, "登陆失败");
// }
// } catch (SQLException e1) {
// // TODO Auto-generated catch block
// e1.printStackTrace();
// }
//
}});
}
return jButton;
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setBounds(new Rectangle(236, 163, 93, 49));
jButton1.setFont(new Font("Dialog", Font.BOLD, 24));
jButton1.setText("重置");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()");
jTextField.setText("");
jTextField1.setText("");
}
});
}
return jButton1;
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
SwingUtilities.invokeLater(new Runnable() {
public void run() {
MyJdbc thisClass = new MyJdbc();
single=thisClass;
thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
thisClass.setVisible(true);
}
});
}
/**
* This is the default constructor
*/
public MyJdbc() {
super();
initialize();
}
/**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setSize(405, 261);
this.setContentPane(getJContentPane());
this.setTitle("JFrame");
}
/**
* This method initializes jContentPane
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane() {
if (jContentPane == null) {
jLabel1 = new JLabel();
jLabel1.setBounds(new Rectangle(36, 87, 103, 55));
jLabel1.setFont(new Font("Dialog", Font.BOLD, 18));
jLabel1.setText("密码");
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(36, 23, 103, 50));
jLabel.setFont(new Font("Dialog", Font.BOLD, 18));
jLabel.setText("用户名");
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.add(jLabel, null);
jContentPane.add(jLabel1, null);
jContentPane.add(getJTextField(), null);
jContentPane.add(getJTextField1(), null);
jContentPane.add(getJButton(), null);
jContentPane.add(getJButton1(), null);
}
return jContentPane;
}
} // @jve:decl-index=0:visual-constraint="125,18"