import java.sql.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;
import java.lang.*;
//#sql context ctx;
//#sql context ctx with(dataSource="jdbc/db118");
#sql iterator couser(int);
class bind_test {
#sql public static context ctx with(dataSource="jdbc/cjdb");
public static void main(String[] argv) {
/*
String userid="db2inst1";
String passwd = "db2inst1";
String url = "jdbc:db2:sample";
*/
Connection conn = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
try {
couser couser1;
//ctx conctx = new ctx("jdbc:db2:sample",false);
//DefaultContext ctx = DefaultContext.getDefaultContext();
//Connection con = conctx.getConnection();
int i=0;
String str="test";
int itval=111;
long btva=111;
double setva = 189;
Integer ita = null;
String var=null;
int inpro=12;
String outpro=null;
conn = DriverManager.getConnection("jdbc:db2://192.168.1.110:50000/cjdb", "db2inst1", "1");
ctx newctx = new ctx(conn);
//#sql [newctx] {insert into describe_test (it,bt,de) values(999,999,999)};
//#sql [newctx] {insert into describe_test values(:itval,:btva,:setva,:str)};
//#sql [newctx] {update describe_test set it=:setva ,de=:setva where bt =:btva};
//#sql [newctx] {delete from describe_test where it =999 };//要加from
#sql [newctx] {call db2inst1.test_dc(:IN inpro,:OUT outpro)};//各位大虾这句还有别的实现方法不？百度查了半天还是找不到解决办法，求大虾帮忙！！！
System.out.println("Output parameters from TEST_DC call: " + outpro);
//#sql [newctx] /*couser1 =*/{select va into :var from describe_test where (va=:str or :str='') and bt=111};//into :i
/* while(true)
{
#sql {FETCH:couser1 INTO:i};
if(couser1.endFetch()) break;
System.out.println(""+i);
}
couser1.close();
*/
//System.out.println(""+i);
System.out.println("ok");
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}