感觉这段代码是比较固定的,所以写在这里,忘记的时候可以过来查一下~~~
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String url = null;
String user = null;
String password = null;
String sql = null;
List list = new ArrayList();
try{
Class.forName("com.mysql.jdbc.Driver");
url = "jdbc:mysql://localhost/userdb?user=root&password=root&useUnicode=true&&characterEncoding=gb2312&autoReconnect = true";//简单写法:url = "jdbc:myqsl://localhost/test(数据库名)? user=root(用户)&password=root(密码)";
user = "root";
password = "root";
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
sql="select * from table1";
rs = stmt.executeQuery(sql);
while(rs.next()) {
User user = new User();
user.setName(rs.getString(1));
user.setGender(rs.getInt(2));
……
list.add(user);
}
}
catch(Exception e)
{
e.printStackTrace();
}
return list;