Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package orz.neptune.prospring3.ch8; import java.sql.Types; import javax.sql.DataSource; import org.springframework.jdbc.core.SqlParameter; import org.springframework.jdbc.object.SqlFunction; /** * * @author Administrator */ public class StoreFunctionQuery extends SqlFunction<String> { private static final String SQL = "select getfirstnamebyid(?)"; public StoreFunctionQuery(DataSource dataSource) { super(dataSource, SQL); super.declareParameter(new SqlParameter(Types.INTEGER)); compile(); } }