procedemo1.java

在 java中调用 sqlserver存储过程

import java.sql.*;
public class ProceDemo1
{
	public static void main(String [] args)
	{
		//加载驱动
		try {
			DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			//获得连结
			//jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=BookStore
			Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Demo","sa","ok");
			//创建存储过程的对象
			CallableStatement c = conn.prepareCall("{call getsum(?)}");
			//给存储过程的参数设置值
			c.setInt(1,100);
			//执行存储过程
//			ResultSet rs= c.executeQuery();
//			while(rs.next())
//			{
//				System.out.println (rs.getInt(1));
//			}
			c.execute();
			conn.close();
	    }
	    catch (SQLException ex) {
	    	ex.printStackTrace();
	    }
	}
}