使用端信息
pom.xml
< ? 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> Ipersistence_test< / artifactId>
< version> 1.0 - SNAPSHOT< / version>
< properties>
< project. build. sourceEncoding> UTF- 8 < / project. build. sourceEncoding>
< maven. compiler. encoding> UTF- 8 < / maven. compiler. encoding>
< java. version> 1.8 < / java. version>
< maven. compiler. source> 1.8 < / maven. compiler. source>
< maven. compiler. target> 1.8 < / maven. compiler. target>
< / properties>
< dependencies>
< dependency>
< groupId> com. lwl< / groupId>
< artifactId> IPersistence< / artifactId>
< version> 1.0 - SNAPSHOT< / version>
< / dependency>
< dependency>
< groupId> com. lwl< / groupId>
< artifactId> Ipersistence< / artifactId>
< version> 1.0 - SNAPSHOT< / version>
< scope> test< / scope>
< / dependency>
< / dependencies>
< build>
< plugins>
< plugin>
< groupId> org. apache. maven. plugins< / groupId>
< artifactId> maven- surefire- plugin< / artifactId>
< configuration>
< testFailureIgnore> true < / testFailureIgnore>
< / configuration>
< / plugin>
< / plugins>
< / build>
< / project>
sqlMappperConfig.xml
< configuration>
< dataSource>
< property name = "driverClass" value = "com.mysql.jdbc.Driver" > < / property>
< property name = "jdbcUrl" value = "jdbc:mysql://192.168.2.134:3306/lagou" > < / property>
< property name = "username" value = "root" > < / property>
< property name = "password" value = "root" > < / property>
< / dataSource>
< mapper resource = "UserMapper.xml" / >
< / configuration>
UserMapper.xml
< mapper namespace = "com.lwl.pojo.dao.IUserDao" >
< ! -- sql唯一标示 namespace. statementId-- >
< select id = "findAll" resultType = "com.lwl.pojo.User" >
select * from user
< / select>
< select id= "findByCondition" paramterType= "com.lwl.pojo.User" resultType= "com.lwl.pojo.User" >
select * from user where id = #{ id} and username = #{ username}
< / select>
< select id= "update" paramterType= "com.lwl.pojo.User" resultType= "int" >
update user set username = #{ username} where id = #{ id}
< / select>
< select id= "creat" paramterType= "com.lwl.pojo.User" resultType= "int" >
insert into user ( id, username) VALUES ( #{ id} , #{ username} )
< / select>
< select id= "delete" paramterType= "com.lwl.pojo.User" resultType= "int" >
delete from user where id = #{ id}
< / select>
< / mapper>
实体类User
package com. lwl. pojo;
public class User {
private Integer id;
private String username;
public Integer getId ( ) {
return id;
}
public void setId ( Integer id) {
this . id = id;
}
public String getUsername ( ) {
return username;
}
public void setUsername ( String username) {
this . username = username;
}
@Override
public String toString ( ) {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
'}' ;
}
}
DAO层
package com. lwl. pojo. dao;
import com. lwl. pojo. User;
import org. dom4j. DocumentException;
import java. beans. PropertyVetoException;
import java. util. List;
public interface IUserDao {
public List< User> findAll ( ) throws Exception;
public User findByCondition ( User user) throws Exception;
void update ( User user) throws Exception;
void creat ( User user) throws Exception;
void delete ( User user) throws Exception;
}
测试类IPersistenceTest
package com. lwl. test;
import com. lwl. io. Resource;
import com. lwl. pojo. User;
import com. lwl. pojo. dao. IUserDao;
import com. lwl. sqlSession. SqlSession;
import com. lwl. sqlSession. SqlSessionFactory;
import com. lwl. sqlSession. SqlSessionFactoryBuilder;
import org. junit. Test;
import java. io. InputStream;
import java. util. List;
public class IPersistenceTest {
@Test
public void testCreat ( ) throws Exception {
InputStream resourceAsStream = Resource. getResourceAsStream ( "sqlMapperConfig.xml" ) ;
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder ( ) . build ( resourceAsStream) ;
SqlSession sqlsession = sqlSessionFactory. openSession ( ) ;
IUserDao userDao = sqlsession. getMapper ( IUserDao. class ) ;
User user = new User ( ) ;
user. setId ( 3 ) ;
user. setUsername ( "张三" ) ;
userDao. creat ( user) ;
}
@Test
public void testFindAll ( ) throws Exception {
InputStream resourceAsStream = Resource. getResourceAsStream ( "sqlMapperConfig.xml" ) ;
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder ( ) . build ( resourceAsStream) ;
SqlSession sqlsession = sqlSessionFactory. openSession ( ) ;
IUserDao userDao = sqlsession. getMapper ( IUserDao. class ) ;
List< User> all = userDao. findAll ( ) ;
for ( User user : all) {
System. out. println ( user) ;
}
}
@Test
public void testFindByCondition ( ) throws Exception {
InputStream resourceAsStream = Resource. getResourceAsStream ( "sqlMapperConfig.xml" ) ;
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder ( ) . build ( resourceAsStream) ;
SqlSession sqlsession = sqlSessionFactory. openSession ( ) ;
IUserDao userDao = sqlsession. getMapper ( IUserDao. class ) ;
User user = new User ( ) ;
user. setId ( 3 ) ;
user. setUsername ( "张三" ) ;
User byCondition = userDao. findByCondition ( user) ;
System. out. println ( byCondition) ;
}
@Test
public void testUpdate ( ) throws Exception {
InputStream resourceAsStream = Resource. getResourceAsStream ( "sqlMapperConfig.xml" ) ;
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder ( ) . build ( resourceAsStream) ;
SqlSession sqlsession = sqlSessionFactory. openSession ( ) ;
IUserDao userDao = sqlsession. getMapper ( IUserDao. class ) ;
User user = new User ( ) ;
user. setId ( 3 ) ;
user. setUsername ( "李四" ) ;
userDao. update ( user) ;
}
@Test
public void testDelete ( ) throws Exception {
InputStream resourceAsStream = Resource. getResourceAsStream ( "sqlMapperConfig.xml" ) ;
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder ( ) . build ( resourceAsStream) ;
SqlSession sqlsession = sqlSessionFactory. openSession ( ) ;
IUserDao userDao = sqlsession. getMapper ( IUserDao. class ) ;
User user = new User ( ) ;
user. setId ( 3 ) ;
userDao. delete ( user) ;
}
}