jdbctest.java

来自「这个是j2eejava web 编程精要十五讲的全部源码。对学习java web」· Java 代码 · 共 37 行

package test;

//引入Spring相关接口与类
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;

public class JdbcTest {

	public static void main(String[] args) {
		
		//生成ApplicationContext对象
		ApplicationContext ac = new FileSystemXmlApplicationContext(
				"d:\\eclipse3.2\\workspace\\JdbcTemplateDemo\\test\\beans-config.xml");
			
		//获得DataSource的实例
		DataSource datasource = (DataSource)ac.getBean("datasource");
		
		//生成一个JdbcTemplate实例
		JdbcTemplate jt = new JdbcTemplate(datasource);
		
		//创建一个数据表
		jt.execute("create table t_student(id int not null,name varchar(50),primary key(id))");
		
		//向数据表中插入3行数据
		jt.execute("insert into t_student values(1,'Jack')");
		jt.execute("insert into t_student values(2,'Phil')");
		jt.execute("insert into t_student values(3,'Jenny')");
		
		//删除1行数据
		jt.execute("delete from t_student where id=3");
			
	}
}