카테고리 없음
[iBatis][myBatis] prepared statement
lovelywook
2018. 7. 6. 15:08
@markdown
# [iBatis][myBatis] prepared statement
#### Tag
- $
> 변수를 대입.
- #
> ? 사용으로 prepared statement 사용.
#### iBatis
> `$var$`
> `#var#`
#### myBatis
> `${var}`
> `#{var}`
#### PreparedStatement LIKE 사용
1. Oracle
```sql
WHERE(AND) column LIKE '%'||#search_value#||'%'
...
WHERE(AND) column LIKE '%'||#{search_value}||'%'
```
2. MS-SQL
```sql
WHERE(AND) column LIKE '%'+#search_value#+'%'
...
WHERE(AND) column LIKE '%'+#{search_value}+'%'
```
3. MySQL
```sql
WHERE(AND) column LIKE CONCAT('%', #search_value#, '%')
...
WHERE(AND) column LIKE CONCAT('%', #{search_value}, '%')
```