《登录界面连接数据库.doc》由会员分享,可在线阅读,更多相关《登录界面连接数据库.doc(3页珍藏版)》请在三一文库上搜索。
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.g
9、etConnection(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)l3.setText(" 登录成功! ");t1.setText("");t2.setText("");elsel3.setText(" 用户名和密码错误! ");catch(Exception e2)