package ceshiJDBC;
import java.util.Properties;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.security.KeyStore.ProtectionParameter;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
//object数组存储
public class ORMDemo {
static Properties pro=null;
static Connection con=null;
static PreparedStatement ps=null;
static ResultSet rs=null;
static Object[] obj=null;
static List<Object[]> list=new ArrayList<Object[]>();
static {
try {
pro=new Properties();
pro.load(new FileReader("D:\\JavaEEeclipse\\ceshiJDBC\\src\\ceshiJDBC\\JDBC.properties"));
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
try {
Class.forName(pro.getProperty("mysqlDriver"));
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
con=new JDBCUtil().getCon();
ps=con.prepareStatement("select username,regTime from t_user where id>?");
ps.setInt(1, 2);
rs=ps.executeQuery();
obj=new Object[2];
while(rs.next()) {
obj[0]=rs.getString(1);
obj[1]=rs.getDate(2);
list.add(obj);
System.out.println(rs.getString(1)+"--"+rs.getDate(2));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
for(Object[] lists:list) {
System.out.println(""+lists[0]+lists[1]);
}
}
}
输出结果:
nam--2017-11-27
??--2017-11-27
gerg--2017-11-27
rg--2017-11-27
rg2017-11-27
rg2017-11-27
rg2017-11-27
rg2017-11-27
为什么数据存到集合中时正常,而最后都被覆盖了?
就是说,为什么最后结果都是rg2017-11-27??