private TypeHandler resolveTypeHandler( TypeHandlerFactory typeHandlerFactory, Class clazz, String propertyName, String javaType, String jdbcType) { try { // 我加上的 DEBUG.P(this, "resolveTypeHandler(5)"); TypeHandler handler = null; if (clazz == null) { // Unknown handler = typeHandlerFactory.getUnkownTypeHandler(); } else if (DomTypeMarker.class.isAssignableFrom(clazz)) { // DOM handler = typeHandlerFactory.getTypeHandler(String.class, jdbcType); } else if (java.util.Map.class.isAssignableFrom(clazz)) { // Map if (javaType == null) { handler = typeHandlerFactory .getUnkownTypeHandler(); // BUG 1012591 - // typeHandlerFactory.getTypeHandler(java.lang.Object.class, jdbcType); } else { try { javaType = typeHandlerFactory.resolveAlias(javaType); Class javaClass = Resources.classForName(javaType); handler = typeHandlerFactory.getTypeHandler(javaClass, jdbcType); } catch (Exception e) { throw new SqlMapException("Error. Could not set TypeHandler. Cause: " + e, e); } } } else if (typeHandlerFactory.getTypeHandler(clazz, jdbcType) != null) { // Primitive handler = typeHandlerFactory.getTypeHandler(clazz, jdbcType); } else { // JavaBean if (javaType == null) { Class type = PROBE.getPropertyTypeForGetter(clazz, propertyName); handler = typeHandlerFactory.getTypeHandler(type, jdbcType); } else { try { javaType = typeHandlerFactory.resolveAlias(javaType); Class javaClass = Resources.classForName(javaType); handler = typeHandlerFactory.getTypeHandler(javaClass, jdbcType); } catch (Exception e) { throw new SqlMapException("Error. Could not set TypeHandler. Cause: " + e, e); } } } return handler; } finally { // 我加上的 DEBUG.P(0, this, "resolveTypeHandler(5)"); } }
public static void init(JPasswordField fpasswd) { try { String resource = "artemis_sqlmap/chado_iBatis_config.xml"; Reader reader = Resources.getResourceAsReader(resource); Properties properties = null; if (System.getProperty("chado") != null) { String url = System.getProperty("chado"); int index = url.indexOf("?"); int index2 = url.indexOf("user="******"://"); if (index3 < 0) index3 = 0; else index3 = index3 + 3; properties.put("chado", url.substring(index3, index)); if (index2 < 0) properties.put("username", url.substring(index + 1)); else properties.put("username", url.substring(index2 + 5)); if (fpasswd != null && fpasswd.getPassword().length > 0) properties.put("password", new String(fpasswd.getPassword())); } sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader, properties); } catch (Exception e) { // If you get an error at this point, it doesnt matter what it was. It is going to be // unrecoverable and we will want the app to blow up hard so we are aware of the // problem. You should always log such errors and re-throw them in such a way that // you can be made immediately aware of the problem. e.printStackTrace(); throw new RuntimeException("Error initializing DbSqlConfig class. Cause: " + e); } }
// 생성자 public writeAction() throws IOException { reader = Resources.getResourceAsReader("sqlMapConfig.xml"); // sqlMapConfig.xml 파일의 설정내용을 가져온다. sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); // sqlMapConfig.xml의 내용을 적용한 sqlMapper 객체 생성. reader.close(); }
@SuppressWarnings("unchecked") public static void main(String[] args) throws IOException { String config = "sqlMapConfig.xml"; Reader reader = Resources.getResourceAsReader(config); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); ClusterViewModel cViewModel = new ClusterViewModel(); cViewModel.setId(Rpid.generate()); try { sqlMap.insert("insertClusterViewModel", cViewModel); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } List<ClusterViewModel> list; try { list = sqlMap.queryForList("checkFromCluster"); for (ClusterViewModel clusterViewModel : list) { System.out.println(clusterViewModel); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }
/* * Required by interface * * @param properties required by interface * @see com.ibatis.dao.engine.transaction.DaoTransactionManager */ public void configure(Properties properties) { try { Reader reader = null; if (properties.containsKey("SqlMapConfigURL")) { reader = Resources.getUrlAsReader((String) properties.get("SqlMapConfigURL")); } else if (properties.containsKey("SqlMapConfigResource")) { reader = Resources.getResourceAsReader((String) properties.get("SqlMapConfigResource")); } else { throw new DaoException( "SQLMAP transaction manager requires either 'SqlMapConfigURL' or 'SqlMapConfigResource' to be specified as a property."); } client = SqlMapClientBuilder.buildSqlMapClient(reader, properties); } catch (IOException e) { throw new DaoException("Error configuring SQL Map. Cause: " + e); } }
public static void main(String[] args) throws IOException, SQLException { String resource = "ibatis/sqlmap-config.xml"; Reader reader = Resources.getResourceAsReader(resource); SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader); HashMap<String, String> param = new HashMap<String, String>(); param.put("a", "1"); Object obj = sqlmap.queryForObject("testSelectAs", param); System.out.println(obj); }
static { try { Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); client = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (Exception e) { System.out.println("在userdao的static里面出错了"); e.printStackTrace(); } }
static { try { String resource = "SqlMapConfig.xml"; Reader reader = Resources.getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("Error initializing IbatisHelper class. Cause : " + e); } }
/** * Singleton SqlMapClient 객체를 리턴 * * @return SqlMapClient */ public static SqlMapClient getSqlMapClient() { if (null == sqlMapClient) { try { Reader reader = Resources.getResourceAsReader("SqlMapConf.xml"); sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); } catch (Exception e) { throw new RuntimeException( "Something bad happened while building the SqlMapClient instance." + e, e); } } return sqlMapClient; }
@Before public void setUp() throws Exception { Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml"); SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); LegacyBankService legacyBankService = new IBatisLegacyBankService(sqlMapClient); KnowledgeBase knowledgeBase = DroolsHelper.createKnowledgeBase("etl-iBatis.drl"); etlBankService = new DataTransformationServiceImpl(); // etlBankService.setBankingService(new BankingServiceImpl()); etlBankService.setLegacyBankService(legacyBankService); etlBankService.setReportFactory(new DefaultReportFactory()); etlBankService.setKnowledgeBase(knowledgeBase); }
@GET @Produces(MediaType.APPLICATION_JSON) @Path("{ledger_id}") public Ledger getUser(@PathParam("ledger_id") long ledger_id) { Ledger objLedger = new Ledger(); objLedger.setLedger_id(ledger_id); try { Reader reader = Resources.getResourceAsReader("./dao/SqlMapConfig.xml"); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); objLedger = (Ledger) sqlMap.queryForObject("Ledger.getLedgerById", objLedger); } catch (Exception e) { e.printStackTrace(); } return objLedger; }
@GET @Produces(MediaType.APPLICATION_JSON) @Path("/groups") public List<AccountGroup> getAccountGroups() { List<AccountGroup> objAccountGroupList = null; try { Reader reader = Resources.getResourceAsReader("./dao/SqlMapConfig.xml"); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); objAccountGroupList = (List<AccountGroup>) sqlMap.queryForList("Ledger.getAccountGroups", null); } catch (Exception e) { e.printStackTrace(); } return objAccountGroupList; }
@GET @Produces(MediaType.APPLICATION_JSON) @Path("/list/{company_id}/{type}") public List<Ledger> getLedgers( @PathParam("company_id") long company_id, @PathParam("type") String type) { List<Ledger> objLedgerList = null; Ledger objLedger = new Ledger(); objLedger.setCompany_id(company_id); try { Reader reader = Resources.getResourceAsReader("./dao/SqlMapConfig.xml"); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); if (type.equals("all")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getLedgersByCompanyId", objLedger); } else if (type.equals("as")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getAssetsByCompanyId", objLedger); } else if (type.equals("li")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getLiabilitiesByCompanyId", objLedger); } else if (type.equals("de")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getDirectExpensesByCompanyId", objLedger); } else if (type.equals("di")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getDirectIncomeByCompanyId", objLedger); } else if (type.equals("ie")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getIndirectExpensesByCompanyId", objLedger); } else if (type.equals("ii")) { objLedgerList = (List<Ledger>) sqlMap.queryForList("Ledger.getIndirectIncomeByCompanyId", objLedger); } } catch (Exception e) { e.printStackTrace(); } return objLedgerList; }
@POST @Consumes(MediaType.APPLICATION_JSON) @Produces(MediaType.TEXT_PLAIN) public String insertLedger(Ledger objLedger) { try { Reader reader = Resources.getResourceAsReader("./dao/SqlMapConfig.xml"); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); Ledger temp = (Ledger) sqlMap.queryForObject("Ledger.getDuplicateLedger", objLedger); if (temp != null) { return "Sorry, Ledger name already exists.! Kindly try some other name."; } sqlMap.startTransaction(); sqlMap.insert("Ledger.insertLedger", objLedger); sqlMap.commitTransaction(); sqlMap.endTransaction(); } catch (Exception e) { e.printStackTrace(); return "Some problem occured while creating New Ledger. Kindly try again!"; } return "New Ledger created successfully"; }
@PUT @Consumes(MediaType.APPLICATION_JSON) @Produces(MediaType.TEXT_PLAIN) public String updateLedger(Ledger objLedger) { try { Reader reader = Resources.getResourceAsReader("./dao/SqlMapConfig.xml"); SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); Ledger temp = (Ledger) sqlMap.queryForObject("Ledger.getLedgerById", objLedger); if (temp == null) { return "Ledger can not be identified. Try logging in again.!"; } sqlMap.startTransaction(); sqlMap.update("Ledger.updateByLedgerId", objLedger); sqlMap.commitTransaction(); sqlMap.endTransaction(); } catch (Exception e) { e.printStackTrace(); return "Some problem occured while updating Ledger information. Kindly try again!"; } return "Information updated successfully"; }
private ParameterMapping newParseMapping( String token, Class parameterClass, TypeHandlerFactory typeHandlerFactory) { ParameterMapping mapping = new ParameterMapping(); // #propertyName,javaType=string,jdbcType=VARCHAR,mode=IN,nullValue=N/A,handler=string,numericScale=2# StringTokenizer paramParser = new StringTokenizer(token, "=,", false); mapping.setPropertyName(paramParser.nextToken()); while (paramParser.hasMoreTokens()) { String field = paramParser.nextToken(); if (paramParser.hasMoreTokens()) { String value = paramParser.nextToken(); if ("javaType".equals(field)) { value = typeHandlerFactory.resolveAlias(value); mapping.setJavaTypeName(value); } else if ("jdbcType".equals(field)) { mapping.setJdbcTypeName(value); } else if ("mode".equals(field)) { mapping.setMode(value); } else if ("nullValue".equals(field)) { mapping.setNullValue(value); } else if ("handler".equals(field)) { try { value = typeHandlerFactory.resolveAlias(value); Object impl = Resources.instantiate(value); if (impl instanceof TypeHandlerCallback) { mapping.setTypeHandler(new CustomTypeHandler((TypeHandlerCallback) impl)); } else if (impl instanceof TypeHandler) { mapping.setTypeHandler((TypeHandler) impl); } else { throw new SqlMapException( "The class " + value + " is not a valid implementation of TypeHandler or TypeHandlerCallback"); } } catch (Exception e) { throw new SqlMapException( "Error loading class specified by handler field in " + token + ". Cause: " + e, e); } } else if ("numericScale".equals(field)) { try { Integer numericScale = Integer.valueOf(value); if (numericScale.intValue() < 0) { throw new SqlMapException( "Value specified for numericScale must be greater than or equal to zero"); } mapping.setNumericScale(numericScale); } catch (NumberFormatException e) { throw new SqlMapException("Value specified for numericScale is not a valid Integer"); } } else { throw new SqlMapException( "Unrecognized parameter mapping field: '" + field + "' in " + token); } } else { throw new SqlMapException( "Incorrect inline parameter map format (missmatched name=value pairs): " + token); } } if (mapping.getTypeHandler() == null) { TypeHandler handler; if (parameterClass == null) { handler = typeHandlerFactory.getUnkownTypeHandler(); } else { handler = resolveTypeHandler( typeHandlerFactory, parameterClass, mapping.getPropertyName(), mapping.getJavaTypeName(), mapping.getJdbcTypeName()); } mapping.setTypeHandler(handler); } return mapping; }
public MainBean() throws Exception { reader = Resources.getResourceAsReader("sqlMapConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); }
// DB커넥트 생성자 public ImprovementCaseEdit() throws IOException { reader = Resources.getResourceAsReader("sqlMapConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); }
// DB커넥트 생성자 public TrainingEventView() throws IOException { reader = Resources.getResourceAsReader("sqlMapConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); }