Spring之Spring-jdbc-Template的环境准备-----Spring框架

系统管理员 2024-03-23 23:59 49阅读 0赞

>     <?xml version="1.0" encoding="UTF-8"?>
>     <beans xmlns="http://www.springframework.org/schema/beans"
>            xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>            xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
>         <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
>             <property name="dataSource" ref="dataSource">
>             </property>
>         </bean>
>     
>     
>         <bean id="dataSource" class="com.powernode.spring6.bean.MyDataSource">
>             <property name="driver" value="com.mysql.jdbc.Driver"></property>
>             <property name="url" value="jdbc:mysql://127.0.0.1:8080/spring6"></property>
>             <property name="user" value="root"></property>
>             <property name="password" value="abc123"></property>
>         </bean>
>     </beans>
> 
> <?xml version="1.0" encoding="UTF-8"?>  
> <beans xmlns="http://www.springframework.org/schema/beans"  
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
> xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">  
> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">  
> <property name="dataSource" ref="dataSource">  
> </property>  
> </bean>  
>   
>   
> <bean id="dataSource" class="com.powernode.spring6.bean.MyDataSource">  
> <property name="driver" value="com.mysql.jdbc.Driver"></property>  
> <property name="url" value="jdbc:mysql://127.0.0.1:8080/spring6"></property>  
> <property name="user" value="root"></property>  
> <property name="password" value="abc123"></property>  
> </bean>  
> </beans>

