This JDBC will teach you how to do the search in Eclipse using Mysql Database.
First Step : Establish the database connection in order to connect java and mysql. i attached the code below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | Connection con; PreparedStatement pst; public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/bill", "root",""); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } catch (SQLException ex) { ex.printStackTrace(); } } |
after Established the database connection call the connect() method inside the constructor of class.
1 2 3 4 5 | public Seach() { initialize(); Connect(); } |
After done the connection part. select the find button.paste the following code inside the addActionListener of the find button
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | public void actionPerformed(ActionEvent e) { String Billno = txtbno.getText(); try { pst = con.prepareStatement("SELECT name,balance from purchase where id=?"); pst.setString(1,Billno); ResultSet rs1=pst.executeQuery(); if(rs1.next()==false) { JOptionPane.showMessageDialog(null,"Bill not found!"); txtname.setText(""); txtbal.setText(""); txtbno.requestFocus(); } else { String name = rs1.getString(1); String balance = rs1.getString(2); txtname.setText(name.trim()); txtbal.setText(balance); } } catch (SQLException e1) { e1.printStackTrace(); } } |
i have attached the video link below. which will do this tutorials step by step.
