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实训） （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
最新资源
- nuget 库官方下载包，可使用解压文件打开解压使用
- 非wine、原生Linux迅雷安装包deb文件，支持Ubuntu、UOS统信、深度Deepin、LinuxMint、Debain系通用
- KUKA机器人安装包，与PROFINET软件包
- 船舶燃料消耗和二氧化碳排放分析数据集，燃料消耗和碳排放关联分析数据
- req-sign、bd-ticket-ree-public加密算法（JS）
- 全自动批量建站快速养权重站系统【纯静态html站群版】：(GPT4.0自动根据关键词写文章+自动发布+自定义友链+自动文章内链+20%页面加提权词)
- 串联式、并联式、混联式混合动力系统simulink控制策略模型(串联式、并联式、混联式每个都是独立的需要单独说拿哪个，默认是混联式RB) 有基于逻辑门限值、状态机的规则控制策略(RB)、基于等效燃油
- 法码滋.exe法码滋2.exe法码滋3.exe
- python-geohash-0.8.5-cp38-cp38-win-amd64
- Matlab根据flac、pfc或其他软件导出的坐标及应力、位移数据再现云图 案例包括导出在flac6.0中导出位移的fish代码（也可以自己先准备软件导出的坐标数据及对应点的位移或应力数据，可根据需
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
前往页