package connect;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import Allclass.CameraMessage;
import Allclass.GroupDomainMessage;
import Allclass.GroupsMessge;
public class GroupDomainID {
/**
* 查询所有GroupDomain
* @return
* @throws SQLException
*/
public List<GroupDomainMessage> getlist(int userid) throws SQLException
{
List<GroupDomainMessage> list=new ArrayList<GroupDomainMessage>();
Connectionsql con=new Connectionsql();
con.openConnection();
//where gd.GroupDomainParent=0
String sql="select * from GroupDomain gd "+
"UNION select gpd.* from Groups gs,users us,UserGroupItem ugt,UserCamera uc, "+
"GroupDomain gpd where us.UserID = ugt.UserID and ugt.UserCameraID = uc.UserCameraID "+
"and uc.GroupID = gs.GroupID and gpd.GroupDomainID = gs.GroupDomainID and us.UserID ="+userid
+" UNION select gpd.* from GroupDomain gpd where gpd.GroupDomainID in ( "+
"select gpd.GroupDomainParent from Groups gs,users us,UserGroupItem ugt,UserCamera uc, "+
"GroupDomain gpd where "+
"us.UserID = ugt.UserID and ugt.UserCameraID = uc.UserCameraID "+
"and uc.GroupID = gs.GroupID and gpd.GroupDomainID = gs.GroupDomainID and "+
"us.UserID ="+userid+")";
ResultSet res=con.executeSelectResult(sql);
res.last();
int rows = res.getRow();
res.beforeFirst();
try {
while(res.next()){
GroupDomainMessage message=new GroupDomainMessage();
message.setGroupDomainID(res.getInt(1));
message.setGroupDomainParent(res.getInt(2));
message.setGroupType(res.getInt(3));
message.setServerIP(res.getString(4));
message.setServerPort(res.getInt(5));
message.setForeignDomainID(res.getInt(6));
message.setUserName(res.getString(7));
message.setPassWord(res.getString(8));
message.setGroupDomainName(res.getString(9));
message.setListCount(rows);
list.add(message);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("GroupDomain===="+list.size());
return list;
}
/**
* 查询所有GroupDomain移动光标
* @return
*/
public Long getlistcount(int userid)
{
Connectionsql con=new Connectionsql();
con.openConnection();
String sql="select count(*) from GroupDomain gd where gd.GroupDomainParent=0 "+
"UNION select gpd.* from Groups gs,users us,UserGroupItem ugt,UserCamera uc, "+
"GroupDomain gpd where us.UserID = ugt.UserID and ugt.UserCameraID = uc.UserCameraID "+
"and uc.GroupID = gs.GroupID and gpd.GroupDomainID = gs.GroupDomainID and us.UserID ="+userid
+" UNION select gpd.* from GroupDomain gpd where gpd.GroupDomainID in ( "+
"select gpd.GroupDomainParent from Groups gs,users us,UserGroupItem ugt,UserCamera uc, "+
"GroupDomain gpd where "+
"us.UserID = ugt.UserID and ugt.UserCameraID = uc.UserCameraID "+
"and uc.GroupID = gs.GroupID and gpd.GroupDomainID = gs.GroupDomainID and "+
"us.UserID ="+userid+")";
ResultSet res=con.executeSelect(sql);
try {
while(res.next()){
return res.getLong(0);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return 0l;
}
/**
* 查询所有Groups
* @return
*/
public List<GroupsMessge> getGroupslist(int userid)
{
List<GroupsMessge> list=new ArrayList<GroupsMessge>();
Connectionsql con=new Connectionsql();
con.openConnection();
//and uc.GroupID = gs.GroupID
String sql= "select distinct gs.* from Groups gs,users us,UserGroupItem ugt,UserCamera uc "+
"where us.UserID = ugt.UserID and ugt.UserCameraID = uc.UserCameraID "+
" and "+
"us.UserID ="+userid;
ResultSet res=con.executeSelect(sql);
try {
while(res.next()){
GroupsMessge message=new GroupsMessge();
message.setGroupID(res.getInt("GroupID"));
message.setUserID(res.getInt("UserID"));
message.setName(res.getString("Name"));
message.setPrivater(res.getInt("private"));//res.getInt(4)
message.setType(res.getInt("Type"));
message.setDescription(res.getString("Description"));
message.setGroupDomainID(res.getInt("GroupDomainID"));//res.getInt(7)
list.add(message);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("Groups===="+list.size());
return list;
}
public List<GroupsMessge> getGrouplist()
{
List<GroupsMessge> list=new ArrayList<GroupsMessge>();
Connectionsql con=new Connectionsql();
con.openConnection();
//and uc.GroupID = gs.GroupID
String sql= "select * from Groups";
ResultSet res=con.executeSelect(sql);
try {
while(res.next()){
GroupsMessge message=new GroupsMessge();
message.setGroupID(res.getInt("GroupID"));
message.setUserID(res.getInt("UserID"));
message.setName(res.getString("Name"));
message.setPrivater(res.getInt("private"));//res.getInt(4)
message.setType(res.getInt("Type"));
message.setDescription(res.getString("Description"));
message.setGroupDomainID(res.getInt("GroupDomainID"));//res.getInt(7)
list.add(message);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("Groups===="+list.size());
return list;
}
/**
* 查询所有的底层数据
* @return
*/
public List<Map<String,Object>> getAllist()
{
List<Map<String,Object>> list=new ArrayList<Map<String,Object>>();
Connectionsql con=new Connectionsql();
con.openConnection();
String sql="select distinct u.UserCameraID,u.GroupID,u.CameraID,c.Name,s.InternalIP from UserCamera u ,Camera c ,Groups gs , Server s, "+
"users ust "+
"where u.CameraID = c.CameraID and u.GroupID = gs.GroupID "+
"and c.multicastip = s.serverid ";
ResultSet res=con.executeSelect(sql);
try {
while(res.next()){
Map<String,Object> message=new HashMap<String, Object>();
message.put("UserCameraID",res.getInt("UserCameraID")); //1
message.put("GroupID",res.getInt("GroupID"));//2
message.put("CameraID",res.getInt("CameraID"));//3
message.put("CameraName",res.getString("Name"));//Server.InternalIP 8
message.put("InternalIP",res.getString("InternalIP"));//26
list.add(message);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("Camera===="+list.size());
return list;
}
public List<CameraMessage> getAlllist(int userid)
{
List<CameraMessage> list=new ArrayList<CameraMessage>();
Connectionsql con=new Connectionsql();
con.openConnection();
String sql="select distinct u.UserCameraID,u.GroupID,u.CameraID,c.Name,s.InternalIP from UserCamera u ,Camera c ,Groups gs , Server s, "+
"users us,UserGroupItem ugt "+
"where us.UserID = ugt.UserID and ugt.UserCameraID = u.UserCameraID "+
"and u.CameraID = c.CameraID and u.GroupID = gs.GroupID "+
"and c.multicastip = s.serverid "+
"and us.UserID ="+userid;
ResultSet res=con.executeSelect(sql);
try {
while(res.next()){
CameraMessage message=new CameraMessage();
message.setUserCameraID(res.getInt("UserCameraID")); //1
message.setGroupID(res.getInt("GroupID"));
message.setCameraID(res.getInt("CameraID"));//3
message.setName(res.getString("Name"));//Server.InternalIP 8
message.setInternalIP(res.getString("InternalIP"));
list.add(message);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("Camera===="+list.size());
return list;
}
}
java jdbc连接数据库【Mysql sqlsever orcl sqlite】汇总 （361个子文件） 
1.bmp 25KB
GroupDomainID.class 7KB CameraMethod.class 6KB DB.class 3KB CameraMessage.class 3KB MD5.class 3KB Connectionsql.class 3KB pageses.class 3KB CRequest.class 3KB pageses.class 3KB Messagesshow.class 3KB Mcumessage.class 3KB GroupDomainMessage.class 2KB AIAlarmMassage.class 2KB Domainxiqvmessage.class 2KB diplay.class 2KB TestSocket.class 2KB GroupsMessge.class 2KB GroupsMethod.class 2KB UserLogign.class 2KB GroupDomainMethod.class 2KB CommandReturnMessage.class 2KB SeqMessage.class 1KB CameraMassage.class 1KB upadates.class 1KB Usermessage.class 925B .classpath 362B jquery.fancybox-1.3.4.css 9KB zTreeStyle.css 9KB green.css 8KB black.css 8KB blue.css 8KB default.css 8KB Copy of zTreeStyle.css 7KB opera.css 7KB aero.css 7KB idialog.css 7KB chrome.css 6KB twitter.css 6KB simple.css 6KB datepicker.css 5KB datepicker.css 5KB common_style.css 5KB main_css.css 2KB basic_layout.css 2KB login_css.css 2KB WdatePicker.css 158B shabi.db 87KB
login_4.gif 15KB login_1.gif 14KB login_2.gif 10KB loading.gif 9KB login_3.gif 9KB zTreeStandard1.gif 5KB zTreeStandard.gif 5KB act_btn.gif 2KB top_tt_bg.gif 2KB ajax-loading.gif 2KB img.gif 2KB left_tt.gif 2KB img.gif 2KB box_tit_bg.gif 1KB login_5.gif 1KB datePicker.gif 1KB tip.gif 1005B tab_17.gif 924B tab.gif 895B tab_20.gif 770B tab_07.gif 752B back.gif 749B next.gif 745B last.gif 741B first.gif 736B go.gif 736B tab_18.gif 715B tab_03.gif 699B tb.gif 585B arrow.gif 553B tab_19.gif 420B home.gif 416B loading.gif 381B tab_05.gif 375B 11.gif 341B 2.gif 340B 33.gif 337B 1.gif 328B bg.gif 273B tdbj.gif 233B 22.gif 215B closed.gif 207B edt.gif 197B del.gif 145B bar9.gif 127B tab_15.gif 112B tab_12.gif 111B login_6.gif 102B +.gif 85B -.gif 82B main_12_me2.gif 65B main_12_me.gif 65B共 361 条
- 1
- 2
- 3
- 4
资源评论
