Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package loginsystem;
- import javax.swing.*;
- import java.awt.event.*;
- import java.sql.*;
- public class LoginSystem {
- Connection con;
- Statement st;
- ResultSet rs;
- JFrame f = new JFrame("INLOGIN");
- JLabel l = new JLabel("Username");
- JLabel l1 = new JLabel("Password");
- JTextField t = new JTextField(10);
- JTextField t1 = new JTextField(10);
- JButton b = new JButton("Login");
- public LoginSystem()
- {
- connect();
- frame();
- }
- public void connect(){
- try{
- String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
- Class.forName(driver);
- String db = "jdbc:odbc:innlogin";
- con = DriverManager.getConnection(db);
- st = con.createStatement();
- }
- catch(Exception ex)
- {
- }
- }
- public void frame()
- {
- f.setSize(600, 400);
- f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- f.setVisible(true);
- JPanel p = new JPanel();
- p.add(l);
- p.add(t);
- p.add(l1);
- p.add(t1);
- p.add(b);
- f.add(p);
- b.addActionListener(new ActionListener(){
- @Override
- public void actionPerformed(ActionEvent e)
- {
- try
- {
- String user = t.getText().trim();
- String pass = t1.getText().trim();
- String sql = "select user,pass from Table1 where user = '"+user+"'and pass = '"+pass+"'";
- rs = st.executeQuery(sql);
- int count = 0;
- while(rs.next())
- {
- count = count + 1;
- }
- if(count == 1)
- {
- JOptionPane.showMessageDialog(null, "Bruker funnet!");
- }
- else if(count > 1)
- {
- JOptionPane.showMessageDialog(null, "duplikerte brukere får ikke tilgang!");
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Bruker ikke funnet!");
- }
- }
- catch(Exception ex){
- }
- }
- }
- }
- public static void main(String[] args) {
- new LoginSystem();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement