?? userdb.java
字號:
package com.cargo.db;
import java.sql.ResultSet;
import java.util.Collection;
import java.util.ArrayList;
import com.cargo.model.User;
import java.sql.SQLException;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: MR</p>
* @author BWM
* @version 1.0
*/
public class Userdb extends Conn implements Keywords {
private int t;
private ResultSet rs;
public int insert(User user) {
t = insert(INSERT_INTO +
"tb_user(id,name,password,age,sex,tel,email,area,address)" +
VALUES + "('" + user.getUserid() + "','" + user.getName() +
"','" + user.getPassword() + "'," + user.getAge() + "," +
user.getSex() + "," + user.getTel() + ",'" + user.getEmail() +
"','" + user.getArea() + "','" + user.getAddress() + "')");
return t;
}
public Collection select() {
return this.select("");
}
public Collection select(String sql) {
Collection coll = new ArrayList();
rs = getRs(SELECT + "*" + FROM + "tb_user" + sql);
try {
while (rs.next()) {
User user = new User();
user.setUserid(rs.getString(1));
user.setName(rs.getString(2));
user.setPassword(rs.getString(3));
user.setAge(rs.getInt(4));
user.setSex(rs.getInt(5));
user.setTel(rs.getString(6));
user.setEmail(rs.getString(7));
user.setArea(rs.getString(8));
user.setAddress(rs.getString(9));
coll.add(user);
}
} catch (SQLException ex) {
System.out.println(sql);
System.out.println(ex.getMessage());
} finally {
close();
return coll;
}
}
public int update(User user) {
t = update(UPDATE + "tb_user" + SET + "name='" + user.getName() +
"',password='" + user.getPassword() + "',age=" + user.getAge() +
",sex=" + user.getSex() +
",tel=" + user.getTel() + ",email='" + user.getEmail() +
"',area='" + user.getArea() + "',address='" +
user.getAddress() + "'" + WHERE + "id='" + user.getUserid()+"'");
return t;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -