2 public class jdbcSelect
4 public static void main(String
[] args
)
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;
17 rs
=selStmt
.executeQuery();
23 f5var
=rs
.getDouble(5);
24 f6var
=rs
.getString(6);
26 System
.out
.println("Selected value: " +f1var
+" " +f2var
+" " +f3var
+" " +f4var
+" " +f5var
+" " +f6var
);
32 System
.out
.println("Exception: "+ e
);