JDBC中使用存储过程

public class Procedure {
	public static void getProcedureInfo(Connection conn){
		try {
			DatabaseMetaData metaData=conn.getMetaData();
			System.out.println("数据库相关信息:");
			System.out.println("数据库名称:"+metaData.getDatabaseProductName());
			System.out.println("数据库版本:"+metaData.getDatabaseProductVersion());
			System.out.println("Diver名称:"+metaData.getDriverName());
			System.out.println("Driver版本:"+metaData.getDriverVersion());
			System.out.println("Vendor name:"+metaData.getProcedureTerm());
			System.out.println("All procedure are callable?:"+metaData.allProceduresAreCallable());
			System.out.println("Support stored procedure:"+metaData.supportsStoredProcedures());
			ResultSet resultSet=metaData.getProcedures(null, null, null);
			System.out.println("数据库中的存储过程：");
			while(resultSet.next()){
				System.out.println(resultSet.getString("PROCEDURE_NAME"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	public void executeProc(Connection conn,String name,LinktoSqlSever link){
		String query="execute TestProc "+name;
		Statement statement=null;
		ResultSet resultSet=null;
		try {
			statement=conn.createStatement();
			resultSet=statement.executeQuery(query);//执行存储过程
			link.displayTabledata(resultSet);//显示所有的查询结果
		} catch (SQLException e) {
			e.printStackTrace();
		}
		finally {
			try {
				if(!resultSet.wasNull())
					resultSet.close();
				statement.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}