---------------------創(chuàng)建存儲(chǔ)過程---------------------
1
create procedure InsertPro
2@StuID int,
3@StuName varchar(10),
4@StuAddress varchar(20)
5as
6insert into 學(xué)生基本信息表 values(@StuID,@StuName,@StuAddress)
7
8-----------調(diào)用存儲(chǔ)過程---------------
9exec InsertPro 5,'555','555'
--------------在Java中調(diào)用--------------------
1import java.sql.*;
2
3public class ProcedureTest {
4 public static void main(String args[]) throws Exception {
5 // 加載驅(qū)動(dòng)
6 DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
7 // 獲得連接
8 Connection conn = DriverManager.getConnection("jdbc:odbc:mydata", "sa",
9 "");
10 // 創(chuàng)建存儲(chǔ)過程的對(duì)象
11 CallableStatement c = conn.prepareCall("{call InsertPro(?,?,?)}");
12 c.setInt(1, 6);
13 c.setString(2, "Liu");
14 c.setString(3, "wuhan");
15 c.execute();
16 c = conn.prepareCall("{call selePro}");
17 ResultSet rs = c.executeQuery();
18 while (rs.next()) {
19 String stuid = rs.getString("StuID");
20 String name = rs.getString("StuName");
21 String address = rs.getString("StuAddress");
22 System.out.println(stuid + " " + name + " " + address);
23 }
24 c.close();
25 }
26}
posted on 2009-02-19 10:06
飛翔天使 閱讀(214)
評(píng)論(0) 編輯 收藏 所屬分類:
java