How to search and insert a value using java code?

Question

  String link = "http://hosted.ap.org";

I want to find whether the given url is already existing in the SQL DB under the table name "urls". If the given url is not found in that table i need to insert it in to that table.

As I am a beginner in Java, I cannot really reach the exact code.

Please advise on this regard on how to search the url in the table.

I am done with the SQL Connection using the java code. Please advise me on the searching and inserting part alone as explained above.

For what database? And the table - it's called URLS, but what are the columns in it? What have you tried so far, because we aren't here to provide you end-to-end solutions. — OMG Ponies
– OMG Ponies, Commented Aug 17, 2010 at 16:00
LNADWEEK is the database name. I am done with the SQL Connection part. There is only one column in it named URL, which has a list of 20000 URLs. — LGAP
– LGAP, Commented Aug 17, 2010 at 16:02

mhshams · Accepted Answer · 2010-08-17 16:05:33Z

2

PreparedStatement insert = connectin.preparedStateme("insert into urls(url) vlaues(?)");
PreparedStatement search = connectin.preparedStateme("select * from urls where url = ?");
search.setString(1, <your url value to search>);
ResultSet rs = search.executeQuery();
if (!rs.hasNext()) {
    insert.setString(1, <your url value to insert>);
    insert.executeUpdate();
}

//finally close your statements and connection ...

i assumed that you only have one field your table and field name is url. if you have more fields you need to add them in insert query.

answered Aug 17, 2010 at 16:05

mhshams

17.1k17 gold badges57 silver badges65 bronze badges

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

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

You need to distinguish between two completely separate things: SQL (Structured Query Language) is the language which you use to communicate with the DB. JDBC (Java DataBase Connectivity) is a Java API which enables you to execute SQL language using Java code.

To get data from DB, you usually use the SQL SELECT statement. To insert data in a DB, you usually use the SQL INSERT INTO statement

To prepare a SQL statement in Java, you usually use Connection#prepareStatement(). To execute a SQL SELECT statement in Java, you should use PreparedStatement#executeQuery(). It returns a ResultSet with the query results. To execute a SQL INSERT statement in Java, you should use PreparedStatement#executeUpdate().

Collectives™ on Stack Overflow

How to search and insert a value using java code?

2 Answers 2

Comments

See also:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

See also:

Comments

Your Answer

Sign up or log in

Post as a guest

Related