JAVA中對存儲過程的調用方法（四） 修改數據的存儲過程

四、修改數據的存儲過程

---------------------創建存儲過程---------------------
create procedure ModPro
@StuID int,
@StuName varchar(10)
as
update 學生基本信息表 set StuName=@StuName where StuID=@StuID

-------------執行存儲過程-------------------------
exec ModPro 2,'四毛'
---------------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 ModPro(?,?)}");

c.setInt(1,2);
c.setString(2,"美女");

c.execute();

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

while(rs.next())
{
String Stu=rs.getString("StuID");
String name=rs.getString("StuName");
String add=rs.getString("StuAddress");

System.out.println ("學號:"+" "+"姓名:"+" "+"地址");
System.out.println (Stu+" "+name+" "+add);
}
c.close();
}
}