Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package databaseretrievedata;
- import java.awt.event.ActionEvent;
- import java.awt.event.ActionListener;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.*;
- import javax.swing.*;
- public class Databaseretrievedata {
- Databaseretrievedata(){
- JFrame edit=new JFrame();
- edit.setBounds(300,200,550,120);
- edit.setUndecorated(false);
- edit.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- JPanel p=new JPanel();
- p.setBounds(0,0,600,400);
- edit.add(p);
- JTextField f=new JTextField(20);
- f.setBounds(100,200,120,20);
- p.add(f);
- JTextField f1=new JTextField(20);
- f1.setBounds(100,300,120,20);
- p.add(f1);
- JButton b=new JButton("Click Me");
- b.setBounds(0,100,100,20);
- p.add(b);
- JRootPane pane=b.getRootPane();
- pane.setDefaultButton(b);
- b.addActionListener(new ActionListener(){
- public void actionPerformed(ActionEvent e)
- {
- try {
- Connection conn=DriverManager.getConnection("jdbc:ucanaccess://C:\Users\MUHAMMAD SHAHAB\real estate.accdb");
- Statement st=conn.createStatement();
- String sql="select Username,Password from simba where Username='"+f+"'and Password='"+f1+"'";
- ResultSet rs=st.executeQuery(sql);
- if(rs.next())
- {
- JFrame editframe=new JFrame();
- editframe.setBounds(300,200,400,200);
- editframe.setUndecorated(false);
- editframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- editframe.setVisible(true);
- }
- else
- {
- JOptionPane.showMessageDialog(null,"No record Found");
- }
- }
- catch (Exception ex)
- {
- JOptionPane.showMessageDialog(null, ex);
- }
- }
- });
- edit.setVisible(true);
- }
- public static void main(String[] args) {
- Databaseretrievedata v=new Databaseretrievedata();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement