Package net.test.simple.db._03_update

Examples of net.test.simple.db._03_update.Simple_UpdateJDBCTest

29
30
31
32
33
34
35
36
37
38
39
*/
public class UseMoreDataSource {
    @Test
    public void useMoreDataSource() throws SQLException, IOException {
        //1.构建AppContext
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new MoreDataSourceWarp());
        //2.取得JDBC操作接口
        JdbcTemplate mJDBC = app.getInstance("mysql");
        JdbcTemplate hJDBC = app.getInstance("hsql");
        //3.初始化表
        this.initData(mJDBC, hJDBC);
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
public class MapParam_QueryTest {
    @Test
    public void mapParam_QueryTest() throws IOException, URISyntaxException, InterruptedException, SQLException {
        System.out.println("--->>mapParam_QueryTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        Map<String, String> paramMap = new HashMap<String, String>();
        paramMap.put("id", "76%");
        List<Map<String, Object>> userList = jdbc.queryForList("select * from TB_User where userUUID like :id", paramMap);
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
public class Entity_QueryTest {
    @Test
    public void entity_QueryTest() throws SQLException {
        System.out.println("--->>entity_QueryTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        List<TB_User> userList = jdbc.queryForList("select * from TB_User", TB_User.class);
        HasorUnit.printObjectList(userList);
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
public class SimpleParam_QueryTest {
    @Test
    public void simpleParam_QueryTest() throws IOException, URISyntaxException, InterruptedException, SQLException {
        System.out.println("--->>simpleParam_QueryTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        List<Map<String, Object>> userList = jdbc.queryForList("select * from TB_User where userUUID like ?", "76%");
        HasorUnit.printMapList(userList);
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
public class Callable_Test {
    @Test
    public void testCallable() throws IOException, URISyntaxException, InterruptedException {
        System.out.println("--->>testCallable<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        //
        //        int flowID = jdbc.execute(new ConnectionCallback<Integer>() {
        //            public Integer doInConnection(Connection con) throws SQLException, DataAccessException {
View Full Code Here
28
29
30
31
32
33
34
35
36
public class Simple_UpdateJDBCTest {
    @Test
    public void simple_UpdateJDBCTest() throws SQLException {
        System.out.println("--->>simple_UpdateJDBCTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
public class Simple_InsertJDBCTest {
    @Test
    public void simple_InsertJDBCTest() throws SQLException {
        System.out.println("--->>simple_InsertJDBCTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        System.out.println(jdbc.queryForInt("select count(*) from TB_User where userUUID='deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b'"));
        //
        String insertUser = "insert into TB_User values('deb4f4c8-5ba1-4f76-8b4a-c2be028bf57b','安妮.贝隆','belon','123','belon@hasor.net','2011-06-08 20:08:08');";
View Full Code Here
28
29
30
31
32
33
34
35
36
public class Simple_DeleteJDBCTest {
    @Test
    public void simple_DeleteJDBCTest() throws SQLException {
        System.out.println("--->>simple_DeleteJDBCTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
public class MapBatch_InsertJDBCTest {
    @Test
    public void baseInsertJDBCTest() throws SQLException {
        System.out.println("--->>baseInsertJDBCTest<<--");
        //
        AppContext app = Hasor.createAppContext("net/test/simple/db/jdbc-config.xml", new OneDataSourceWarp());
        JdbcTemplate jdbc = app.getInstance(JdbcTemplate.class);
        //
        String batchInsert = "insert into TB_User values(:ID,:Name,:Account,:Pwd,:Email,:RegTime);";
        //
        showUserCount(jdbc);//显示当前用户总数
View Full Code Here
TOP

Related Classes of net.test.simple.db._03_update.Simple_UpdateJDBCTest

  • com.mchange.v2.c3p0.ComboPooledDataSource
  • net.hasor.core.AppContext
  • net.hasor.core.Settings
  • net.hasor.db.ar.Paginator
  • net.hasor.db.ar.support.DataBase
  • net.hasor.db.jdbc.core.JdbcTemplate
  • net.hasor.db.jdbc.core.JdbcTemplateProvider
  • net.hasor.db.transaction.interceptor.simple.SimpleTranInterceptorModule
  • net.hasor.db.transaction.interceptor.simple.Transactional
  • net.hasor.db.transaction.interceptor.TransactionBinder
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.