Spring框架之JDBC操作（1.0）

Spring框架之JDBC操作（1.0）

在Spring Persistence中打勾;

传统的做法：

1，建立数据库脚本：

-- 删除数据库
DROP DATABASE IF EXISTS mldn ;
-- 创建数据库
CREATE DATABASE mldn CHARACTER SET UTF8 ;
-- 使用数据库
USE mldn ;
-- 删除数据表
DROP TABLE IF EXISTS member ;
-- 创建member表
CREATE TABLE member(
	mid			VARCHAR(50) ,
	name		VARCHAR(50) ,
	age			INT ,
	sex			VARCHAR(10) ,
	birthday 	DATE ,
	salary		DOUBLE ,
	note		TEXT ,
	CONSTRAINT pk_mid PRIMARY KEY(mid) 
) type=innodb ;
-- 增加测试数据
INSERT INTO member(mid,name,age,birthday,salary,note,sex) VALUES ('mldn-a','张三',10,'1991-11-11',11.1,'不错','男') ;
INSERT INTO member(mid,name,age,birthday,salary,note,sex) VALUES ('mldn-b','李四',10,'1991-11-12',21.1,'很好','男') ;
INSERT INTO member(mid,name,age,birthday,salary,note,sex) VALUES ('mldn-c','王五',10,'1991-11-13',31.1,'凑合','女') ;
INSERT INTO member(mid,name,age,birthday,salary,note,sex) VALUES ('mldn-d','赵六',10,'1991-11-14',41.1,'邋遢','女') ;
INSERT INTO member(mid,name,age,birthday,salary,note,sex) VALUES ('mldn-e','孙七',10,'1991-11-15',51.1,'肮脏','女') ;
INSERT INTO member(mid,name,age,birthday,salary,note,sex) VALUES ('mldn-f','王八',10,'1991-11-16',61.1,'龌龊','男') ;

进行数据库连接的类为：

org.springframework.jdbc.datasource.DriverManagerDataSource;

范例：最笨的方法是自己通过NEW来进行连接控制：

package cn.mldn.demo;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class TestConnection {
	public static void main(String[] args) {
		DriverManagerDataSource dataSource = new DriverManagerDataSource() ;
		dataSource.setDriverClassName("org.gjt.mm.mysql.Driver");
		dataSource.setUrl("jdbc:mysql://localhost:3306/mldn");
		dataSource.setUsername("root");
		dataSource.setPassword("mysqladmin");
		System.out.println(dataSource);
	}
}

升级版：利用Spring管理数据库连接：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd">
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="org.gjt.mm.mysql.Driver"/>
		<property name="url" value="jdbc:mysql://localhost:3306/mldn"/>
		<property name="username" value="root"/>
		<property name="password" value="mysqladmin"/>
	</bean>
</beans>

2，编写测试类：

package cn.mldn.demo;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
public class TestConnectionDemo {
	public static void main(String[] args) {
		ApplicationContext ctx = new ClassPathXmlApplicationContext(
				"applicationContext.xml");
		DriverManagerDataSource dataSource = ctx.getBean("dataSource",
				DriverManagerDataSource.class); 
		System.out.println(dataSource);
	}
}

3，
运行结果：