util.java :  » Database-DBMS » db-derby-10.2 » org » apache » derbyTesting » databaseclassloader » addon » vendor » Java Open Source

// simple test file
package org.apache.derbyTesting.databaseclassloader.addon.vendor;


import java.sql.*;

public class  util
{

  public static short valid(String contact)
    throws SQLException
  {
       Connection conn = DriverManager.getConnection("jdbc:default:connection");
       PreparedStatement ps = conn.prepareStatement(
         "SELECT OK FROM EMC.CONTACTS WHERE E_MAIL = ?");

       ps.setString(1, contact);

       short ok = 0;

       ResultSet rs = ps.executeQuery();

       if (rs.next())
       {
         if (rs.getShort(1) == 1)
            ok = 1;
       }

       rs.close();
       ps.close();
       conn.close();
       return ok;
  }
}