Spring JdbcTemplate Usage Summary

1. Querying object

     Public Classify Queryclassifbyid (int  ID) {        String sql= "SELECT * from T_classify where id=?" ;         New object[] {ID};         = Jdbctemplate.queryforobject (sql, args, parameterizedbeanpropertyrowmapper.newinstance (classify.  Class));         return classify;    }

2. Query List

     Public List<classify> Getallmenu () {        String sql= "SELECT * from t_classify";        List<Classify> list = jdbctemplate.query (sql, Parameterizedbeanpropertyrowmapper.newinstance (classify.  Class));         return list;    }

3. Number of query records

     Public int GetCount () {        String sql= "SELECT count (*) from t_classify";         return jdbctemplate.queryforint (SQL);    }

4. Get self-growth primary key

     Public intInsertFinalNews News) {        FinalString sql = "INSERT into T_news (title, content)" + "VALUES (?,?)"; Keyholder Keyholder=NewgeneratedKeyHolder (); Jdbctemplate.update (NewPreparedStatementCreator () {@Override PublicPreparedStatement createpreparedstatement (Connection conn)throwsSQLException {preparedstatement ps=conn.preparestatement (SQL); Ps.setstring (1, News.gettitle ()); Ps.setstring (2, News.getcontent ());returnPS;        }},keyholder); returnKeyholder.getkey (). Intvalue (); }

Spring JdbcTemplate Usage Summary