67,512
社区成员
发帖
与我相关
我的任务
分享
public ArrayList<Address> adreesName(String phone,String birthday,String name)
{
System.out.println("===================jjjjjjjjjjjjj");
ArrayList<Address> aList=new ArrayList<Address>();
String sql="select * from plat_address_book with(nolock) where phone=? or birthday=? or name=?";
List tbl = dbexec.queryForList(sql,new Object[]{phone,birthday,name});
Iterator it = tbl.iterator();
while(it.hasNext()) {
Address addr = new Address();
Map rec = (Map)it.next();
addr.setId((Long)rec.get("id"));
addr.setName((String)rec.get("name"));
addr.setGender((Integer)rec.get("gender"));
addr.setPhone((String)rec.get("phone"));
addr.setJob((String)rec.get("job"));
addr.setCompany((String)rec.get("company"));
addr.setAddress((String)rec.get("address"));
addr.setBirthday((Timestamp)rec.get("birthday"));
addr.setEmail((String)rec.get("email"));
addr.setQq((String)rec.get("qq"));
addr.setMsn((String)rec.get("msn"));
addr.setReserve((String)rec.get("reserve"));
addr.setUserId((Long)rec.get("userId"));
addr.setGroupId((Long)rec.get("groupId"));
aList.add(addr);
}
return aList;
}
[Quote=引用 9 楼 qq315737546 的回复:]<%@ page contentType="text/html; charset=gbk"%>
<%@page import="smartmt.db.DataSourceFactory"%>
<%@page import="java.util.ArrayList"%>
<%@page import="smartmt.model.Address"%>
<%@page import="smartmt.db.AddressDao"%>
<%@page import="smartmt.model.AddressGroup"%>
<%@page import="smartmt.model.Bill"%>
<%@page import="java.util.HashMap"%>
<%@page import="java.util.List"%>
<%@ taglib uri="http://displaytag.sf.net" prefix="display" %>
<script type="text/javascript">
function checkAll() {
var a = document.getElementsByName("checkbox_phone");
var n = a.length;
for (var i=0; i<n; i++) {
a[i].checked = true;//window.event.srcElement.checked;
}
}
function cancelAll() {
var a = document.getElementsByName("checkbox_phone");
var n = a.length;
for (var i=0; i<n; i++) {
a[i].checked = false;//window.event.srcElement.checked;
}
}
function go() {
addrForm.action = "manual.jsp";
var a = document.getElementsByName("checkbox_phone");
var n = a.length;
var count = 0;
for (var i=0; i<n; i++) {
if(a[i].checked) count++;
}
if(count > 0) {
return true;
} else {
alert("您未选中任何联系人");
return false;
}
}
function go_all(groupId) {
location="manual.jsp?addAll=yes&groupId="+groupId;
}
function groupChange(value) {
location="b_all.jsp?groupId="+value;
}
function deleteAddr() {
var a = document.getElementsByName("checkbox_phone");
var n = a.length;
var count = 0;
for (var i=0; i<n; i++) {
if(a[i].checked) count++;
}
if(count > 0) {
addrForm.action = "b_delete.jsp";
return confirm("您选中了"+count+"条联系人记录,确认要删除吗?");
} else {
alert("您未选中任何联系人");
return false;
}
}
</script>
</head>
<%
//String start = request.getParameter("start");
/// String name = request.getParameter("name");
// name=new String(name.getBytes("iso-8859-1"),"gbk");
Long userId = (Long)session.getAttribute("userId");
//String phone = request.getParameter("phone");
if(userId == null) {
%><script>top.window.location.href='../index.htm'</script><%
return;
}
AddressDao aDao = new AddressDao(DataSourceFactory.getDataSource());
String groupId = request.getParameter("groupId");
long lGroupId = -1;
if(groupId != null) {
lGroupId = Long.parseLong(groupId);
}
//ArrayList<Address> aList = aDao.getAllAddressPlus(userId,lGroupId);
//ArrayList<Address> aList = aDao.getAllAddressPlus1(name,userId,lGroupId);
//ArrayList<HashMap<String, String>> aList= aDao.getMoList(userId, start, phone, name);
//ArrayList<Address> aList1=aDao.adreesName(name);
%>
<%
String name=request.getParameter("name");
String birthday=request.getParameter("birthday");
String phone=request.getParameter("phone");
name=new String(request.getParameter("name").getBytes("iso-8859-1"),"gb2312");
ArrayList<Address> aList1=aDao.adreesName(phone,birthday,name);
%>
<body bgcolor="#efefef">
<%
request.setAttribute("aList1", aList1);
%>
<display:table name="aList1" pagesize="20">
<display:column title="选中" ><input type="checkbox"></display:column>
<display:column property="id" title="id" />
<display:column property="name" title="姓名" />
<display:column property="gender" title="分组" />
<display:column property="phone" title="手机号码" />
<display:column property="job" title="职位" />
<display:column property="company" title="公司" />
<display:column property="address" title="地址" />
<display:column property="birthday" title="生日" />
<display:column property="email" title="邮箱" />
<display:column property="qq" title="QQ" />
<display:column property="msn" title="MSN" />
<display:column property="reserve" title="地址" />
<display:column property="userId" title="用户编号" />
<display:column property="groupId" title="组号" />
</display:table><br>
<input type="button" value="全部选中" onclick="checkAll()">
<input type="button" value="全部取消" onclick="cancelAll()">
<input type="submit" value="发送短信" onclick="return go()">
<input type="submit" value="删除联系人" onclick="return deleteAddr()">
<input type="button" value="发送短信(分组全部联系人)"
onclick="return go_all(<%=lGroupId%>)">
<form method="get" action="b_all.jsp">
<input type="submit" value="返回"/>
</form>
</body>
</html>