我要将执行SQL语句后的语句加入到Object数组中,然后用JTable显示
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myjava", "root", "sa");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from sale;");
while(rs.next()){
String st1,st2;
st1=new String(rs.getString(2).getBytes("ISO8859_1"));
st2=new String(rs.getString(3).getBytes("ISO8859_1"));
//这个地方如何用Object将st1与st2组合成一个数组,或者有其他的什么方法?
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myjava", "root", "sa");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from sale;");
while(rs.next()){
String st1,st2;
st1=new String(rs.getString(2).getBytes("ISO8859_1"));
st2=new String(rs.getString(3).getBytes("ISO8859_1"));
//这个地方如何用Object将st1与st2组合成一个数组,或者有其他的什么方法?
list.add(str1+str2);
List<Object> list = new Arraylist<Object> //随机访问效率高,or LinkedList<Object>//List中间插入或删除时效率高
while(rs.next()){
String st1,st2;
st1=new String(rs.getString(2).getBytes("ISO8859_1"));
list.add(str1);
st2=new String(rs.getString(3).getBytes("ISO8859_1"));
list.add(str2);