<?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"> <!-- PropertyOverrideConfigurer是一个容器后处理器,它会读取 属性文件信息,并用这些信息设置覆盖Spring配置文件的数据 --> <bean class= "org.springframework.beans.factory.config.PropertyOverrideConfigurer"> <property name="locations"> <list> <value>dbconn.properties</value> <!-- 如果有多个属性文件,依次在下面列出来 --> </list> </property> </bean> <!-- 定义数据源Bean,使用C3P0数据源实现, 配置该Bean时没有指定任何信息,但Properties文件里的 信息将会直接覆盖该Bean的属性值 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"/> </beans>
dataSource.driverClass=com.mysql.jdbc.Driver dataSource.jdbcUrl=jdbc:mysql://localhost:3306/spring dataSource.user=root dataSource.password=32147
package lee; import javax.sql.DataSource; import java.sql.*; import org.springframework.context.*; import org.springframework.context.support.*; /** * 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 { ApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml"); DataSource ds = (DataSource)ctx.getBean("dataSource"); Connection conn = ds.getConnection(); PreparedStatement pstmt = conn.prepareStatement( "insert into news_inf value(null , ? , ?)"); pstmt.setString(1 , "疯狂Java讲义"); pstmt.setString(2 , "疯狂iOS讲义"); pstmt.executeUpdate(); pstmt.close(); conn.close(); } }