|
后臺(tái)數(shù)據(jù)庫的訪問必須使用后臺(tái)接口實(shí)現(xiàn)的方法，并且配置文件，見NC502后臺(tái)接口的使用 一 BaseDAO new BaseDAO(). insertObject() 二 PersistenceManager A.JdbcSession的創(chuàng)建 PersistenceManager sessionManager= PersistenceManager. getInstance ()； try { JdbcSession session = sessionManager. getJdbcSession ()； //數(shù)據(jù)庫訪問操作 session.insert(…); session.update(…); session.query(…); } catch (DbException e) { } finally { sessionManager. release ();//需要關(guān)閉會(huì)話 } B.JdbcSession基本操作 1.無參查詢 String sql = "select * from bd_deptdoc"; //構(gòu)造查詢語句 List list = (List) session.executeQuery(sql, new ArrayListProcessor()); 2.有參查詢 String sql = "select * from bd_deptdoc where dept_code=?"; SQLParameter param = new SQLParameter(); //構(gòu)造參數(shù)對象 param.addParam(“aaa”); //添加參數(shù) List list=(List) session.executeQuery(sql, param, new ArrayListProcessor()); 3.無參更新 String sql = "update bd_deptdoc set dept_code =‘a(chǎn)aa’ where dept_code=‘bbb’"; session.executeUpdate(sql); 4.有參更新 String sql = "update bd_deptdoc set dept_code =‘a(chǎn)aa’ where dept_code=?”; SQLParameter param = new SQLParameter(); //構(gòu)造參數(shù)對象 param.addParam(“bbb”); //添加參數(shù) session.executeUpdate(sql, param); 5.無參批量更新 String sql = "update bd_deptdoc set dept_code =‘a(chǎn)aa’ where dept_code=‘bbb’"; session.addBatch(sql); //添加需要執(zhí)行的同構(gòu)SQL int rows = session.executeBatch(); //執(zhí)行 6.有參批量更新 String sql = "update bd_deptdoc set dept_code =‘a(chǎn)aa’ where dept_code=?”; SQLParameter param = new SQLParameter(); //構(gòu)造參數(shù)對象 param.addParam(“bbb”); //添加參數(shù) session.addBatch(sql, param); //添加需要執(zhí)行的同構(gòu)SQL int rows = session.executeBatch(); //執(zhí)行 C.特殊參數(shù) 1. Null參數(shù) param.addNullParam(java.sql.Types.INTEGER); 2. Blob參數(shù) param.addBlobParam (new Object()); 3. Clob參數(shù) param.addClobParam (new String()); |
|
|
