package aaaaaa;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Properties;
public class UserDAO {
private Connection getConnection(){
Connection dbConn = null;
Properties prop = new Properties();
try {
prop.load(new FileInputStream("db.properties"));
String driver = prop.getProperty("mysql.driver");
String url = prop.getProperty("mysql.url");
String user = prop.getProperty("mysql.user");
String password = prop.getProperty("mysql.password");
Class.forName(driver);
dbConn = DriverManager.getConnection(url, user, password);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return dbConn;
}
public ArrayList<UserDTO> getUserList(){
ArrayList<UserDTO> resultList = null;
Connection dbConn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try{
dbConn = getConnection();
Properties prop = new Properties();
prop.load(new FileInputStream("sql.properties"));
String sql = prop.getProperty("getUserList");
pstmt = dbConn.prepareStatement(sql);
rs = pstmt.executeQuery();
resultList = new ArrayList<UserDTO>();
while(rs.next()){
UserDTO userDTO = new UserDTO();
userDTO.setId(rs.getInt("id"));
userDTO.setName(rs.getString("name"));
userDTO.setPassword(rs.getString("password"));
userDTO.setEmail(rs.getString("email"));
resultList.add(userDTO);
}
}catch(Exception e){
e.printStackTrace();
System.out.println(e.toString());
}finally{
if (rs != null) rs = null;
if (pstmt != null) pstmt = null;
if (dbConn != null) dbConn = null;
}
return resultList;
}
}
