SQL标准
1、? 基本操作
Insert? table
Update
Delete
Select
?
1.1方法组成? sql 和 值
result SQL. execute(String sql,Object params…);
返回改变条数
Result.success是否成功
Result.count 改变条数
?
result SQL.select(String sql,Object params…);
???????? 返回查询结果数据集
Result.success是否成功
Result.collection
Collection数组[[1,2],[2,3],[4,5]];
[[1]];
1、2事务
transaction{
???????? String sql=”insert into student(name,password) values(?,?)”;
???????? SQL.execute(sql,”LeiWuLuan”,”123456”);
?????????? sql=”update student set name=?,password=? where id=?”;
?????????? SQL.execute(sql,1);
}
上面代码有事功能，当有异常时，数据回滚。
1、3数据库锁
?
?
2、 数据返回操作
Result=collection;
for(int I=0;i<collection.length;i++){
?????????? Object[] temp=collection[i];
??????????
}
3、 代码实例
3、1简单一段程序
public void userList(){
String sql=”select * from user”;
Result result=SQL.select(sql);
Collection collection=result.collection;
request.setAttribute(‘collection’,collection);
request.toPage(‘index.jsp’);
}
????????
???????? <table>
?????????????????? <tr><td>USER</td> <td>ADDRESS</td></tr>
?????????????????? for(int I=0;i<list.length;i++){
??????????????????????????? Object[] temp=list[i];
??????????????????????????? <tr><td> temp[0] </td> <td> temp [1]</td></tr>
?????????????????? }
???????? </table>
???????? 3、2 简单事务操作
?????????????????? public void insertOrder(){
??????????????????????????? String sql=”insert into order(price,date) values(?,?)”;
??????????????????????????? transaction{//事务
???????????????????????????????????? SQL.execute(sql,150,”2011-04-13”);
??????????????????????????? }
}
4、 web 内置对象
Application
Session
Request
Response
?
