62,614
社区成员
发帖
与我相关
我的任务
分享
package com.mtqj.quotes.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import com.mtqj.quotes.Util.DBUtil;
import com.mtqj.quotes.model.Surface;
public class SurfaceDao {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
public ArrayList<Surface> getSurfaces(String mid) {
ArrayList<Surface> surfaceList = new ArrayList<Surface>();
String sql = "select * from Surface where m_id = ?;";
conn = DBUtil.getConn();
try {
ps = conn.prepareStatement(sql);
ps.setString(1, mid);
rs = ps.executeQuery();
while (rs.next()) {
Surface s = new Surface();
s.setS_id(rs.getInt("S_id"));
s.setM_id(rs.getInt("M_id"));
s.setSurface(rs.getString("Surface"));
s.setFee(rs.getFloat("Fee"));
surfaceList.add(s);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return surfaceList;
}
}