String sReturnFormat = req.getParameter("returnFormat");
Connection conn = null;
PreparedStatement stat = null;
ResultSet rs = null;
List<Address> returnList = new ArrayList<Address>();
String sUserID = req.getParameter("User_ID");
try {
conn = dbManager.getConnection(); stat = conn.prepareStatement("SELECT Address_ID ,User_ID ,Province_ID ,City_ID ,Disturct_ID ,Detail_Address ,Alias ,Recevier ,Phone ,Email ,Zip_Code ,Default_Address ,Created_Time ,Updated_Time FROM address where User_ID=?");
stat.setString(1, sUserID);
rs = stat.executeQuery();
while(rs.next()) {
Address address = new Address();
address.addressID = rs.getInt("Address_ID");
address.userID = rs.getString("User_ID");
address.provinceID = rs.getInt("Province_ID");
address.cityID = rs.getInt("City_ID");
address.disturctID = rs.getInt("Disturct_ID");
address.detailAddress = rs.getString("Detail_Address");
address.alias = rs.getString("Alias");
address.receiver = rs.getString("Recevier");
address.phone = rs.getString("Phone");
address.email = rs.getString("Email");
address.zip = rs.getString("Zip_Code");
address.defaultAddress = rs.getString("Default_Address");
address.createTime = rs.getString("Created_Time");
address.updateTime = rs.getString("Updated_Time");
Result.getReturnFormat(req, resp, 2, "address.id=");
returnList.add(address);
}我把sql语句在数据库查询了 有数据 为什么 我放在list后 list里面的数据为空呢?
对了数据库Address_ID,User_ID,Province_ID,City_ID,Disturct_ID 在MySQL 字段为int类型
Connection conn = null;
PreparedStatement stat = null;
ResultSet rs = null;
List<Address> returnList = new ArrayList<Address>();
String sUserID = req.getParameter("User_ID");
try {
conn = dbManager.getConnection(); stat = conn.prepareStatement("SELECT Address_ID ,User_ID ,Province_ID ,City_ID ,Disturct_ID ,Detail_Address ,Alias ,Recevier ,Phone ,Email ,Zip_Code ,Default_Address ,Created_Time ,Updated_Time FROM address where User_ID=?");
stat.setString(1, sUserID);
rs = stat.executeQuery();
while(rs.next()) {
Address address = new Address();
address.addressID = rs.getInt("Address_ID");
address.userID = rs.getString("User_ID");
address.provinceID = rs.getInt("Province_ID");
address.cityID = rs.getInt("City_ID");
address.disturctID = rs.getInt("Disturct_ID");
address.detailAddress = rs.getString("Detail_Address");
address.alias = rs.getString("Alias");
address.receiver = rs.getString("Recevier");
address.phone = rs.getString("Phone");
address.email = rs.getString("Email");
address.zip = rs.getString("Zip_Code");
address.defaultAddress = rs.getString("Default_Address");
address.createTime = rs.getString("Created_Time");
address.updateTime = rs.getString("Updated_Time");
Result.getReturnFormat(req, resp, 2, "address.id=");
returnList.add(address);
}我把sql语句在数据库查询了 有数据 为什么 我放在list后 list里面的数据为空呢?
对了数据库Address_ID,User_ID,Province_ID,City_ID,Disturct_ID 在MySQL 字段为int类型
解决方案 »
- 求一个正则表达式
- java.net.SocketException: Connection timed out
- 多线程入门, 问个傻问题!
- java tcp局域网传输文件的怪事!
- 谁愿意指点一下我啊!!
- vj
- maximum number of processes (59) exceeded
- 关于Oracle BLOB类型,一个String字符怎么写入BLOB字段?
- jbuilder4的enterprise setup需要weblogic51,但我的是weblogic6,应该怎样才能让jbuilder支持6啊?
- 大家都在用什么java编译器
- java泛型
- JNI内存的问题,高手帮我看看,这段代码有内存泄露的问题吗?
打个断点debug就知道了。