SQL语法以及JSP中的SQL语句

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中该如何写