jdbc

获取连接

文件目录：

代码：jdbc.properties

jdbc.user=rootjdbc.password=439901jdbc.driverClass=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/examinitialPoolSize = 5maxPoolSize = 20

applicationContext.xml

Test.java

package com.neuedu.test;import java.sql.SQLException;import javax.sql.DataSource;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class Test {	public static void main(String[] args) throws SQLException {		ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");		DataSource dataSource = ac.getBean(DataSource.class);		System.out.println(dataSource.getConnection());	}}

输出：成功获取连接

修改代码：（语句块）

新建 Person.java

package com.neuedu.test;public class Person {	private String name = "zhangsan";	private int age;		public Person() {		name = "wangwu";		System.out.println("Persom(){}");	}	public Person(String name) {		this.name = name;	}	public Person(String name,int age) {		this.name = name;		this.age = age;	}	{		name = "lisi";		System.out.println("创建Person类的对象要初始化一些操作");	}}

新建JdbcTemplateTest.java

package com.neuedu.test;import static org.junit.Assert.*;import org.junit.Test;public class JdbcTemplateTest {	@Test	public void test() {		Person p = new Person();	}}

输出：

修改代码：（链接数据库，传递数据）

数据库：

代码：

修改JdbcTemplateTest.java

package com.neuedu.test;import static org.junit.Assert.*;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import org.springframework.jdbc.core.JdbcTemplate;public class JdbcTemplateTest {		ApplicationContext ac = null;   //修改代码		JdbcTemplate template = null;    //修改代码		{			ac = new ClassPathXmlApplicationContext("applicationContext.xml");  //修改代码			template = ac.getBean(JdbcTemplate.class);   //修改代码		}	@Test	public void testInsert() {     //修改代码		String sql = "insert into user values(null,?,?,?,?)";		Object[] objects = {"老王","123","12315","12315@163.com"};		template.update(sql, objects);    //修改代码	}}

修改applicationContext.xml

     
     		
      		
      			
       			
       			
       			
       									
       			
       		
      		
      			
          //修改代码		
      	
     

输出：成功把数据导入数据库