>     package com.powernode.spring6.bean;
>     
>     import javax.sql.DataSource;
>     import java.io.PrintWriter;
>     import java.sql.Connection;
>     import java.sql.DriverManager;
>     import java.sql.SQLException;
>     import java.sql.SQLFeatureNotSupportedException;
>     import java.util.logging.Logger;
>     
>     public class MyDataSource implements DataSource
>     {
>         //自己的数据源,数据源存在的目的是提供getConnection的对象
>         //只要实现了DataSource接口的都是数据源,德鲁伊连接池,C3P0连接池,DBCP连接池都一样,都是实现了DataSource接口
>         private String Driver;
>         private String url;
>         private String user;
>         private String password;
>     
>         public void setDriver(String driver) {
>             Driver = driver;
>         }
>     
>         public void setUrl(String url) {
>             this.url = url;
>         }
>     
>         public void setUser(String user) {
>             this.user = user;
>         }
>     
>         public void setPassword(String password) {
>             this.password = password;
>         }
>     
>         @Override
>         public Connection getConnection() throws SQLException
>         {
>             try
>             {
>                 //注册驱动
>                 Class.forName(Driver);
>                 //获取数据库连接对象
>                 Connection connection = DriverManager.getConnection(url, user, password);
>                 return connection;
>             }
>             catch (ClassNotFoundException e)
>             {
>                 throw new RuntimeException(e);
>             }
>         }
>     
>         @Override
>         public Connection getConnection(String username, String password) throws SQLException {
>             return null;
>         }
>     
>         @Override
>         public PrintWriter getLogWriter() throws SQLException {
>             return null;
>         }
>     
>         @Override
>         public void setLogWriter(PrintWriter out) throws SQLException {
>     
>         }
>     
>         @Override
>         public void setLoginTimeout(int seconds) throws SQLException {
>     
>         }
>     
>         @Override
>         public int getLoginTimeout() throws SQLException {
>             return 0;
>         }
>     
>         @Override
>         public Logger getParentLogger() throws SQLFeatureNotSupportedException {
>             return null;
>         }
>     
>         @Override
>         public <T> T unwrap(Class<T> iface) throws SQLException {
>             return null;
>         }
>     
>         @Override
>         public boolean isWrapperFor(Class<?> iface) throws SQLException {
>             return false;
>         }
>     }
> 
> package com.powernode.spring6.bean;  
>   
> import javax.sql.DataSource;  
> import java.io.PrintWriter;  
> import java.sql.Connection;  
> import java.sql.DriverManager;  
> import java.sql.SQLException;  
> import java.sql.SQLFeatureNotSupportedException;  
> import java.util.logging.Logger;  
>   
> public class MyDataSource implements DataSource  
> \{  
> //自己的数据源,数据源存在的目的是提供getConnection的对象  
> //只要实现了DataSource接口的都是数据源,德鲁伊连接池,C3P0连接池,DBCP连接池都一样,都是实现了DataSource接口  
> private String Driver;  
> private String url;  
> private String user;  
> private String password;  
>   
> public void setDriver(String driver) \{  
> Driver = driver;  
> \}  
>   
> public void setUrl(String url) \{  
> this.url = url;  
> \}  
>   
> public void setUser(String user) \{  
> this.user = user;  
> \}  
>   
> public void setPassword(String password) \{  
> this.password = password;  
> \}  
>   
> @Override  
> public Connection getConnection() throws SQLException  
> \{  
> try  
> \{  
> //注册驱动  
> Class.forName(Driver);  
> //获取数据库连接对象  
> Connection connection = DriverManager.getConnection(url, user, password);  
> return connection;  
> \}  
> catch (ClassNotFoundException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
>   
> @Override  
> public Connection getConnection(String username, String password) throws SQLException \{  
> return null;  
> \}  
>   
> @Override  
> public PrintWriter getLogWriter() throws SQLException \{  
> return null;  
> \}  
>   
> @Override  
> public void setLogWriter(PrintWriter out) throws SQLException \{  
>   
> \}  
>   
> @Override  
> public void setLoginTimeout(int seconds) throws SQLException \{  
>   
> \}  
>   
> @Override  
> public int getLoginTimeout() throws SQLException \{  
> return 0;  
> \}  
>   
> @Override  
> public Logger getParentLogger() throws SQLFeatureNotSupportedException \{  
> return null;  
> \}  
>   
> @Override  
> public <T> T unwrap(Class<T> iface) throws SQLException \{  
> return null;  
> \}  
>   
> @Override  
> public boolean isWrapperFor(Class<?> iface) throws SQLException \{  
> return false;  
> \}  
> \}

>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>org.example</groupId>
>         <artifactId>spring6-009-jdbc-template</artifactId>
>         <version>1.0-SNAPSHOT</version>
>         <packaging>jar</packaging>
>     
>         <repositories>
>             
>             <repository>
>                 <id>repository.spring.milestone</id>
>                 <name>Spring Milestone Repository</name>
>                 <url>https://repo.spring.io/milestone</url>
>             </repository>
>         </repositories>
>         <dependencies>
>             
>             
>             
>             <dependency>
>                 <groupId>org.springframework</groupId>
>                 <artifactId>spring-context</artifactId>
>                 <version>6.1.0-M2</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>org.springframework</groupId>
>                 <artifactId>spring-jdbc</artifactId>
>                 <version>6.1.0-M2</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.30</version>
>             </dependency>
>             
>             <dependency>
>                 <groupId>org.apache.logging.log4j</groupId>
>                 <artifactId>log4j-core</artifactId>
>                 <version>2.19.0</version>
>             </dependency>
>             <dependency>
>                 <groupId>org.apache.logging.log4j</groupId>
>                 <artifactId>log4j-slf4j2-impl</artifactId>
>                 <version>2.19.0</version>
>             </dependency>
>             
>             <dependency>
>                 <groupId>junit</groupId>
>                 <artifactId>junit</artifactId>
>                 <version>4.13.2</version>
>                 <scope>test</scope>
>             </dependency>
>             
>             <dependency>
>                 <groupId>jakarta.annotation</groupId>
>                 <artifactId>jakarta.annotation-api</artifactId>
>                 <version>2.1.1</version>
>             </dependency>
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>     </project>
> 
> <?xml version="1.0" encoding="UTF-8"?>  
> <project xmlns="http://maven.apache.org/POM/4.0.0"  
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
> xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  
> <modelVersion>4.0.0</modelVersion>  
>   
> <groupId>org.example</groupId>  
> <artifactId>spring6-009-jdbc-template</artifactId>  
> <version>1.0-SNAPSHOT</version>  
> <packaging>jar</packaging>  
>   
> <repositories>  
>   
> <repository>  
> <id>repository.spring.milestone</id>  
> <name>Spring Milestone Repository</name>  
> <url>https://repo.spring.io/milestone</url>  
> </repository>  
> </repositories>  
> <dependencies>  
>   
>   
>   
> <dependency>  
> <groupId>org.springframework</groupId>  
> <artifactId>spring-context</artifactId>  
> <version>6.1.0-M2</version>  
> </dependency>  
>   
> <dependency>  
> <groupId>org.springframework</groupId>  
> <artifactId>spring-jdbc</artifactId>  
> <version>6.1.0-M2</version>  
> </dependency>  
>   
> <dependency>  
> <groupId>mysql</groupId>  
> <artifactId>mysql-connector-java</artifactId>  
> <version>8.0.30</version>  
> </dependency>  
>   
> <dependency>  
> <groupId>org.apache.logging.log4j</groupId>  
> <artifactId>log4j-core</artifactId>  
> <version>2.19.0</version>  
> </dependency>  
> <dependency>  
> <groupId>org.apache.logging.log4j</groupId>  
> <artifactId>log4j-slf4j2-impl</artifactId>  
> <version>2.19.0</version>  
> </dependency>  
>   
> <dependency>  
> <groupId>junit</groupId>  
> <artifactId>junit</artifactId>  
> <version>4.13.2</version>  
> <scope>test</scope>  
> </dependency>  
>   
> <dependency>  
> <groupId>jakarta.annotation</groupId>  
> <artifactId>jakarta.annotation-api</artifactId>  
> <version>2.1.1</version>  
> </dependency>  
> </dependencies>  
> <properties>  
> <maven.compiler.source>17</maven.compiler.source>  
> <maven.compiler.target>17</maven.compiler.target>  
> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  
> </properties>  
>   
> </project>

>     package com.powernode.spring6.bean;
>     
>     public class User
>     {
>         private Integer id;
>         private String realName;
>         private Integer age;
>     
>         public User() {
>         }
>     
>         public User(Integer id, String realName, Integer age) {
>             this.id = id;
>             this.realName = realName;
>             this.age = age;
>         }
>     
>         public Integer getId() {
>             return id;
>         }
>     
>         public void setId(Integer id) {
>             this.id = id;
>         }
>     
>         public String getRealName() {
>             return realName;
>         }
>     
>         public void setRealName(String realName) {
>             this.realName = realName;
>         }
>     
>         public Integer getAge() {
>             return age;
>         }
>     
>         public void setAge(Integer age) {
>             this.age = age;
>         }
>     
>         @Override
>         public String toString() {
>             return "User{" +
>                     "id=" + id +
>                     ", realName='" + realName + '\'' +
>                     ", age=" + age +
>                     '}';
>         }
>     }
> 
> package com.powernode.spring6.bean;  
>   
> public class User  
> \{  
> private Integer id;  
> private String realName;  
> private Integer age;  
>   
> public User() \{  
> \}  
>   
> public User(Integer id, String realName, Integer age) \{  
> this.id = id;  
> this.realName = realName;  
> this.age = age;  
> \}  
>   
> public Integer getId() \{  
> return id;  
> \}  
>   
> public void setId(Integer id) \{  
> this.id = id;  
> \}  
>   
> public String getRealName() \{  
> return realName;  
> \}  
>   
> public void setRealName(String realName) \{  
> this.realName = realName;  
> \}  
>   
> public Integer getAge() \{  
> return age;  
> \}  
>   
> public void setAge(Integer age) \{  
> this.age = age;  
> \}  
>   
> @Override  
> public String toString() \{  
> return "User\{" +  
> "id=" + id +  
> ", realName='" + realName + '\\'' +  
> ", age=" + age +  
> '\}';  
> \}  
> \}  
>

>     package com.powernode.spring6.test;
>     
>     import org.junit.Test;
>     import org.springframework.context.ApplicationContext;
>     import org.springframework.context.support.ClassPathXmlApplicationContext;
>     import org.springframework.jdbc.core.JdbcTemplate;
>     
>     public class SpringJDBCTest
>     {
>         @Test
>         public void TestJDBC()
>         {
>             ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");
>             JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
>             System.out.println(jdbcTemplate);
>         }
>     }
> 
> package com.powernode.spring6.test;  
>   
> import org.junit.Test;  
> import org.springframework.context.ApplicationContext;  
> import org.springframework.context.support.ClassPathXmlApplicationContext;  
> import org.springframework.jdbc.core.JdbcTemplate;  
>   
> public class SpringJDBCTest  
> \{  
> @Test  
> public void TestJDBC()  
> \{  
> ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml");  
> JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);  
> System.out.println(jdbcTemplate);  
> \}  
> \}