test/soakTest/jdbcSelect.java

   1 import java.sql.*;
   2 public class jdbcSelect
   3 {
   4     public static void main(String[] args)
   5     {
   6         try {
   7             Class.forName("csql.jdbc.JdbcSqlDriver");
   8             Connection con = DriverManager.getConnection("jdbc:csql", "root", "manager");
   9             PreparedStatement stmt = null, selStmt= null;
  10             selStmt=con.prepareStatement("select * from t1 limit 50 offset 5;");
  11             ResultSet rs = null; int f1var=0, f2var=0, f3var=0;
  12             float f4var=0;
  13             double f5var=0;
  14             String f6var="";
  15
  16             while(true){
  17                 rs=selStmt.executeQuery();
  18                 if(rs.next()){
  19                     f1var=rs.getInt(1);
  20                     f2var=rs.getInt(2);
  21                     f3var=rs.getInt(3);
  22                     f4var=rs.getFloat(4);
  23                     f5var=rs.getDouble(5);
  24                     f6var=rs.getString(6);
  25                 }
  26                 System.out.println("Selected value: " +f1var +" " +f2var +" " +f3var +" " +f4var +" " +f5var +" " +f6var);
  27                 con.commit();
  28                 Thread.sleep(5000);
  29             }
  30         }
  31         catch (Exception e) {
  32             System.out.println("Exception: "+ e);
  33         }
  34    }
  35 }
  36
  37
  38
  39