import java.sql.*;import java.util.*;import java.sql.DriverManager;// return true if some records satisfy the condition, otherwase, false.public Boolean IsExifPhotoIdTimeLongitudeLatitude( String photoId, String time, String longitude, String latitude ){Connection con = null;String url = "";String driver = "";Statement stmt = null;String query = "";// your database table nameString targetSheet = "db_table_name";ResultSet result = null;Boolean hasRecord = false;// your queryquery = "SELECT * FROM `"+ targetSheet +"` WHERE photoId='" + photoId + "' AND time='" + time + "' AND longitude='" + longitude + "' AND latitude='" + latitude + "'";try{// connect to mysql databaseurl = "jdbc:mysql://127.0.0.1:3306/database_name";driver = "com.mysql.jdbc.Driver";p = new Properties();Class.forName(driver).newInstance();con = DriverManager.getConnection(url, "user_name", "pass_word");// create statementstmt = con.createStatement();// execute your queryresult = stmt.executeQuery(query);// result.first() will return false if there is no record// Important: executeQuery never return nullif( result.first() ){hasRecord = true;}}catch( Exception e ) {e.printStackTrace();}finally {}return hasRecord;}
Friday, December 4, 2009
Check if there are some records in ResultSet return from MySQL Database using Java
| Reactions: |
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment