数据已经查询出来了,以下代码:
public ArrayList getdisplay() {
ArrayList list = new ArrayList();
try {
Connection con = new MyDBManager("NetBar").getConnection();
Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select * from Computer where rtrim(OnUser) like '1'");
while(rs.next()){
Table1 table1 = new Table1();
table1.setUser(rs.getString(1));
list.add(table1);
}
rs.close();
con.close();
}catch (SQLException ce) {
System.out.println(ce);
}
return list;
}
}
问题是:我想用comboBox这个控件 把查询出来的结果放到 comboBox里面要怎么去写这些代码呀??
帮忙了 拜托~~~
public ArrayList getdisplay() {
ArrayList list = new ArrayList();
try {
Connection con = new MyDBManager("NetBar").getConnection();
Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select * from Computer where rtrim(OnUser) like '1'");
while(rs.next()){
Table1 table1 = new Table1();
table1.setUser(rs.getString(1));
list.add(table1);
}
rs.close();
con.close();
}catch (SQLException ce) {
System.out.println(ce);
}
return list;
}
}
问题是:我想用comboBox这个控件 把查询出来的结果放到 comboBox里面要怎么去写这些代码呀??
帮忙了 拜托~~~
<select name="computer">
<%for(int i=0;i<list.size();i++){%> <option value=<%=list.get(i)%>><%=list.get(i)%>> //<%=list.get(i)%>可能没有那个等号
<%}%>
</select>Java application:
JComboBox jcb=new JComboBox(list); //这个有可能不行or:JComboBox jcb=new JComboBox(list);
for(int i=0;i<list.size();i++)
{
jcb.addItem(list.get(i));
}
import java.awt.BorderLayout;
import java.util.ArrayList;
import java.util.List;import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JPanel;public class Display extends JPanel {
List list=getdisplay();//具体根据你自己的情况写
static JFrame jf=new JFrame("测试");
public equal(){
JComboBox jcb=new JComboBox();
for(int i=0;i<list.size();i++){
jcb.addItem(list.get(i));
//add(jcb);
}
add(jcb);
} public static void main(String args[]){
jf.getContentPane().add(new Display(),BorderLayout.SOUTH);
jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jf.pack();
jf.setVisible(true);
}}