![](https://i-blog.csdnimg.cn/blog_migrate/bffd3ec0fec30f74d9bd29ec15d958d3.png)
-----------------------------------------------------------------------------------------------------------------------
变量查询
举个栗子:
select * from 地图1 where 1=1
${if(
len(province) = 0 || province == '中国(省级)',
"order by 销售额 desc",
"and pid = ' "+province+" ' ")}
==> select * from ..
where 1=1
if len(province)=0
order by .. desc
if provice == 中国
and pid = Province
- IF(expr1,expr2,expr3)
Expr1=true-->expr2
Expr1=false-->expr3
- ${para} 作为一个参数宏
- 字符串数据用单引号‘’包含,整型数据不需要单引号;
+号用来连接字符串;
双引号“”用来拼接字符串;如果涉及到变量的拼接查询,则用+进行组合;
- where 1=1之后条件是用过if块动态变化的
- String sql = "insert into student values ( "
+student.getId() + ”,
‘ “ +student.getUsername() + " ' ,
" +student.getAge()+ " ,
' " +student.getClassnumber()+ " '
)" ;
==>insert into student values( id,username,age,classnumber);
Id是int型,无需单引号;
Username是varchar型,所以加单引号;双引号里加+号
查询username= 某个值;则username = ' "+UserName+" '
${}
$将传入数据直接显示生成在sql中,一般用于传入数据库对象,例如表名
#{}
#将传入参数当做字符串,自动加双引号
sqlite轻量级
下载dll和tools安装包后解压到%path%/sqlite目录下
配置环境变量即可
1语法:
注释 -- 每句结束要加;号
ANALYZE AND/OR ALTER TABLE
ALTER TABLE .. RENAME TO .. ATTACH DATABSE '..' AS '..' CREATE
COMMIT DELETE FROM DROP
GROUP BY HAVING LIKE {PATTERN}
2使用
Sqlite expert或者Navicat都可以进行可视化编写
- Sqlite expert
Row_id索引主键,点击index
- Navicat
MySQL数据库,python爬取数据进行导入
Python
requests get()获取数据
html保存,beautifulSoup进行剖析器对象获取
import pymysql
JavaScript
function myfunc{}
getElementById() 查找HTML元素内容
放在<head>/<body>中,例如button -> οnclick="myfunc()"
放在外部文件 src="PATH…"
write()
<script></script>