Jsp连接oracle之ArrayList从Oracle中执行带条件的select

来源:百度知道 编辑:UC知道 时间:2024/05/08 02:27:27
执行一条不带条件的select我是这样操作的。
public static ArrayList getAllEntity() throws Exception{
ArrayList result = new ArrayList();
Connection con = null;
Statement stm = null;
ResultSet rs = null;

String sql = "select asb_customerid,customer,asb_circuitid,asb_nmsemsname,node,alertkey from b_custom "
+ "order by Customer";
try {
con = DataSourceConnection.getOracleConnection();
stm = con.createStatement();
rs = stm.executeQuery(sql);
while (rs.next()) {
String asb_customerid = rs.getString("asb_customerid");
String customer = rs.getString("customer");
String asb_circuitid = rs.getString("asb_circuitid");
String asb_nmsemsname = rs.getString("asb_nmsemsname");
String node = rs.getString("node");
String alertkey = rs.getString("alertkey");<

public static ArrayList getAllEntity(String parcustomerid) throws Exception{
……
String sql = "select asb_customerid,customer,asb_circuitid,asb_nmsemsname,node,alertkey from b_custom "
+"order by Customer where asb_customerid="+parcustomerid;

……

其余部分不变
条件就是定义方法的参数String parcustomerid呀