<?xml version="1.0" encoding="GBK"?> <project name="spring" basedir="." default=""> <property name="src" value="src"/> <property name="dest" value="classes"/> <path id="classpath"> <fileset dir="../../lib"> <include name="**/*.jar"/> </fileset> <pathelement path="${dest}"/> </path> <target name="compile" description="Compile all source code"> <delete dir="${dest}"/> <mkdir dir="${dest}"/> <copy todir="${dest}"> <fileset dir="${src}"> <exclude name="**/*.java"/> </fileset> </copy> <javac destdir="${dest}" debug="true" includeantruntime="yes" deprecation="false" optimize="false" failonerror="true"> <src path="${src}"/> <classpath refid="classpath"/> <compilerarg value="-Xlint:deprecation"/> </javac> </target> <target name="run" description="Run the main class" depends="compile"> <java classname="lee.BeanTest" fork="yes" failonerror="true"> <classpath refid="classpath"/> </java> </target> </project>
drop database if exists spring; create database spring; use spring; create table news_inf ( news_id int auto_increment primary key, news_title varchar(255), news_content varchar(255) );
<?xml version="1.0" encoding="GBK"?> <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.springframework.org/schema/beans" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd"> <!-- 定义数据源Bean,使用C3P0数据源实现 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <!-- 指定连接数据库的驱动 --> <property name="driverClass" value="com.mysql.jdbc.Driver"/> <!-- 指定连接数据库的URL --> <property name="jdbcUrl" value="jdbc:mysql://localhost/spring"/> <!-- 指定连接数据库的用户名 --> <property name="user" value="root"/> <!-- 指定连接数据库的密码 --> <property name="password" value="32147"/> <!-- 指定连接数据库连接池的最大连接数 --> <property name="maxPoolSize" value="200"/> <!-- 指定连接数据库连接池的最小连接数 --> <property name="minPoolSize" value="2"/> <!-- 指定连接数据库连接池的初始连接数 --> <property name="initialPoolSize" value="2"/> <!-- 指定连接数据库连接池的连接的最大空闲时间 --> <property name="maxIdleTime" value="200"/> </bean> </beans>
package lee; import javax.sql.DataSource; import java.sql.*; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; /** * Description: * <br/>网站: <a href="http://www.crazyit.org">疯狂Java联盟</a> * <br/>Copyright (C), 2001-2016, Yeeku.H.Lee * <br/>This program is protected by copyright laws. * <br/>Program Name: * <br/>Date: * @author Yeeku.H.Lee kongyeeku@163.com * @version 1.0 */ public class BeanTest { public static void main(String[] args) throws Exception { // 实例化Spring容器。Spring容器负责实例化Bean ApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml"); // 获取容器中id为dataSource的Bean DataSource ds = ctx.getBean("dataSource", DataSource.class); // 通过DataSource来获取数据库连接 Connection conn = ds.getConnection(); // 通过数据库连接获取PreparedStatement PreparedStatement pstmt = conn.prepareStatement( "insert into news_inf values(null , ? , ?)"); pstmt.setString(1 , "疯狂Java联盟成立了"); pstmt.setString(2 , "疯狂Java地址:www.crazyit.org"); // 执行SQL语句 pstmt.executeUpdate(); // 清理资源,回收数据库连接资源。 if (pstmt != null)pstmt.close(); if (conn != null)conn.close(); } }