jdbc调用存储过程

import java.sql.*;

import java.sql.CallableStatement;

/**
 * 
 * 简单的jdbc调用存储过程 只有输入参数 返回单个结果集
 * 
 */
public class GeTest1 {
	public static void main(String[] args) {

		Connection connection = null;
		//用于执行 SQL 存储过程的接口
		CallableStatement statement = null;
		ResultSet resultSet = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://localhost:3306/test";

			String user = "root";

			String password = "123";

			connection = DriverManager.getConnection(url, user, password);

			String sql = "call proc_selectEmployee(?)";

			//调用存储过程
			statement = connection.prepareCall(sql);

			statement.setString(1, "SZ65380");

			resultSet = statement.executeQuery();

			if (resultSet.next()) {
				System.out.println(resultSet.getString("address"));
			}

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (resultSet != null) {
					resultSet.close();
				}
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}