import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
public class Call {
public final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 数据库驱动
public final static String URL = "jdbc:sqlserver://localhost:1433;DataBaseName=stuDB"; // url
public final static String DBNAME = "sa"; // 数据库用户名
public final static String DBPASS = "";
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName(DRIVER);
Connection conn = DriverManager.getConnection(URL, DBNAME, DBPASS); // 获得数据库连接
CallableStatement proc =conn.prepareCall("{call proc_selectAll(?,?)}"); //调用存储过程
proc.setInt(1, 2000);//传入参数
proc.registerOutParameter(2, Types.INTEGER);//传出参数
ResultSet rs=proc.executeQuery(); //执行
System.out.println("存款金额2000以上的帐户");
System.out.print("金额\t");
System.out.println("编号");
while(rs.next()){ //循环显示记录
System.out.print(rs.getInt(1)+"\t");//输出第一列
System.out.println(rs.getInt(2));//输出第二列
}
int count=proc.getInt(2);//得到传出参数值
System.out.println("帐户总数"+count);
conn.close();
rs.close();
proc.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} // 注册驱动
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
