ResultSetMetaData应用
来源:互联网 发布:linux 找不到加载主类 编辑:程序博客网 时间:2024/05/07 06:38
package com.goods;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import com.toolks.DBUtil;
public class TestDAO {
public List<Map<String, Object>> AllGoodsbyid(int pageno, int businessid) {
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
Connection conn = DBUtil.getCon();
PreparedStatement pstm = null;
ResultSet rs = null;
String sql = "select id,businessid,name,introduce,image,typeid,price from goods where businessid='"
+ businessid + "' limit " + (pageno - 1) * 12 + ",12 ";
try {
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
java.sql.ResultSetMetaData rsmd = rs.getMetaData();
int count = rsmd.getColumnCount();
String[] colName = new String[count];
for (int i = 1; i <= count; i++) {
colName[i - 1] = rsmd.getColumnLabel(i);
}
while (rs.next()) {
Map<String, Object> data = new HashMap<String, Object>();
for (int i = 0; i < colName.length; i++) {
data.put(colName[i], rs.getObject(colName[i]));
}
list.add(data);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
pstm.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
@SuppressWarnings("unchecked")
public static void main(String[] args) {
Iterator it = new TestDAO().AllGoodsbyid(1, 1).iterator();
while (it.hasNext()) {
System.out.println(it.next());
}
}
}
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import com.toolks.DBUtil;
public class TestDAO {
public List<Map<String, Object>> AllGoodsbyid(int pageno, int businessid) {
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
Connection conn = DBUtil.getCon();
PreparedStatement pstm = null;
ResultSet rs = null;
String sql = "select id,businessid,name,introduce,image,typeid,price from goods where businessid='"
+ businessid + "' limit " + (pageno - 1) * 12 + ",12 ";
try {
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
java.sql.ResultSetMetaData rsmd = rs.getMetaData();
int count = rsmd.getColumnCount();
String[] colName = new String[count];
for (int i = 1; i <= count; i++) {
colName[i - 1] = rsmd.getColumnLabel(i);
}
while (rs.next()) {
Map<String, Object> data = new HashMap<String, Object>();
for (int i = 0; i < colName.length; i++) {
data.put(colName[i], rs.getObject(colName[i]));
}
list.add(data);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
pstm.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
@SuppressWarnings("unchecked")
public static void main(String[] args) {
Iterator it = new TestDAO().AllGoodsbyid(1, 1).iterator();
while (it.hasNext()) {
System.out.println(it.next());
}
}
}
- ResultSetMetaData应用
- 关于ResultSetMetaData 接口的应用
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- ResultSetMetaData
- 接口 ResultSetMetaData
- 接口 ResultSetMetaData
- Oracle ResultSetMetaData
- RC振荡电路 双三极管多谐振荡器
- vc 从工具箱中移除控件 ocx
- ExpandableListActivity的使用和SimpleExpandableListAdapter的使用
- 如何预防久坐伤身?
- 失落的春天
- ResultSetMetaData应用
- jquery无刷新 异步访问
- C#加密解密方法(转)
- java中使用json2
- vc下DLL/lib的调用
- 迟来的真相:关于JavaScript的历史
- AIX系统 tar命令截断问题
- Windows Azure Toolkit for Windows 8 Consumer Preview的升级版发布了
- IOS UITableView某一行重新加载数据