JAVAÖÐOracleÈ¡Öµ

package com.svse.dao;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class UserDAO {
/*
* javaµ÷Óô洢¹ý³Ì
*/
public int addUser(String username,int userage)
{
Connection conn = null;
int userid =0;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.13.142:1521:ORCL","scott","tiger");
//µ÷Óùý³Ì
CallableStatement cs = conn.prepareCall("{ call proc_addUser(?,?,?) }");
cs.setString(1, username);
cs.setInt(2, userage);
//¶ÔÓÚÊä³ö²ÎÊý ÄÇôÐèÒª»ñÈ¡ËüµÄÖµ
//1 ÐèҪע²á¸Ã²ÎÊýµÄ ÀàÐÍ
cs.registerOutParameter(3, java.sql.Types.INTEGER);
//µ÷Óô洢¹ý³Ì
cs.execute();
//»ñÈ¡´æ´¢µÄÊä³ö²ÎÊý
userid = cs.getInt(3);
conn.close();

} catch (Exception e) {
e.printStackTrace();
}
return userid;


}

public static void main(String[] args) {
UserDAO dao = new UserDAO();
int userid = dao.addUser("ÍõÂé×Ó",19);
System.out.println(userid);
}


}