jdbctemplate调用 mysql存储过程

最新推荐文章于 2024-05-10 12:41:21 发布

weixin_34238633

最新推荐文章于 2024-05-10 12:41:21 发布

阅读量562

点赞数

文章标签：数据库 python java

原文链接：https://my.oschina.net/u/2900652/blog/1550444

版权

2019独角兽企业重金招聘Python工程师标准>>>

@Autowired
private JdbcTemplate jdbcTemplate;

@Override
public Member getMember(final String type,final String mobile) {
    final Member member = new Member();
    Member result = (Member) jdbcTemplate.execute(
            new CallableStatementCreator() {
                public CallableStatement createCallableStatement(java.sql.Connection con) throws SQLException {
                    String storedProc = "{call checkvip(?,?,?,?,?,?,?,?,?)}";// 调用的sql
                    CallableStatement cs = con.prepareCall(storedProc);
                    cs.setInt(1,Integer.valueOf(type));// 设置输入参数的值
                    cs.setString(2, mobile);// 设置输入参数的值
                    cs.registerOutParameter(3, Types.INTEGER);// 注册输出参数的类型
                    cs.registerOutParameter(4, Types.VARCHAR);
                    cs.registerOutParameter(5, Types.VARCHAR);
                    cs.registerOutParameter(6, Types.VARCHAR);
                    cs.registerOutParameter(7, Types.BIT);
                    cs.registerOutParameter(8, Types.VARCHAR);
                    cs.registerOutParameter(9, Types.VARCHAR);
                    return cs;
                }
            }, new CallableStatementCallback() {
                public Object doInCallableStatement(CallableStatement cs) throws SQLException,DataAccessException {
                    cs.execute();
                    String csString = cs.getString(3);
                    if (csString.equals("0")) {
                        return null;
                    }else{
                        member.setCode(cs.getString(5));
                        member.setUsername(cs.getString(6));
                        String s = cs.getString(7);
                        if (s.equals("0")) {
                            member.setGender(Member.Gender.male);
                        }else{
                            member.setGender(Member.Gender.female);
                        }
                        member.setMobile(cs.getString(8));
                        member.setEmail(cs.getString(9));
                        return member;
                    }
                }
            });
    return result;
}