1Class.forName("net.sf.log4jdbc.DriverSpy");2 connection =DriverManager.getConnection("jdbc:log4jdbc:oracle:thin:@localhost:1521", user, password);3PreparedStatement select =null;45// 例:6 select = connection.prepareStatement(7"select nvl(INSTRUCTOR_NAME, NAME) from ON_THE_JOB j"8+" left join INSTRUCTOR i on j.INDICATED_BY = i.INSTRUCTOR_ID"9+" left join FRESH_PERSON f on j.MODIFIED_BY = f.EMP_CODE"10+" where PHASE_NO = ? and EXERCISE_NO = ? and TARGET_NO = ? and TEAM = ? and j.LDF = 0"11+" and (INDICATED_BY is not null or MODIFIED_BY is not null)"12);1314 select.setInt(1, target.getPhaseNo());15 select.setInt(2, target.getExerciseNo());16 select.setInt(3, target.getTargetNo());17 select.setString(4, target.getTeam());18ResultSet rs = select.executeQuery();
ログ出力例:
2019-10-12 15:42:22.445 | [http-nio-8090-exec-2] | INFO | jdbc.sqlonly | select nvl(INSTRUCTOR_NAME, NAME) from ON_THE_JOB j left join INSTRUCTOR i on j.INDICATED_BY
= i.INSTRUCTOR_ID left join FRESH_PERSON f on j.MODIFIED_BY = f.EMP_CODE where PHASE_NO = 4
and EXERCISE_NO = 0 and TARGET_NO = 16 and TEAM = 'A' and j.LDF = 0 and (INDICATED_BY is not
null or MODIFIED_BY is not null)