package com.group.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
public class GroupDaoImpl implements GroupDaoInterface{
public void insertGroup(Group group) {
// TODO Auto-generated method stub
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DbUtils.getConnection();
String sql = "insert into [group](GROUPNAME,PRGROUPID,GROUPNOTE,USERID,SHAREFLG,ORDERDIS,CRTTIME) values(?,?,?,?,?,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, group.getGroup_name());
pstmt.setString(2, group.getPrgroup_id());
pstmt.setString(3, group.getGroup_note());
pstmt.setInt(4, group.getUser_id());
pstmt.setString(5, group.getShareflg());
pstmt.setInt(6, group.getOrderdis());
pstmt.setDate(7, group.getGrttime());
pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
}
public void insertCards(Group group){
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DbUtils.getConnection();
String sql = "insert into group_card(GROUPID,MIDID) values(?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, group.getGroup_id());
pstmt.setInt(2, group.getMidid());
pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
}
public void updateGroup(Group group) {
// TODO Auto-generated method stub
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DbUtils.getConnection();
String sql = "update [group] set GROUPNAME=?,PRGROUPID=?,GROUPNOTE=?,SHAREFLG=?,ORDERDIS=?,CRTTIME=? where GROUPID=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, group.getGroup_name());
pstmt.setString(2, group.getPrgroup_id());
pstmt.setString(3, group.getGroup_note());
pstmt.setString(4, group.getShareflg());
pstmt.setInt(5, group.getOrderdis());
pstmt.setDate(6, group.getGrttime());
pstmt.setInt(7, group.getGroup_id());
pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
}
public void deleteGroup(String group_id) {
// TODO Auto-generated method stub
Connection conn=null;
PreparedStatement pstmt=null;
try
{
conn=DbUtils.getConnection();
String sql="delete group_card where GROUPID=?;delete [group] where GROUPID=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,group_id);
pstmt.setString(2,group_id);
pstmt.executeUpdate();
}
catch(SQLException ex)
{
ex.printStackTrace();
}finally{
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
}
public void deleteCard(String midid) {
// TODO Auto-generated method stub
Connection conn=null;
PreparedStatement pstmt=null;
try
{
conn=DbUtils.getConnection();
String sql="delete group_card where MIDID=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,midid);
pstmt.executeUpdate();
}
catch(SQLException ex)
{
ex.printStackTrace();
}finally{
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
}
public List<Group> selectAllOwnGroups(int user_id) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
List<Group> groups=new ArrayList<Group>();
try {
conn = DbUtils.getConnection();
String sql = "select GROUPNAME from [group] where USERID=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,user_id);
rs = pstmt.executeQuery();
while(rs.next()) {
Group group = new Group();
group.setGroup_name(rs.getString("GROUPNAME"));
groups.add(group);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeResult(rs);
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
return groups;
}
public List<Group> selectAllGroups(int user_id) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
List<Group> groups=new ArrayList<Group>();
try {
conn = DbUtils.getConnection();
String sql = "select GROUPNAME from [group] where USERID<>?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, user_id);
rs = pstmt.executeQuery();
while(rs.next()) {
Group group = new Group();
group.setGroup_name(rs.getString("GROUPNAME"));
groups.add(group);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeResult(rs);
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
return groups;
}
public List<Group> selectAllUsers(int user_id) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
List<Group> groups=new ArrayList<Group>();
try {
conn = DbUtils.getConnection();
String sql = "select USERNAME from [user] where USERID<>?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, user_id);
rs = pstmt.executeQuery();
while(rs.next()) {
Group group = new Group();
group.setUser_name(rs.getString("USERNAME"));
groups.add(group);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeResult(rs);
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
return groups;
}
public Group selectGroup_id(String group_name,int user_id){
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
Group group = new Group();
try {
conn = DbUtils.getConnection();
String sql = "select GROUPID from [group] where GROUPNAME=? and USERID=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, group_name);
pstmt.setInt(2, user_id);
rs = pstmt.executeQuery();
if(rs.next()) {
group.setGroup_id(rs.getInt("GROUPID"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeResult(rs);
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
return group;
}
public Group selectGroupById(int group_id) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
Group group = new Group();
try {
conn = DbUtils.getConnection();
String sql = "select * from [group] where GROUPID=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,group_id);
rs = pstmt.executeQuery();
if(rs.next()) {
group.setGroup_id(rs.getInt("GROUPID"));
group.setGroup_name(rs.getString("GROUPNAME"));
group.setPrgroup_id(rs.getString("PRGROUPID"));
group.setGroup_note(rs.getString("GROUPNOTE"));
group.setShareflg(rs.getString("SHAREFLG"));
group.setOrderdis(rs.getInt("ORDERDIS"));
group.setGrttime(rs.getDate("CRTTIME"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DbUtils.closeResult(rs);
DbUtils.closeStatement(pstmt);
DbUtils.closeConnection();
}
return group;
}
public List<Group> selectCardsById(String[] mid) {
// TODO Auto-generated method stub
Connection conn = null;
ResultSet rs = null;
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
这是我们学校为期两周的JavaEE实训,做一个客户资源管理系统。客户资源管理是对公司内部员工的名片进行管理的系统,其包括名片管理、组管理、访问日志管理、公司/部门视图、用户信息管理、文件导出等功能。 该资源非常详细,包含了需求分析,数据库,跟完整的代码,还有需要的一些jar包。 所用数据库为sql server 2008,程序运行环境为myeclipse,将以使用者,将jsp的编码方式改为utf-8,用到图片上传的组件jspsmart.jar,会存在路径不能显示的状况,建议使用IE浏览器(解决办法:打开浏览器-工具-Internet选项-安全(将安全级别降到最低)-自定义级别里面找到“将文件上传到服务器时包含本地目录路径”,选中“启动”-点击“确定”) 将SQL Server文件夹下的cardjava_Data.MDF附加到sql server中,将aa_3导入到myeclipse里,改一下数据库连接的IP地址(DbUtils.java,DBhelper.java),发布在tomcat下,就可以在浏览器查看了
资源推荐
资源详情
资源评论
收起资源包目录
客户资源管理系统(javaEE实训) (291个子文件)
ScriptResource.axd 254KB
ScriptResource(1).axd 64KB
WebResource(1).axd 21KB
WebResource.axd 21KB
GroupDaoImpl.class 12KB
CardImpl.class 10KB
userMessageImpl.class 7KB
InsertCardServlet.class 7KB
CardInfo.class 5KB
VisitDaoImpl.class 4KB
UpdateCardServlet.class 4KB
FrontServlet.class 4KB
BackServlet.class 4KB
CardMgrImpl.class 4KB
GetUsernameServlet.class 4KB
FileOut.class 4KB
insertGroupServlet.class 3KB
QueryByConditionServlet.class 3KB
InsertVisitorServlet.class 3KB
Group.class 3KB
DBhelper.class 3KB
updateGroupServlet.class 3KB
UpdateUserServlet.class 3KB
InsertUserServlet.class 3KB
userUpdateA.class 3KB
selectYourGroupsServlet.class 3KB
selectGroupsServlet.class 3KB
selectCardByIdServlet.class 3KB
insertCardsServlet.class 3KB
UserMgrImpl.class 3KB
QueryAllOwnServlet.class 3KB
TreeShowServlet.class 2KB
SelectUserServlet.class 2KB
selectUser.class 2KB
UserMessage.class 2KB
QueryAllShareCardServlet.class 2KB
selectYourCardsByGroupIdServlet.class 2KB
selectCardsByGroupIdServlet.class 2KB
SelectByidServlet.class 2KB
UpdateByUserid.class 2KB
QueryByMididServlet.class 2KB
userUpdate.class 2KB
Selectvisitor.class 2KB
Visit.class 2KB
selectGroupByIdServlet.class 2KB
UpdateByMididServlet.class 2KB
DeleteUserServlert.class 2KB
DeleteCardServlet.class 2KB
DeleteUserServlet.class 2KB
deleteCardServlet.class 2KB
deleteGroupServlet.class 2KB
TreeMgrImplTest.class 2KB
UnitMgrImpl.class 2KB
FileOutServlet.class 2KB
DbUtils.class 2KB
DbUtils.class 2KB
DbUtils.class 2KB
DbUtils.class 2KB
TreeMgrImpl.class 2KB
Test.class 1KB
Test.class 1KB
CardMgrImplTest.class 1KB
CardInfo.class 1KB
UserMgrImplTest.class 1KB
SelectOneCardServlet.class 1KB
GroupDaoInterface.class 1KB
TreeInfo.class 1KB
CardInterface.class 1KB
UserInfo.class 928B
Test.class 849B
test.class 786B
userMessageDaoInterface.class 742B
UnitInfo.class 740B
CardMgrInterface.class 457B
VisitDaoInterface.class 433B
UnitMgrImplTest.class 412B
UserMgrInterface.class 379B
TreeMgrInterface.class 292B
UnitMgrInterface.class 230B
.classpath 497B
org.eclipse.wst.jsdt.ui.superType.container 49B
css1.css 7KB
calendar.css 5KB
css.css 3KB
floatPic.css 2KB
left_css.css 804B
dtree.css 795B
top_css.css 629B
right_css.css 597B
fenye.css 348B
Thumbs.db 76KB
Thumbs.db 9KB
客户资源管理系统需求分析与设计报告.doc 676KB
login_8.gif 23KB
login_1.gif 19KB
login_4.gif 15KB
login_2.gif 10KB
login_1.gif 9KB
login_3.gif 9KB
act_btn.gif 2KB
共 291 条
- 1
- 2
- 3
ggxiao1112
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页