Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class DBConnect {
- private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
- private static final String DB_CONNECTION = "jdbc:mysql://localhost/ezeepayservices";
- private static final String DB_USER = "root";
- private static final String DB_PASSWORD = "admin";
- Connection dbConnection = null;
- public void connect(){
- try {
- Class.forName(DB_DRIVER);
- } catch (ClassNotFoundException e) {
- System.out.println(e.getMessage());
- }
- try {
- dbConnection = DriverManager.getConnection(
- DB_CONNECTION, DB_USER,DB_PASSWORD);
- } catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- }
- public List fetch(String name,String addres,String salary,String pension) throws SQLException{
- if (dbConnection == null){
- throw new RuntimeException("Please call connect() before you call insert()");
- }
- String selectSQL = "SELECT * FROM test WHERE Name like ? and address like ? and salary like ? and pension like ?";
- PreparedStatement stmt = dbConnection.prepareStatement(selectSQL);
- stmt.setString(1, "%"+name+"%");
- stmt.setString(2, "%"+addres+"%");
- stmt.setString(3, "%"+salary+"%");
- stmt.setString(4, "%"+pension+"%");
- ResultSet rs = stmt.executeQuery();
- List person_list = new ArrayList();
- while (rs.next()) {
- Person person = new Person();
- person.setId(rs.getString("id"));
- person.setName(rs.getString("Name"));
- person.setAddress(rs.getString("address"));
- person.setPhonenumber(rs.getString("phonenumber"));
- person.setSalary(rs.getString("salary"));
- person.setPension(rs.getString("pension"));
- System.out.println("#### name in DAO "+rs.getString("Name"));
- person_list.add(person);
- }
- return person_list;
- }
- public void disconnect(){
- try {
- dbConnection.close();
- } catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- }
- }
Add Comment
Please, Sign In to add comment