JAVA中對存儲過程的調用方法（六） 增加數據的存儲過程

六、增加數據的存儲過程

------------存儲過程--------------------
create procedure InsertPro
@StuID int,
@StuName varchar(10),
@StuAddress varchar(20)
as
insert into 學生基本信息表 values(@StuID,@StuName,@StuAddress)

-----------調用存儲過程---------------
exec InsertPro 5,'555','555'
-----------在JAVA中執行-------------
import java.sql.*;
public class ProcedureTest
{
public static void main(String args[]) throws Exception
{
//加載驅動
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
//獲得連接
Connection conn=DriverManager.getConnection("jdbc:odbc:mydata","sa","");

//創建存儲過程的對象
CallableStatement c=conn.divpareCall("{call InsertPro(?,?,?)}");
c.setInt(1,6);
c.setString(2,"Liu");
c.setString(3,"wuhan");

c.execute();

c=conn.divpareCall("{call selePro}");
ResultSet rs=c.executeQuery();

while(rs.next())
{
String stuid=rs.getString("StuID");
String name=rs.getString("StuName");
String address=rs.getString("StuAddress");
System.out.println (stuid+" "+name+" "+address);
}
c.close();
}
}