procedemo4.java

在 java中调用 sqlserver存储过程

//删除存储过程中的数据
import java.sql.*;
public class ProceDemo4
{
	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 delePro(?)}");
    		cstmt.setInt(1,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) {
	    }
    }
}