spring连接数据库 急啊!!在线等
源代码:
// 连接mysql
public void conMySql() {
Resource resource = new ClassPathResource("applicationContext.xml");
BeanFactory factory = new XmlBeanFactory(resource);
JdbcTemplate jt = (JdbcTemplate) factory.getBean("dataSourceMysql");
/*ApplicationContext cts = new FileSystemXmlApplicationContext("bean.xml");
DataSource ds = (DataSource) cts.getBean("dataSource");
JdbcTemplate jt = new JdbcTemplate(ds);
*/
// List al=new ArrayList();
// jt.execute("create table lyc(name varchar(20))");
List l = jt.queryForList("select * from userlist");
for (Iterator iter = l.iterator(); iter.hasNext();) {
System.out.println(iter.next().toString());
}
}
配置文件:
<bean id="dataSourceMysql"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>org.gjt.mm.mysql.Driver</value>
</property>
<property name="url">
<value>jdbc;mysql://localhost:3306/demo</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>lyc</value>
</property>
</bean>
错误提示:
Exception in thread "main" java.lang.ClassCastException: org.apache.commons.dbcp.BasicDataSource
at test.SimpleTest.conMySql(SimpleTest.java:65)
at test.SimpleTest.main(SimpleTest.java:44)