How to perform a search in an SQL database with a java application?

Question

I'm planning to build a very very simple java application done on Netbeans that accepts basic individual information like ID number, name, and address and stores it on an sql database.

I want to put a search function on my program that accepts ID numbers. When the user inputs the ID number that is stored in the database, it will show the Name and address on a pop up message dialog.

I know this is possible but can you link me to some guides or documentations about the search function? or maybe you could give me a very short example of a sample code done in the search button?

Is this going to be for simple queries like ID = ? or more dynamic and complex queries based upon whatever fields are filled in? — Scary Wombat
– Scary Wombat, Commented Feb 3, 2014 at 2:44
Yeah just a very simple query like that. No need for dynamic search. The program just accepts the exact ID number. — Storio
– Storio, Commented Feb 3, 2014 at 2:46

Scary Wombat · Accepted Answer · 2014-02-04 02:29:01Z

1

Have a look at this link

It is using classes such as Connection and PreparedStatement

Pseudo-code being

String selectSQL = "SELECT USER_ID, USERNAME FROM DBUSER WHERE USER_ID = ?";

dbConnection = getDBConnection();
preparedStatement = dbConnection.prepareStatement(selectSQL);
preparedStatement.setInt(1, 1001);

// execute select SQL stetement
ResultSet rs = preparedStatement.executeQuery();

try {
  while (rs.next()) {
    String userid = rs.getString("USER_ID");
    String username = rs.getString("USERNAME");
    System.out.println("userid : " + userid);
  }

  } catch (SQLException e1) {
    // TODO Auto-generated catch block
    e1.printStackTrace();
  } finally {
    preparedStatement.close();
    dbConnection.close();
  }

edited Feb 4, 2014 at 2:29

answered Feb 3, 2014 at 2:50

Scary Wombat

44.9k7 gold badges38 silver badges67 bronze badges

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

Comments

therealrootuser · Accepted Answer · 2014-02-03 02:49:38Z

1

http://docs.oracle.com/javase/tutorial/jdbc/basics/

Look into how to use JDBC.

A very basic example:

    Connection c = null; //need to initialize a java.sql.Connection from JDBC.


    String sql = "SELECT * FROM Users WHERE name = ?";        
    PreparedStatement ps = c.prepareStatement(sql);
    ps.setString(1, "John Smith");

    ResultSet rs = ps.executeQuery();

    List<String> matchingNames = new ArrayList<>();
    while (rs.next())
    {
        String name = rs.getString("name");
        matchingNames.add(name);
    }       

    for (String name: matchingNames)
    {
        //Display dialog.
    }

answered Feb 3, 2014 at 2:49

therealrootuser

11k9 gold badges33 silver badges46 bronze badges

Comments

Doug Hou · Accepted Answer · 2014-02-03 02:54:56Z

0

This link is a very good JDBC tutorial. JDBC is the way that java uses database, but this is so basic that almost no real project use JDBC directly.

If you want to learn more, try MyBatis and Hibernate which are the most popular ORM framework, and both of them are based on JDBC.

PS. http://www.mkyong.com/ this site has many good tutorials for Java developer

answered Feb 3, 2014 at 2:54

Doug Hou

5605 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to perform a search in an SQL database with a java application?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related