java连接MySQL 函数过程的PROCEDURE

1.0

    @Value("${spring.datasource.url:#{null}}")
    private String url;
    @Value("${spring.datasource.username:#{null}}")
    private String username;
    @Value("${spring.datasource.password:#{null}}")
    private String password;

    public String getMayBeLike1(String phone) {
        String name= "";
        try {
            Connection connection = DriverManager.getConnection(url,username,password);
            String sql = "{call get_list(?)}";
            CallableStatement callableStatement = connection.prepareCall(sql);
            callableStatement.setString(1,phone);
            ResultSet resultSet = callableStatement.executeQuery();
            while (resultSet.next()){
                name= resultSet.getString("name");
            }
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return name;
    }

 

 

2.0

    @Resource
    DataSource dataSource;
    public String getMayBeLike2(String phone) {
        String name= "";
        try {
            Connection connection = dataSource.getConnection();
            String sql = "{call get_list(?)}";
            CallableStatement callableStatement = connection.prepareCall(sql);
            callableStatement.setString(1,phone);
            ResultSet resultSet = callableStatement.executeQuery();
            while (resultSet.next()){
                name= resultSet.getString("name");
            }
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return name;
    }

 

 

3.0

 

    @Resource
    JdbcTemplate jdbcTemplate;
    @Override
    public String getMayBeLike(String phone) {
        String name= "";
        try {
            String sql = "{call get_atcl_list(?)}";
            name = jdbcTemplate.queryForObject(sql, String.class, phone);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return name;
    }