登錄界面連接數(shù)據(jù)庫

1、import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.*;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JPasswordField;import javax.swing.JTextField;public class Lo

2、gin extends JFrame implements ActionListener JLabel l1 = new JLabel(" 用戶名 ：");JLabel l2 = new JLabel(" 密 碼 :");JLabel l3 = new JLabel(" 歡迎您登錄 .");JTextField t1 = new JTextField("", 10);JPasswordField t2 = new JPasswordField("", 10);JButton b1 = new J

3、Button(" 登 錄 ");JButton b2 = new JButton(" 取 消 ");JPanel p1 = new JPanel();JPanel p2 = new JPanel();JPanel p3 = new JPanel();JPanel p4 = new JPanel();String pass;Connection con;Statement stmt;ResultSet rs;String url = "jdbc:odbc:login"Login()throws Exception super(”登錄模塊

4、”)； this.add(p1);this.add(p2)；this.add(p3)；this.add(p4)； p1.add(l3)；p2.add(l1); p2.add(t1);p3.add(l2); p3.add(t2);t2.setEchoChar('*');p4.add(b1); p4.add(b2);b1.addActionListener(this);b2.addActionListener(this);setLayout(new GridLayout(4,1);this.add(p1);this.add(p2);this.add(p3);this.add(p4)

5、;setBounds(400, 250, 400, 300); setResizable(false);setVisible(true);public static void main(String args) throws Exception new Login();public void actionPerformed(ActionEvent e) if(e.getSource() = b1) if(t1.getText().trim().equals("")| t2.getPassword().toString().trim().equals(""

6、) l3.setText(" 用戶名和密碼不能為空 ");elsetryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection(url, "sa", "");stmt = con.createStatement();rs = stmt.executeQuery("SELECT*FROM login where name="+ "'" +t1.getText()+ &

7、quot;'");while(rs.next() / login 是要查詢表 表中字段名分別有：用戶名 (name), 密碼 (password) pass = rs.getString(2);/System.out.println(pass);if(t2.getPassword().toString().trim().equals(pass)l3.setText(" 登錄成功！ ");t1.setText("");t2.setText("");elsel3.setText(" 用戶名和密碼錯誤！ &quo

8、t;);catch(Exception e2) public void actionPerformed(ActionEvent e) if(e.getSource() = b1)if(t1.getText().equals("")| String.valueOf(t2.getPassword().equals("")l3.setText(" 用戶名和密碼不能為空 ");elsetryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection(url, "sa", "");stmt = con.createStatement();rs = stmt.executeQuery("SELECT*FROM login where name="+ "'" +t1.getText()+ "'"); while(rs.next()pass = rs.getString(2).trim();if(String.valueOf(t2.getPassword().equals(pass)