public class DBCompare { Connection conn = null; PreparedStatement prep = null; ResultSet rset = null; try { Class.forName( "<;driver>;" ).newInstance(); conn = DriverManager.getConnection( "<;database>;" ); String sql = "SELECT * FROM <;table>; WHERE <;column name>; = ?"; prep = conn.prepareStatement( sql ); prep.setString( 1, "<;column value>;" ); rset = prep.executeQuery(); if( rset.next() ) { System.out.println( rset.getString( "<;column name" ) ); } } catch( SException e ) { e.printStackTrace(); } finally { rset.close(); prep.close(); conn.close(); } } |
public class DBCompare { String sql = "SELECT * FROM <;table>; WHERE <;column name>; = ?"; try { Mysql msql=new mysql(sql); prep.setString( 1, "<;column value>;" ); rset = prep.executeQuery(); if( rset.next() ) { System.out.println( rset.getString( "<;column name" ) ); } } catch( SException e ) { e.printStackTrace(); } finally { mysql.close(); mysql=null; } } |