Mybatis test example

Package com. njupt. test;

Import java. Io. inputstream;

Import java. util. hashmap;

Import java. util. List;

Import java. util. Map;

Import org. Apache. ibatis. Io. Resources;

Import org. Apache. ibatis. session. sqlsession;

Import org. Apache. ibatis. session. sqlsessionfactory;

Import org. Apache. ibatis. session. sqlsessionfactorybuilder;

Import org. JUnit. test;

Import com. njupt. pojo. user;

Public class test1 {

// The query result is returned in the form of an entity


@ Test


Public void test1 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );


Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

User u = session. selectone ("com. njupt. pojo. User. selectuserbyid", "0001 ");

System. Out. println (U. GetUserName ());


}

@ Test


Public void test6 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );


Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

Session. Delete ("com. njupt. pojo. User. deleteuserbyid", "0004 ");

Session. Commit ();


}

@ Test


Public void Test2 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );

Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

List <user> Users = session. selectlist ("com. njupt. pojo. User. selectallusers ");

For (User U: Users ){


System. Out. println (U. GetUserName ());


}


}

@ Test


Public void test3 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );


Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

User u = new user ();


U. setid ("003 ");


U. setusername ("liushishi2 ");


U. setaddress ("beijing1 ");

Int I = session. insert ("com. njupt. pojo. User. insertuser", U );





// Be sure to have it; otherwise, the transaction has not been committed.


Session. Commit ();

// Print the number of affected rows in the database


System. Out. println (I );


}

// The query result is returned as a map.


@ Test


Public void test4 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );

Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

Map M = session. selectone ("com. njupt. pojo. User. selectuserbyidformap", "003 ");

System. Out. println (m );

}

@ Test


Public void test5 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );


Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );


Sqlsession session = SF. opensession ();

Map map = new hashmap ();

Map. Put ("ID", "0004 ");


Map. Put ("username1", "liuyifei1 ");


Map. Put ("Address", "shanghai1 ");

Session. insert ("com. njupt. pojo. User. insertuserformap", MAP );

Session. Commit ();

}

@ Test


Public void test7 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );


Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

User u = new user ();

U. setid ("003 ");


U. setusername ("hjd ");


U. setaddress ("Maoming ");

Session. Update ("com. njupt. pojo. User. updateuserbyid", U );


Session. Commit ();


}

@ Test


Public void test8 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );


Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

Map M = new hashmap ();

M. Put ("ID", "003 ");


M. Put ("username2", "hjd2 ");


M. Put ("Address", "Guangdong ");

Session. Update ("com. njupt. pojo. User. updateuserbyidformap", M );


Session. Commit ();

}

@ Test


Public void test9 () throws exception {


String resource = "sqlmapconfig. xml ";


Inputstream = resources. getresourceasstream (Resource );

Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

User u = new user ();

U. setid ("0001 ");


U. setaddress ("Guangdong ");


List <user> Users = session. selectlist ("com. njupt. pojo. User. selectuserbycondition", U );

For (User: Users ){


System. Out. println (user. GetUserName ());


}


}

@ Test


Public void test10 () throws exception {


String resource = "sqlmapconfig. xml ";

Inputstream = resources. getresourceasstream (Resource );

Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

User u = new user ();

U. setid ("0001 ");

//
U. setaddress ("Guangdong ");


List <user> Users = session. selectlist ("com. njupt. pojo. User. selectuserbycondition1", U );

For (User: Users ){


System. Out. println (user. GetUserName ());


}


}

@ Test


Public void test11 () throws exception {


String resource = "sqlmapconfig. xml ";

Inputstream = resources. getresourceasstream (Resource );

Sqlsessionfactory Sf = new sqlsessionfactorybuilder (). Build (inputstream );

Sqlsession session = SF. opensession ();

User u = new user ();

U. setusername ("hjd2 ");

List <user> Users = session. selectlist ("com. njupt. pojo. User. selectuserbycondition1", U );

For (User: Users ){


System. Out. println (user. GetUserName ());


}


}

}