Spring的第二个程序

今天写了一下Spring连接数据库的程序，学到了一些东西，我用的数据库是sqlserver2000,首先将需要的包导入（包括数据库以及spring的相关的包），然后进行编写程序。
(1)myspring.xml

<?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="databasetest" class="org.springframework.jdbc.core.JdbcTemplate">
     <property name="dataSource">
     <ref local="dataSource"/>
     </property>
  </bean>

  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
       <property name="driverClassName">
           <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
       </property>
       <property name="url">
           <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseNamemypro=mypro</value>
       </property>
       <property name="username">
           <value>sa</value>
       </property>
       <property name="password">
          <value>sa</value>
       </property>
  </bean>
 </beans>

不同的数据库，需要变动加载驱动类的名称、url，并且填好针对自己数据库的用户名和密码。
（2）SqlStatement.java

 package com;

public abstract class SqlStatement {

	final public static String createsql="create table mytable(id int,cname varchar(50))";
	final public static String insertdata1="insert into mytable values(1,'name1')";
	final public static String insertdata2="insert into mytable values(2,'test2')";
	final public static String insertdata3="insert into mytable values(3,'test3')";
	final public static String selectsql="select * from mytable";

}

把这些语句单独的定义在一个类中，可以使程序结构更加清晰，维护更加方便。
（3）SpringToResult.java

package com;

public class SpringToResult {
	private int id;
	private String name;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}

}

SpringToResult类中的对象对应数据库中mytable表中一条记录。
（4）DbTest.java

package com;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.core.RowCountCallbackHandler;

public class DbTest {
	public static void main(String args[]) {
		Resource resource = new ClassPathResource("com/myspring.xml");
		BeanFactory factory = new XmlBeanFactory(resource);
		JdbcTemplate jt = (JdbcTemplate) factory.getBean("databasetest");
		jt.execute(SqlStatement.createsql);//创建表
		jt.execute(SqlStatement.insertdata1);//插入数据
		jt.execute(SqlStatement.insertdata2);
		jt.execute(SqlStatement.insertdata3);
                   //获取表中信息
		RowCountCallbackHandler rcch = new RowCountCallbackHandler();
		jt.query(SqlStatement.selectsql, rcch);
		System.out.println("结果集中的列数量:" + rcch.getColumnCount());
		System.out.println("结果集中的行数量" + rcch.getRowCount());
		System.out.println("结果集中的结果:");

		String[] str = rcch.getColumnNames();
		for (int i = 0; i < str.length; i++) {
			System.out.print(str[i] + "  ");
		}

		final ArrayList<SpringToResult> list = new ArrayList<SpringToResult>();
		jt.query(SqlStatement.selectsql, new RowCallbackHandler() {

			public void processRow(ResultSet rs) throws SQLException {
								SpringToResult sri = new SpringToResult();
				sri.setId(rs.getInt(1));
				sri.setName(rs.getString(2));
				list.add(sri);
			}
		});

		for (int i = 0; i < list.size(); i++) {
			SpringToResult sri = (SpringToResult) list.get(i);
			System.out.print("\n" + " " + sri.getId());
			System.out.print("    " + sri.getName());
		}
		System.out.println("\n完成");

	}

}

然后运行后会发现有这样的错误产生：
2010-5-6 19:44:48 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [com/myspring.xml]
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databasetest' defined in class path resource [com/myspring.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [org.apache.commons.dbcp.BasicDataSource] for bean with name 'dataSource' defined in class path resource [com/myspring.xml]; nested exception is java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSource
Caused by: org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [org.apache.commons.dbcp.BasicDataSource] for bean with name 'dataSource' defined in class path resource [com/myspring.xml]; nested exception is java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSource
Caused by: java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSource
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at org.springframework.util.ClassUtils.forName(ClassUtils.java:229)
at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:327)
at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1073)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:348)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1100)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:862)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at com.DbTest.main(DbTest.java:19)
（5）进行仔细查看发现在xml中运用到了org.apache.commons.dbcp.BasicDataSource
dbcp是用来配置连接池的,在引入的包当中没有找到所以会出现ClassNotFound的例外，在lib\jakarta-commons找到对应的common-dbcp.jar和common-pool.jar，进行导入，然后再次运行出现正确的结果。