dao

package persistencia;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import persistencia.to.UserTO;
import sun.util.logging.PlatformLogger;

/**
 *
 * @author CamiloUgis
 */
public class UserDAO {
    private final static String READ_QUERY = "select * from user where username=? and password=?";
    private final static String READ_ALL ="select * from user";
    private final static String DB_NAME = "accounts";
    private final static String PORT="3306";
    private final static String URL="jdbc:mysql://192.168.88.25:"+PORT+"/"+DB_NAME;
    private final static String USER="developer";
    private final static String PASSWORD="tallerweb";



    public UserTO read(String user, String pass) throws SQLException{
        UserTO result=null;
        Connection conn=null;
        try{
            conn=getConnection();
            PreparedStatement ps = (conn.prepareStatement(READ_QUERY));
            ps.setString(0, user);
            ps.setString(1, pass);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                result=new UserTO();
                result.setId(rs.getInt("id"));
                result.setUserName(rs.getString("username"));
                result.setPassword(rs.getString("password"));


            }
        }catch(SQLException ex){
            Logger.getLogger(UserDAO.class.getName()).log(Level.SEVERE,null,ex);
        }finally{
            if(conn!=null){
                conn.close();
            }
        }

        return result;
    }




    private static Connection getConnection(){
        Connection conn=null;
        try{
            Class.forName("com.mysql.jdbc.Driver");
            conn=(Connection) DriverManager.getConnection(URL,USER,PASSWORD);
        }catch(ClassNotFoundException | SQLException e1){
            e1.printStackTrace();
            System.err.println("Quedo la patá hermano!!!");
        }
        return conn;
    }

}