二、JDBC调用存储过程

原创于 2011-11-08 22:49:50 发布 · 144 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

JDBC 专栏收录该内容

4 篇文章

订阅专栏

public static final String DBDRIVE = "oracle.jdbc.driver.OracleDriver";
	 public static final String DBURL = "jdbc:oracle:thin:@169.254.24.29:1521:orcl";
	 public static final String DBUSER = "scott";
	 public static final String DBPASSWORD= "tiger";
	public static void main(String[] args) 
	{
		Connection conn =null;
		CallableStatement cstmt = null;
		String sql = "{CALL myproc(?,?,?)}";

		try {
			Class.forName(DBDRIVE);
			conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
		    cstmt =conn.prepareCall(sql);
		    cstmt.setInt(1,70);
			cstmt.setInt(2, 80);
			cstmt.registerOutParameter(2, Types.INTEGER);
			cstmt.registerOutParameter(3, Types.INTEGER);
			cstmt.execute();
			cstmt.close();
			conn.close();

		} catch (SQLException e) {

			e.printStackTrace();
		} catch (ClassNotFoundException e) {

			e.printStackTrace();
		}


	}