public static int createID()
{
int id=Math.abs((int)(new java.util.Date()).getTime());;
try {
Context ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("ticsDS");
Connection conn = ds.getConnection();
CallableStatement cs=conn.prepareCall("{call P_GET_ID(?,?)}");
cs.setString(1,"YHSCX_ZTB");
cs.registerOutParameter(2,java.sql.Types.INTEGER);
cs.execute();
id=cs.getInt(2);
} catch (Exception e) {
e.printStackTrace();
}
return id;
}
{
int id=Math.abs((int)(new java.util.Date()).getTime());;
try {
Context ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("ticsDS");
Connection conn = ds.getConnection();
CallableStatement cs=conn.prepareCall("{call P_GET_ID(?,?)}");
cs.setString(1,"YHSCX_ZTB");
cs.registerOutParameter(2,java.sql.Types.INTEGER);
cs.execute();
id=cs.getInt(2);
} catch (Exception e) {
e.printStackTrace();
}
return id;
}
stmt.getString(2);