1.建数据库springmybaitis(多了一个i) ,再建表名为user 属性id username password
package com.itcast.pojo;
public class User {
private int id;
private String username;
private String password;
public User(){}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String toString(){
return "User[id="+id+" , username="+username+" , password="+password+"]";
}
}
package com.itcast.dao; import com.itcast.pojo.User; public interface UserDao { public void addUser(User user); /* public User getUser(User user); public void updateUser(User user); public void deleteUser(int UserId);*/ }
UserDao.xml
applicationContext.xml<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.itcast.dao.UserDao"> <insert id="addUser" parameterType="com.itcast.pojo.User" > INSERT INTO user (id,username,password) VALUES (#{id},#{username},#{password}) </insert> </mapper>
db.properties 这里数据库名是springmybaitis 多了一个i<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd"> <context:property-placeholder location="classpath:db.properties" /> <!-- 数据库连接池 --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driver}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="maxActive" value="10" /> <property name="maxIdle" value="5" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:mybatis-config.xml"></property> </bean> <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="com.itcast.dao.UserDao"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> </beans>
jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/springmybaitis?characterEncoding=utf-8 jdbc.username=root jdbc.password=admin
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <mappers> <mapper resource="com/itcast/dao/UserDao.xml"/> </mappers> </configuration>
再来一个测试类package com.itcast.test; import org.junit.Test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.itcast.dao.UserDao; import com.itcast.pojo.User; public class TestUser { @Test public void testadd() { ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml"); UserDao userDao=(UserDao) ac.getBean("userDao"); User user=new User(); //添加两条数据 user.setId(1); user.setUsername("NBA"); user.setPassword("AAA"); userDao.addUser(user); user.setId(2); user.setUsername("CBA"); user.setPassword("123"); userDao.addUser(user); System.out.println("添加成功");