spring开发_JDBC操作MySQL数据库

发布时间：2020-12-15 01:52:27 所属栏目：大数据来源：网络整理

导读：com.b510.bean; Person { id; String name; age; String sex; Person( id,String name, age,String sex) { .id = id; .name = name; .age = age; .sex = sex; } Person() { } getId() { id; } setId( id) { .id = id; } String getName() { name; } setName(

com.b510.bean; Person { id; String name; age; String sex; Person( id,String name, age,String sex) { .id = id; .name = name; .age = age; .sex = sex; } Person() { } getId() { id; } setId( id) { .id = id; } String getName() { name; } setName(String name) { .name = name; } getAge() { age; } setAge( age) { .age = age; } String getSex() { sex; } setSex(String sex) { .sex = sex; } }

com.b510.service; java.util.List; com.b510.bean.Person; PersonService { save(Person person); update(Person person); Person getPerson(Integer id); List getPerson(); delete(Integer id); }

com.b510.service.impl; java.util.List; javax.sql.DataSource; org.springframework.jdbc.core.JdbcTemplate; com.b510.bean.Person; com.b510.service.PersonService; PersonServiceBean PersonService { DataSource dataSource; JdbcTemplate jdbcTemplate; setDataSource(DataSource dataSource) { .jdbcTemplate = JdbcTemplate(dataSource); } save(Person person) { jdbcTemplate.update("insert into person(name,age,sex)values(?,?,?)", Object[] { person.getName(),person.getAge(), person.getSex() }, [] { java.sql.Types.VARCHAR, java.sql.Types.INTEGER,java.sql.Types.VARCHAR }); } update(Person person) { jdbcTemplate.update("update person set name=?,age=?,sex=? where id=?", Object[] { person.getName(), person.getSex(),person.getId() }, [] { java.sql.Types.VARCHAR,java.sql.Types.INTEGER, java.sql.Types.VARCHAR,java.sql.Types.INTEGER }); } Person getPerson(Integer id) { Person person = (Person) jdbcTemplate.queryForObject( "select * from person where id=?", Object[] { id }, [] { java.sql.Types.INTEGER }, PersonRowMapper()); person; } @SuppressWarnings("unchecked") List getPerson() { List list = jdbcTemplate.query("select * from person", PersonRowMapper()); list; } delete(Integer id) { jdbcTemplate.update("delete from person where id = ?", [] { java.sql.Types.INTEGER }); } }

com.b510.service.impl; java.sql.ResultSet; java.sql.SQLException; org.springframework.jdbc.core.RowMapper; com.b510.bean.Person; PersonRowMapper RowMapper { @Override Object mapRow(ResultSet set, index) SQLException { Person person = Person(set.getInt("id"),set.getString("name"),set .getInt("age"),set.getString("sex")); person; } }

com.b510.test; java.util.List; org.springframework.context.ApplicationContext; org.springframework.context.support.ClassPathXmlApplicationContext; com.b510.bean.Person; com.b510.service.PersonService; SpringJDBCTest { main(String[] args) { ApplicationContext act = ClassPathXmlApplicationContext("bean.xml"); PersonService personService = (PersonService) act .getBean("personService"); Person person = Person(); person.setName("苏东坡"); person.setAge(21); person.setSex("男"); personService.save(person); List person1 = personService.getPerson(); System.out.println("++++++++得到所有Person"); (Person person2 : person1) { System.out.println(person2.getId() + " " + person2.getName() + " " + person2.getAge() + " " + person2.getSex()); } Person updatePerson = Person(); updatePerson.setName("Divide"); updatePerson.setAge(20); updatePerson.setSex("男"); updatePerson.setId(5); personService.update(updatePerson); System.out.println("******************"); Person onePerson = personService.getPerson(2); System.out.println(onePerson.getId() + " " + onePerson.getName() + " " + onePerson.getAge() + " " + onePerson.getSex()); personService.delete(1); } }

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http: http: http: http: ="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> value="jdbc:mysql://localhost:3307/spring?useUnicode=true&characterEncoding=UTF-8" /> ="org.springframework.jdbc.datasource.DataSourceTransactionManager">

="com.b510.service.impl.PersonServiceBean">

2012-3-9 23:30:57 org.springframework.context.support.AbstractApplicationContext prepareRefresh 信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@1a05308: display name [org.springframework.context.support.ClassPathXmlApplicationContext@1a05308]; startup date [Fri Mar 09 23:30:57 CST 2012]; root of context hierarchy 2012-3-9 23:30:57 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions 信息: Loading XML bean definitions from path resource [bean.xml] 2012-3-9 23:30:58 org.springframework.context.support.AbstractApplicationContext obtainFreshBeanFactory 信息: Bean factory application context [org.springframework.context.support.ClassPathXmlApplicationContext@1a05308]: org.springframework.beans.factory.support.DefaultListableBeanFactory@2bb514 2012-3-9 23:30:58 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons 信息: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@2bb514: defining beans [dataSource,txManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,personService]; root of factory hierarchy ++++++++得到所有Person 2 TomCat 12 女 3 hongten 21 男 4 liufang 21 女 5 Divide 20 男 6 Jone 20 女 7 苏东坡 21 男 ****************** 2 TomCat 12 女

driverClassName=org.gjt.mm.mysql.Driver url=jdbc:mysql: username=root password=root initialSize=1 maxActive=300 maxIdle=2 minIdle=1

相应要修改：

="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> ="org.springframework.jdbc.datasource.DataSourceTransactionManager">

="com.b510.service.impl.PersonServiceBean">

运行结果是相同的：

2012-3-10 0:23:59 org.springframework.context.support.AbstractApplicationContext prepareRefresh 信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@c1b531: display name [org.springframework.context.support.ClassPathXmlApplicationContext@c1b531]; startup date [Sat Mar 10 00:23:59 CST 2012]; root of context hierarchy 2012-3-10 0:23:59 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions 信息: Loading XML bean definitions from path resource [bean.xml] 2012-3-10 0:23:59 org.springframework.context.support.AbstractApplicationContext obtainFreshBeanFactory 信息: Bean factory application context [org.springframework.context.support.ClassPathXmlApplicationContext@c1b531]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1aa57fb 2012-3-10 0:23:59 org.springframework.core.io.support.PropertiesLoaderSupport loadProperties 信息: Loading properties file from path resource [jdbc.properties] 2012-3-10 0:23:59 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons 信息: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1aa57fb: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,personService]; root of factory hierarchy ++++++++得到所有Person 2 TomCat 12 女 3 hongten 21 男 4 liufang 21 女 5 Divide 20 男 6 Jone 20 女 7 苏东坡 21 男 8 苏东坡 21 男 ****************** 2 TomCat 12 女

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!