procedure.java

来自「USB设计的一些源码！适合与USB开发的同学！还是蛮不错的！我用过一些！」· Java 代码 · 共 27 行

import java.sql.*;
public class procedure{

public static void main(String args[]){
		ResultSet result=null;
		Connection con=null;
		try
		{
									Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" ); 
    con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=Northwind", "sa", ""); 
            //调用存储过程test
			CallableStatement cStmt =con.prepareCall("{call test(?,?)}");
            //给IN参数赋值
			cStmt.setString(1,"VINET");
            //注册OUT参数
			cStmt.registerOutParameter(2,java.sql.Types.INTEGER);
		    cStmt.execute();
            //得到OUT参数的值
			System.out.println(cStmt.getInt(2)); 
				}
		catch(Exception e)
		{
			System.out.println("Error"+ e);
		}
	}
}