<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
abstract="false" singleton="true" lazy-init="default"
autowire="default" dependency-check="default">
<property name="driverClassName"><value>oracle.jdbc.OracleDriver</value></property>
<property name="url"><value>jdbc:oracle:thin:@10.240.144.11:1521:XYMES</value></property>
<property name="username"><value>reel</value></property>
<property name="password"><value>reel</value></property>
</bean>
</beans>
------------------------------------
package com.kim.spring;
import java.util.List;import javax.sql.DataSource;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;public class Test
{ /**
* @param args
*/
public void aMethod()throws Exception
{
ApplicationContext ac=new FileSystemXmlApplicationContext("F:\\kim\\kimjob\\springkim\\src\\applicationContext.xml");
DataSource dataSource=(DataSource)ac.getBean("dataSource");
JdbcTemplate jt=new JdbcTemplate(dataSource);
List l= jt.queryForList("select * from tableA");
A a=(A)list.get(0); //exception here
}
public static void main(String[] args)
{
// TODO Auto-generated method stub
Test t=new Test();
try
{
t.aMethod();
} catch (Exception e)
{
// TODO: handle exception
e.printStackTrace();
}
}
}
---------------------------------在方法 aMethod()中的 A a=(A)list.get(0); 会抛出异常:
java.lang.ClassCastException: org.apache.commons.collections.map.ListOrderedMap cannot be cast to A请问大家这是什么原因?
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
abstract="false" singleton="true" lazy-init="default"
autowire="default" dependency-check="default">
<property name="driverClassName"><value>oracle.jdbc.OracleDriver</value></property>
<property name="url"><value>jdbc:oracle:thin:@10.240.144.11:1521:XYMES</value></property>
<property name="username"><value>reel</value></property>
<property name="password"><value>reel</value></property>
</bean>
</beans>
------------------------------------
package com.kim.spring;
import java.util.List;import javax.sql.DataSource;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;public class Test
{ /**
* @param args
*/
public void aMethod()throws Exception
{
ApplicationContext ac=new FileSystemXmlApplicationContext("F:\\kim\\kimjob\\springkim\\src\\applicationContext.xml");
DataSource dataSource=(DataSource)ac.getBean("dataSource");
JdbcTemplate jt=new JdbcTemplate(dataSource);
List l= jt.queryForList("select * from tableA");
A a=(A)list.get(0); //exception here
}
public static void main(String[] args)
{
// TODO Auto-generated method stub
Test t=new Test();
try
{
t.aMethod();
} catch (Exception e)
{
// TODO: handle exception
e.printStackTrace();
}
}
}
---------------------------------在方法 aMethod()中的 A a=(A)list.get(0); 会抛出异常:
java.lang.ClassCastException: org.apache.commons.collections.map.ListOrderedMap cannot be cast to A请问大家这是什么原因?
A a=(A)list.get(0); //exception here
在后面加个类型就行
抛出异常:
org.springframework.jdbc.IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 3这是什么原因啊?
new ParameterizedRowMapper<InterAcct>() {
@Override
public InterAcct mapRow(ResultSet rs, int index)
throws SQLException { InterAcct iat = new InterAcct();
iat.setAcct_No(rs.getString("Agmt_Id"));
iat.setAcct_Name(rs.getString("Agmt_Name"));
iat.setCurrency_Cd(rs.getString("Currency_Cd"));
iat.setBal(rs.getDouble("Bal"));
iat.setProd_Id(rs.getString("Prod_Id"));
iat.setSubject_Cd(rs.getString("Subject_Cd"));
iat.setOpen_Dt(rs.getString("Open_Dt"));
iat.setAgmt_Stat(rs.getString("Agmt_Stat")); return iat;
}
}); return iats;
这个是spring2.5之前的吧...........