Spring Learning Path (iv) spring to database operations

1, Import Jdbc.jar, TX. Jar Package

2. Testing

 PackageCom.junit;Import Staticorg.junit.assert.*;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.util.List;Importorg.junit.Test;Importorg.springframework.jdbc.core.JdbcTemplate;ImportOrg.springframework.jdbc.core.RowMapper;ImportOrg.springframework.jdbc.datasource.DriverManagerDataSource;ImportCom.ioc.User; Public classText2 {//Add Action@Test Public voidTestadd () {//create objects to get database informationDrivermanagerdatasource DataSource =NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql:///person"); Datasource.setusername ("Root"); Datasource.setpassword ("Root");//Create object, get data sourceJdbcTemplate JDBCTLT =NewJdbcTemplate (dataSource);//Creating SQL statementsString sql = "INSERT into user values (null,?,?)"; introws = jdbctlt.update (sql, "admin2", "123");//rows Execution Success will return 1System.out.println (rows); }    //Modify@Test Public voidtestupdate () {//create objects to get database informationDrivermanagerdatasource DataSource =NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql:///person"); Datasource.setusername ("Root"); Datasource.setpassword ("Root");//Create object, get data sourceJdbcTemplate JDBCTLT =NewJdbcTemplate (dataSource);//Creating SQL statementsString sql = "Update user set uname=?" where id=? "; introws = jdbctlt.update (sql, "History", "2");        SYSTEM.OUT.PRINTLN (rows); }    //Delete@Test Public voidTestdel () {//create objects to get database informationDrivermanagerdatasource DataSource =NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql:///person"); Datasource.setusername ("Root"); Datasource.setpassword ("Root");//Create object, get data sourceJdbcTemplate JDBCTLT =NewJdbcTemplate (dataSource);//Creating SQL statementsString sql = "Delete from user where id=?"; introws = jdbctlt.update (sql, "1");            SYSTEM.OUT.PRINTLN (rows); }    //how many records are queried@Test Public voidTestqery () {//create objects to get database informationDrivermanagerdatasource DataSource =NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql:///person"); Datasource.setusername ("Root"); Datasource.setpassword ("Root");//Create object, get data sourceJdbcTemplate JDBCTLT =NewJdbcTemplate (dataSource);//Creating SQL statementsString sql = "SELECT COUNT (*) from user"; intCount = Jdbctlt.queryforobject (sql, Integer.class);        System.out.println (count); }    //Query Return Object@Test Public voidtestobj () {//create objects to get database informationDrivermanagerdatasource DataSource =NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql:///person"); Datasource.setusername ("Root"); Datasource.setpassword ("Root");//Create object, get data sourceJdbcTemplate JDBCTLT =NewJdbcTemplate (dataSource);//Creating SQL statementsString sql = "SELECT * from user where id=?"; //Inheriting InterfacesUser user = Jdbctlt.queryforobject (sql,NewMyrowmapper (), "3");    SYSTEM.OUT.PRINTLN (user); }    //Query All@Test Public voidTestobjquery () {//create objects to get database informationDrivermanagerdatasource DataSource =NewDrivermanagerdatasource (); Datasource.setdriverclassname ("Com.mysql.jdbc.Driver"); Datasource.seturl ("Jdbc:mysql:///person"); Datasource.setusername ("Root"); Datasource.setpassword ("Root");//Create object, get data sourceJdbcTemplate JDBCTLT =NewJdbcTemplate (dataSource);//Creating SQL statementsString sql = "SELECT * from User"; List<User> list = jdbctlt.query (sql,NewMyrowmapper ());            SYSTEM.OUT.PRINTLN (list); }}classMyrowmapperImplementsRowmapper<user>{@Override PublicUser Maprow (ResultSet RS,intNumthrowsSQLException {//Get the data        intUID = rs.getint ("id"); String uname= Rs.getstring ("uname"); String upwd= Rs.getstring ("Upwd");//Storing DataUser User =NewUser ();        User.setid (UID);        User.setuname (uname);        User.setupwd (UPWD); returnuser; }    }

View Code

Spring Learning Path (iv) spring to database operations