Skip to content

nikitaabuya/Front-desk-application

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 

Repository files navigation

Front-desk-application

import javax.swing.;
import java.awt.event.
;
public class PProject {
public static void main(String[] args) {
dbconnect connect = new dbconnect(); connect.getData(); JFrame myframe=new JFrame("log in");
final JLabel label = new JLabel(); label.setBounds(20,150, 200,50);

 final JPasswordField value = new JPasswordField();   
 value.setBounds(100,75,100,30);  
 
 JLabel name=new JLabel("username: ");    
    name.setBounds(20,20,80,30);
    
    JLabel pass=new JLabel("password: ");    
    pass.setBounds(20,75, 80,30);  
    
    JButton login = new JButton("log in");  
    login.setBounds(100,120, 80,30);
    
    final JTextField text = new JTextField();  
    text.setBounds(100,20, 100,30);    
            myframe.add(value); myframe.add(name); myframe.add(label); myframe.add(pass); myframe.add(login); myframe.add(text);  
            myframe.setSize(500,500);    
            myframe.setLayout(null);    
            myframe.setVisible(true);     
            login.addActionListener(new ActionListener() {  
            @Override
            public void actionPerformed(ActionEvent e) {       
               String data = "username: " + text.getText();  
               data += " password: "   
               + new String(value.getPassword());   
               label.setText(data);          
            }  
         });   

}
}

import java.sql.*;

public class dbconnect { private Connection con; private Statement st; private ResultSet rs;

public dbconnect (){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        
        con = DriverManager.getConnection("jbdc:mysql://localhost:3306/mypproject","root","");
        st = con.createStatement();
        
    }catch(Exception ex){
        System.out.println("Error: "+ex);
    }
}

public void getData(){
    try{
        
        String query = "select * from users";
        rs = st.executeQuery(query);
        System.out.println("Record from Dtabase");
        while(rs.next()){
            String Gender = rs.getString("Gender");
            String FName= rs.getString("FName");
            String LName =  rs.getString("LName");
            System.out.println("FName: "+FName+ "LName: "+LName+ "Gender: "+Gender);
        }
    
    }catch(Exception ex){
        System.out.println(ex);
    }
    
    
}

}

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published