编辑代码

class Main {
	public static void main(String[] args) {

        		StringBuffer sql = new StringBuffer();
		sql.append("SELECT");
		sql.append("(SELECT NAME FROM org_member WHERE id = SENDER_ID) sendername,");
		sql.append("(SELECT LOGIN_NAME FROM org_principal WHERE MEMBER_ID = SENDER_ID) senderloginname,");
		sql.append("(SELECT name FROM ORG_UNIT where id=(select ORG_DEPARTMENT_ID from ORG_MEMBER where id=SENDER_ID)) dept,");
		sql.append("DATE_FORMAT(CREATE_DATE, '%Y-%m-%d %H:%i:%s') senderdate,");
		sql.append("DATE_FORMAT(receive_time, '%Y-%m-%d %H:%i:%s') receivetime,");
		sql.append("SUBJECT title,");
		sql.append("(SELECT NAME FROM org_member WHERE id = MEMBER_ID) affname,");
		sql.append("(SELECT LOGIN_NAME FROM org_principal WHERE MEMBER_ID = a.MEMBER_ID) affloginname,");
		sql.append(" FROM CTP_AFFAIR a WHERE STATE = 3 and app = 1");
			sql.append(" AND MEMBER_ID in (SELECT MEMBER_ID FROM org_principal WHERE LOGIN_NAME = ?) ");

			sql.append(" AND SUBJECT like '%11%'");

        //JSRUN引擎2.0，支持多达30种语言在线运行，全仿真在线交互输入输出。
		System.out.println(sql.toString());
	}
}