可以在工程src文件先创建以.properties为后缀名的文件,把
jdbcDriver=com.mysql.jdbc.Driver
jdbcURL=jdbc:mysql://localhost:3306/jdbctest
jdbcUser=root
jdbcPassword=1234
放入其中,但是引用就要改成如下:
//连接数据库的四个参数
private static String jdbcDriver="";
private static String jdbcURL="";
private static String jdbcUser="";
private static String jdbcPassword="";
public static Connection getConnetion() {
//通过文件流读取文件:
InputStream is=DBConnectionUtil.class.
getClassLoader().getResourceAsStream("jdbc.properties");
Properties p=new Properties();
try {
p.load(is);
jdbcDriver=p.getProperty("jdbcDriver");
jdbcURL=p.getProperty("jdbcURL");
jdbcUser=p.getProperty("jdbcUser");
jdbcPassword=p.getProperty("jdbcPassword");
System.out.println(jdbcDriver);
System.out.println(jdbcURL);
System.out.println(jdbcUser);
System.out.println(jdbcPassword);
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
public int getAllUserCount() {
int count=0;
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
conn=DBConnectionUtil.getConnetion();
String sql="select count(*) from user ";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
if(rs.next())
{ count=rs.getInt("count(*)");//获取数据库总共记录的数目
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return count;
}
public List<User> getUsers() {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
//List是接口,ArrayList是它的实现类,new对象是必须用ArrayList
List<User> users=new ArrayList<User>();
// User user=null;
try {
conn=DBConnectionUtil.getConnetion();
String sql="select * from user ";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next())
{ User user=new User();
user.setUserid(rs.getInt("userid"));
user.setUsername(rs.getString("username"));
user.setSex(rs.getInt("sex"));
user.setPassword(rs.getString("password"));
user.setFlag(rs.getInt("flag"));
users.add(user);//把对象加入到集合中
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
DBConnectionUtil.closeAll(ps, conn);
}
return users;
}
//测试查询出的user对象的集合
List<User> users=userDao.getUsers();
for (User user : users) {
System.out.println(user.getUsername());
}