比较牛逼的插入SQL语句

  MessageDaoImpl.java$saveMessageReceiverWithGroup
   310行
   插入的时候检查数据库是否存在该记录

   //插入消息记录
		            String insertSql = "INSERT INTO MS_RECEIVER(MSG_ID,RECEIVER_ID,RECEIVE_TIME,RECEIVE_STATE,RECEIVER_NAME,RECEIVE_TYPE) " +
					" SELECT ?,r.USR_ID,?,?,r.USR_NAME,? " +
					" FROM ("+ sUsrIdSql +") r" +
					" WHERE NOT EXISTS (SELECT 1 FROM MS_RECEIVER m WHERE m.MSG_ID = ? and m.RECEIVER_ID = r.USR_ID and m.RECEIVE_TYPE = ?)";
					Object[] args = new Object[]{msg_id,re.getReceive_time(),re.getReceive_state(),re.getReceive_type(),msg_id,re.getReceive_type()};
					getJdbcTemplate().update(insertSql, args);

 INSERT INTO MS_RECEIVER
  (MSG_ID,
   RECEIVER_ID,
   RECEIVE_TIME,
   RECEIVE_STATE,
   RECEIVER_NAME,
   RECEIVE_TYPE)

  select 80251, 843167, 1258944371955, 0, '倪煜', 0
    from MS_RECEIVER m where  not exists (SELECT 1
                                         FROM MS_RECEIVER m
                                        where m.msg_id = 80251
                                          and m.receiver_id = 843167
                                          and m.receive_type = 0)