procedemo5.java

在 java中调用 sqlserver存储过程

/**   D:修改数据的存储过程
use Demo
go
create procedure ModPro
@StuID int,
@StuName varchar(10)
as
update 学生基本信息表 set StuName=@StuName where StuID = @StuID

exec ModPro 3,'郑园'
select * from 学生基本信息表

exec selePro
*/

import java.sql.*;
public class ProceDemo5
{
	public static void main(String [] args)
	{
		try {
			DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=Demo","sa","ok");
			CallableStatement cstmt = con.prepareCall("{call ModPro(?,?)}");
			cstmt.setInt(1,3);
			cstmt.setString(2,"郑园");
			cstmt.execute();
			cstmt = con.prepareCall("{call selePro}");
			ResultSet rs = cstmt.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);
			}
			con.close();
	    }
	    catch (SQLException ex) {
	    	ex.printStackTrace();
	    }
	}
}