Oracle values in Java

Package COM. svse. dao; </P> <p> Import Java. SQL. callablestatement; <br/> Import Java. SQL. connection; <br/> Import Java. SQL. drivermanager; <br/> Import Java. SQL. preparedstatement; </P> <p> public class userdao {<br/>/* <br/> * Java call Stored Procedure <br/> */<br/> Public int adduser (string username, int userage) <br/>{< br/> connection conn = NULL; <br/> int userid = 0; <br/> try {<br/> class. forname ("oracle. JDBC. driver. O Racledriver "); <br/> conn = drivermanager. getconnection ("JDBC: oracle: thin: @ 192.168.13.142: 1521: orcl", "Scott", "Tiger "); <br/> // call Process <br/> callablestatement cs = Conn. preparecall ("{call proc_adduser (?,?,?)} "); <Br/> CS. setstring (1, username); <br/> CS. setint (2, userage ); <br/> // obtain the value of the output parameter. <br/> // 1 the parameter type must be registered. <br/> CS. registeroutparameter (3, Java. SQL. types. integer); <br/> // call the Stored Procedure <br/> cs.exe cute (); <br/> // obtain the stored output parameter <br/> userid = cs. getint (3); <br/> Conn. close (); </P> <p >}catch (exception e) {<br/> E. printstacktrace (); <br/>}< br/> return userid; </P> <p >}</P> <p> Public static void main (string [] ARGs) {<br/> userdao Dao = new userdao (); <br/> int userid = Dao. adduser ("Wang Ma Zi", 19); <br/> system. out. println (userid); <br/>}</P> <p>