SQL语法以及JSP中的SQL语句

来源：互联网发布：达内科技设计网络营编辑：程序博客网时间：2024/06/05 16:02

JSP中的SQL语句定义：String sql="";

数据查询：select
数据操纵：insert ，update ，delete
数据定义：create ，alter ，drop
数据控制：commit work ，rollback work

SQL基本语法：

精确查询：

select * from demo where id='1';select id,name,age from demo;

JSP:

//String id=request.getParemeter("id");sql="select * from demo where id="+id;sql="select id,name,age from demo";

模糊查询：

select * from demo where name like '%X%'；

JSP:

//String X= request.getParameter("X");sql="select * from demo where name like '%"+X+"%'";

插入：

insert into demo values ('031213','Thea','18');insert into demo (name,age) values('Sara','20');

JSP:

//String id=request.getParameter("id");//String name=request.getParameter("name");//String age=request.getParameter("age");sql="insert into demo values('"+id+"','"+name+"','"+age+"')";

sql="insert into demo(name,age) values('"+name+"','"+age+"')";

更新：

update demo set name='Thea',age='18' where id='0312';

JSP:

//String id=request.getParameter("id");//String name=request.getParameter("name");//String age=request.getParameter("age");sql="update demo set name='"+name+"',age="+age+"' where id="+id;

删除：

delete from demo where id='0312';

JSP:

//String id=request.getParameter("id");sql="delete from demo where id="+id;

SQL语句在JSP 中应该注意那些被单引号引起来的值在String中该如何写

0 0