¡¡¡¡ÔÚÏÂÃæµÄʵÀýÖУ¬½«Ïò´Ëº¯Êý´«µÝ AdventureWorks ʾÀýÊý¾Ý¿âµÄ´ò¿ªÁ¬½Ó£¬È»ºóʹÓà execute ·½·¨µ÷Óà CheckContactCity ´æ´¢¹ý³Ì£º
- ¡¡public static void executeStoredProcedure(Connection con) ...{
- try ...{
- CallableStatement cstmt = con.prepareCall("{? = call dbo.CheckContactCity(?)}");
- cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
- cstmt.setString(2, "Atlanta");
- cstmt.execute();
- System.out.println("RETURN STATUS: " + cstmt.getInt(1));
- }
- cstmt.close();
- catch (Exception e) ...{
- e.printStackTrace();
- }
- }
|
¡¡¡¡5¡¢Ê¹ÓôøÓиüмÆÊýµÄ´æ´¢¹ý³Ì
¡¡¡¡Ê¹Óà SQLServerCallableStatement À๹½¨¶Ô´æ´¢¹ý³ÌµÄµ÷ÓÃÖ®ºó£¬¿ÉÒÔʹÓà execute »ò executeUpdate ·½·¨ÖеÄÈÎÒâÒ»¸öÀ´µ÷Óô˴洢¹ý³Ì¡£executeUpdate ·½·¨½«·µ»ØÒ»¸ö int Öµ£¬¸ÃÖµ°üº¬ÊÜ´Ë´æ´¢¹ý³ÌÓ°ÏìµÄÐÐÊý£¬µ« execute ·½·¨²»·µ»Ø´ËÖµ¡£Èç¹ûʹÓà execute ·½·¨£¬²¢ÇÒÏ£Íû»ñµÃÊÜÓ°ÏìµÄÐÐÊý¼ÆÊý£¬Ôò¿ÉÒÔÔÚÔËÐд洢¹ý³Ìºóµ÷Óà getUpdateCount ·½·¨¡£
¡¡¡¡×÷ΪʵÀý£¬ÔÚ SQL Server 2005 AdventureWorks ʾÀýÊý¾Ý¿âÖд´½¨ÒÔϱíºÍ´æ´¢¹ý³Ì£º
- CREATE TABLE TestTable
- (Col1 int IDENTITY,
- Col2 varchar(50),
- Col3 int);
-
- CREATE PROCEDURE UpdateTestTable
- @Col2 varchar(50),
- @Col3 int
- AS
- BEGIN
- UPDATE TestTable
- SET Col2 = @Col2, Col3 = @Col3
- END;
|
¡¡¡¡ÔÚÏÂÃæµÄʵÀýÖУ¬½«Ïò´Ëº¯Êý´«µÝ AdventureWorks ʾÀýÊý¾Ý¿âµÄ´ò¿ªÁ¬½Ó£¬²¢Ê¹Óà execute ·½·¨µ÷Óà UpdateTestTable ´æ´¢¹ý³Ì£¬È»ºóʹÓà getUpdateCount ·½·¨·µ»ØÊÜ´æ´¢¹ý³ÌÓ°ÏìµÄÐмÆÊý¡£
- public static void executeUpdateStoredProcedure(Connection con) ...{
- try ...{
- CallableStatement cstmt = con.prepareCall("{call dbo.UpdateTestTable(?, ?)}");
- cstmt.setString(1, "A");
- cstmt.setInt(2, 100);
- cstmt.execute();
- int count = cstmt.getUpdateCount();
- cstmt.close();
-
- System.out.println("ROWS AFFECTED: " + count);
- }
- catch (Exception e) ...{
- e.printStackTrace();
|