Springjdbc-namedparameterjdbctemplate Processing in Query

Package Com.test;import Java.sql.resultset;import Java.sql.sqlexception;import java.util.arraylist;import Java.util.hashmap;import Java.util.list;import Java.util.map;import org.springframework.jdbc.core.JdbcTemplate; Import Org.springframework.jdbc.core.rowmapper;import Org.springframework.jdbc.core.namedparam.beanpropertysqlparametersource;import Org.springframework.jdbc.core.namedparam.mapsqlparametersource;import Org.springframework.jdbc.core.namedparam.namedparameterjdbctemplate;import com.java.common.util.BeanFactory; Import com.java.ssmb.entity.domain.userinfo;/** * Using namedparameterjdbctemplate query criteria SQL in Query and javabean query * JdbcTemplate is present in the General Spring project, * Examples are created using jdbctemplate namedparameterjdbctemplate * * @author Yeshun * */public class Namedpara meterjdbctemplatetest {private namedparameterjdbctemplate namedjdbctemplate;public namedparameterjdbctemplatetest ( {JdbcTemplate JdbcTemplate = Beanfactory.getbean ("JdbcTemplate", jdbctemplate.class); this.namedjdbctemplate = new NamedparameterjdbctEmplate (JdbcTemplate);} /* * Use map query */public void Querylistbymap (list<string> userids) {String sql = "SELECT * from user_table u where u.use r_id in (: UserIDs) "; map<string,object> parameters = new hashmap<string,object> ();p arameters.put ("UserIDs", UserIDs); list<map<string,object>> list = namedjdbctemplate.queryforlist (sql, parameters); for (Map<string, Object> map:list) {System.out.println ("-------------------"); System.out.println (Map.get ("user_id")); System.out.println (Map.get ("user_name"));}} /* * Use Mapsqlparametersource query */public void Querylistbymapsqlparametersource (list<string> userids) {String sql = "SELECT * from User_table u where u.user_id in (: UserIDs)"; Mapsqlparametersource parameters = new Mapsqlparametersource ();p arameters.addvalue ("UserIDs", UserIDs); list<map<string,object>> list = namedjdbctemplate.queryforlist (sql, parameters); for (Map<string, Object> map:list) {System.out.println ("-------------------"); System. OUT.PRINTLN (Map.get ("user_id")); System.out.println (Map.get ("user_name"));}} /* * Use Beanpropertysqlparametersource query, JavaBean query */public void Querysinglebybeanpropertysqlparametersource () {//: UserID--corresponds to userinfo.useridstring sql = "SELECT * from user_table u where u.user_id =: UserId"; UserInfo user = new UserInfo (); User.setuserid ("User0"); Beanpropertysqlparametersource parameters = new Beanpropertysqlparametersource (user); map<string,object> map = namedjdbctemplate.queryformap (sql, parameters); System.out.println (Map.get ("user_id")); System.out.println (Map.get ("user_name"));} /* * Query single return value */public void Querysingle (list<string> userids) {String sql = "SELECT COUNT (*) from user_table u where u . user_id in (: UserIDs) "; Mapsqlparametersource parameters = new Mapsqlparametersource ();p arameters.addvalue ("UserIDs", UserIDs); Integer count = Namedjdbctemplate.queryforobject (sql, parameters, integer.class);//queryForInt//integer count = Namedjdbctemplate.queryforint (sql, parameters); SystEm.out.println (count);} /* * Use Mapsqlparametersource query, use RowMapper to return */public void Queryusersbymapsqlparametersource (list<string> userids) {String sql = "SELECT * from User_table u where u.user_id in (: UserIDs)"; Mapsqlparametersource parameters = new Mapsqlparametersource ();p arameters.addvalue ("UserIDs", UserIDs); List<userinfo> userlist = namedjdbctemplate.query (sql, Parameters,new rowmapper<userinfo> () {@ Overridepublic UserInfo Maprow (ResultSet rs, int rowNum) throws SQLException {//TODO auto-generated Method Stubuserinfo u Ser = new UserInfo (); User.setuserid (rs.getstring ("user_id")); User.setusername (rs.getstring ("user_name")); User.setpassword (rs.getstring ("password")); return user;}}); for (UserInfo userinfo:userlist) {System.out.println (Userinfo.getuserid () + "--" +userinfo.getusername ());}} public static void Main (string[] args) {namedparameterjdbctemplatetest test = new Namedparameterjdbctemplatetest (); list<string> userids= new arraylist<string> (); USERIDS.ADD ("User0"); Userids.add ("user1"); Userids.add ("user2"); Userids.add ("User3");//test.querylistbymap (userids);// Test.querylistbymapsqlparametersource (UserIDs);//test.querysingle (userids);// Test.querysinglebybeanpropertysqlparametersource (); Test.queryusersbymapsqlparametersource (UserIDs);}}