Java checking whether the value exists in database

Question

hello i am working on java and MySQL. My implementation are as follows :

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.sql.*;
import java.util.Scanner;

public class BankingSystem extends JFrame {
    public static void main(String[] args) throws Exception{
        int ur=0;
        int PIN;
        String ID;
        Scanner s=new Scanner(System.in);
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/BankingSystem";
        String user = "root";
        String pass="";
        Connection con = DriverManager.getConnection(url,user,pass);
        Statement st = con.createStatement();
        System.out.println("Enter Your 4 digit PIN");
        PIN=s.nextInt();

        ResultSet rs=st.executeQuery("select * from customerinformation where pin ="+PIN);
//checking for existance of user entered pin
if((rs.getString(1)).equals("")){System.out.println("Invalid PIN");}


        while(rs.next())
        {

            System.out.println(rs.getString(1)+"  "+rs.getString(2)+"  "+rs.getString(3)+"  "+rs.getString(4));

        }

    }

}

but this code is not working. Giving some sort of exception error but when i remove the line containing if statement then it work fine.How do i check whether the pin is valid or not.

it giving following exception:

Exception in thread "main" java.sql.SQLException: Before start of result set
        at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3624)
        at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1762)
        at BankingSystem.main(BankingSystem.java:22)

Can you post the exception details?

Davie Brown
– Davie Brown

2014-08-30 13:56:54 +00:00
Commented Aug 30, 2014 at 13:56 — Davie Brown
– Davie Brown, Commented Aug 30, 2014 at 13:56

SparkOn · Accepted Answer · 2014-08-30 14:04:31Z

2

try this way Replace this Statement st = con.createStatement(); with

String query ="select * from customerinformation where pin =?"
PreparedStatement st =con.prepareStatement("query");
st.setInt(1,PIN);
ResultSet resultSet = st.executeQuery();

You should never use Statement over PreparedStatement

if (!resultSet.next() ) {
    System.out.println("resultset does not data");
} else {

    do {
        System.out.println(rs.getString(1)+"  "+
                           rs.getString(2)+"  "+
                          rs.getString(3)+"  "+
                          rs.getString(4));


    } while (resultSet.next());
}

edited Aug 30, 2014 at 14:04

answered Aug 30, 2014 at 13:59

SparkOn

8,9665 gold badges31 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

reVerse · Accepted Answer · 2014-08-30 14:50:46Z

0

if((rs.getString(1)).equals("")){
   System.out.println("Invalid PIN");
}

without rs.next(), rs.getString(1) is not possible

Try this:

    if(rs.next()){
        System.out.println(rs.getString(1)+"  "+rs.getString(2)+" "+rs.getString(3)+"  "+rs.getString(4));
    } else {
     System.out.println("Invalid PIN");   
    }

edited Aug 30, 2014 at 14:50

reVerse

35.3k22 gold badges94 silver badges88 bronze badges

answered Aug 30, 2014 at 14:12

Jay Patel

11 bronze badge

Collectives™ on Stack Overflow

Java checking whether the value exists in database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related