package y2javaee.xmal1.operation;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;
import y2javaee.xmal1.common.DBConnection;
import y2javaee.xmal1.entity.Book;
public class BookBo {
private Connection conn;//用于保存数据库连接对象
private Statement stm;//用于执行SQL语句
private PreparedStatement ps;//用于执行SQL语句(预处理)
private ResultSet rs;//用于保存查询的结果集
/**
* 根据用户的ID查询用户相关的通讯录信息
* @param userId
* @return 通讯录信息列表
*/
public List selectAllBook(int userId) {
List list = new ArrayList();
String sql = "select * from book where userId=" + userId;
try {
conn = DBConnection.getConnection();
stm = conn.createStatement();
rs = stm.executeQuery(sql);
while (rs.next()) {
Book book = new Book();
book.setId(rs.getInt("id"));
book.setName(rs.getString("name"));
book.setSex(rs.getString("sex"));
book.setPhone(rs.getString("phone"));
book.setAddress(rs.getString("address"));
book.setMobilePhone(rs.getString("mobilePhone"));
book.setCompany(rs.getString("company"));
book.setComPhone(rs.getString("comPhone"));
book.setComAddress(rs.getString("comAddress"));
list.add(book);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBConnection.closeResultSet(rs);
DBConnection.closeStatement(stm);
DBConnection.closeConnection();
}
return list;
}
/**
* 根据用户的ID和联系人与用户关系,查询通讯录信息
* @param userId
* @param relation
* @return 通讯录信息列表
*/
public List selectBookByRelation(int userId,String relation) {
List list = new ArrayList();
String sql = "select * from book where userId=? and relation= ? ";
try {
conn = DBConnection.getConnection();
ps = conn.prepareStatement(sql);
ps.setInt(1, userId);
ps.setString(2, relation);
rs = ps.executeQuery();
while (rs.next()) {
Book book = new Book();
book.setId(rs.getInt("id"));
book.setName(rs.getString("name"));
book.setSex(rs.getString("sex"));
book.setPhone(rs.getString("phone"));
book.setAddress(rs.getString("address"));
book.setMobilePhone(rs.getString("mobilePhone"));
book.setCompany(rs.getString("company"));
book.setComPhone(rs.getString("comPhone"));
book.setComAddress(rs.getString("comAddress"));
list.add(book);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBConnection.closeResultSet(rs);
DBConnection.closeStatement(stm);
DBConnection.closeConnection();
}
return list;
}
/**
* 根据通讯录对象,操作数据库的添加功能
* @param book
* @return 影响数据行数
*/
public int insertBook(Book book) {
String sql = "insert into book values(?,?,?,?,?,?,?,?,?,?) ";
int count = 0;
try {
conn = DBConnection.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, book.getName());
ps.setString(2, book.getSex());
ps.setString(3, book.getPhone());
ps.setString(4, book.getAddress());
ps.setString(5, book.getMobilePhone());
ps.setString(6, book.getCompany());
ps.setString(7, book.getComPhone());
ps.setString(8, book.getComAddress());
ps.setString(9, book.getRelation());
ps.setInt(10, book.getUserId());
count = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBConnection.closeStatement(ps);
DBConnection.closeConnection();
}
return count;
}
/**
* 根据通讯录ID删除相关信息
* @param id
* @return 影响数据库行数
*/
public int deleteBookById(String id) {
String sql = "delete from book where id= ? ";
int count = 0;
try {
conn = DBConnection.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, id);
count = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBConnection.closeStatement(ps);
DBConnection.closeConnection();
}
return count;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
在线通讯录 accp北大青鸟Y2项目实战 参考代码 (221个子文件)
BookBo.class 4KB
AddServlet.class 3KB
Book.class 2KB
SelectServlet.class 2KB
LoginServlet.class 2KB
UserBo.class 2KB
DBConnection.class 2KB
DeleteServlet.class 2KB
Users.class 1KB
Validate.class 452B
.classpath 553B
enter.css 3KB
enter.css 3KB
Thumbs.db 78KB
Thumbs.db 72KB
Thumbs.db 21KB
Thumbs.db 21KB
Thumbs.db 15KB
Thumbs.db 14KB
Thumbs.db 7KB
Thumbs.db 6KB
~$系统项目实战.doc 162B
m_tr.gif 4KB
m_tr.gif 4KB
20054616104170383.gif 3KB
20054616104170383.gif 3KB
2005431324010055.gif 3KB
2005431324010055.gif 3KB
2005431332486265.gif 3KB
2005431332486265.gif 3KB
20054119481077038.gif 3KB
20054119481077038.gif 3KB
xx1001.gif 3KB
xx1001.gif 3KB
20054823114977499.gif 3KB
20054823114977499.gif 3KB
20054823324343994.gif 3KB
20054823324343994.gif 3KB
200543128129181.gif 2KB
200543128129181.gif 2KB
200541116272355477.gif 2KB
200541116272355477.gif 2KB
shou.gif 1KB
shou.gif 1KB
qi.gif 1KB
qi.gif 1KB
liu.gif 1KB
liu.gif 1KB
tr.gif 1KB
tr.gif 1KB
dr.gif 1KB
dr.gif 1KB
home.gif 1KB
home.gif 1KB
tl.gif 1KB
tl.gif 1KB
dl.gif 1KB
dl.gif 1KB
2e-m-dh.gif 1010B
2e-m-dh.gif 1010B
t_mr.gif 989B
t_mr.gif 989B
2e-m-tp.gif 921B
2e-m-xw.gif 921B
2e-m-tp.gif 921B
2e-m-xw.gif 921B
2e-m-yy.gif 888B
2e-m-yy.gif 888B
2e-m-3d.gif 808B
2e-m-3d.gif 808B
m_bg_tr.gif 672B
m_bg_tr.gif 672B
d_bg.gif 579B
d_bg.gif 579B
t_bg.gif 383B
t_bg.gif 383B
e_copy.gif 296B
e_copy.gif 296B
m_bg_tl.gif 232B
m_bg_tl.gif 232B
spacer.gif 43B
mystat.htm 310B
mystat.htm 310B
banner.html 722B
jaxb-xjc-2.0.1.jar 2.85MB
xbean-2.2.0.jar 2.54MB
spring-1.2.6.jar 1.81MB
bcprov-jdk15-133.jar 1.02MB
xercesImpl-2.6.2.jar 987KB
xfire-all-1.2.6.jar 883KB
jaxb-impl-2.0.1.jar 768KB
wss4j-1.5.1.jar 529KB
wstx-asl-3.2.0.jar 493KB
jetty-6.1.2rc0.jar 451KB
mssqlserver2.jar 402KB
standard.jar 384KB
mail-1.4.jar 380KB
xmlsec-1.3.0.jar 278KB
commons-httpclient-3.0.jar 273KB
saaj-impl-1.3.jar 268KB
共 221 条
- 1
- 2
- 3
资源评论
cfyme
- 粉丝: 29
- 资源: 76
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功