我是新手JAVA。我有一个配置文件
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <context:component-scan base-package="org.springframework.docs.test" /> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@192.168.1.217:1521:ksoradev"/> <property name="username" value="pkrdm"/> <property name="password" value="mypass"/> </bean> </beans>
然后我的代码
public class Main { public static void main(String args[]) throws Exception { ApplicationContext context = new ClassPathXmlApplicationContext("context.config.xml"); DataSource dataSource = (DataSource) context.getBean("dataSource"); JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); String lastName = jdbcTemplate.queryForObject( "select a.firstname from TEST a", new Object[]{1212L}, String.class); System.out.println(lastName); } }
当我运行它时,它返回错误无效的列索引。谁能帮我 ?
谢谢
您正在使用queryForObject(java.lang.String,java.lang.Object [],java.lang.Class),它期望对象数组绑定到PreparedStatement具有占位符的类型查询。
PreparedStatement
您的查询可能缺少占位符,例如:
select a.firstname from TEST a where id = ?
您会收到有关无效列索引的错误,因为当前无法将数组的内容映射到任何占位符索引。