MySql-语句=JDBC.MyBatis

不全,要添加.
JDBC==

    sb.append(" and oldUserName like '%" + oldUserName.trim() + "%'");

第一种 :

    String sql = "select studentname, age, phone, address, other from customer"
                    + " where studentname like ? "; 
    pstmt = conn.prepareStatement(sql);
    // 设定参数
    pstmt.setString(1, "%" + customername + "%" );        
    // 获取查询的结果集            
    rs = pstmt.executeQuery();

---

MyBatis==

and t1.USERNAME like CONCAT(CONCAT('%', #{t1.USERNAME}),'%')