Java

public class login_servlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
 
    public login_servlet() {
        super();
    }
 
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
        //this.getServletContext().getRequestDispatcher( "/login.jsp" ).forward( request, response );
    }
 
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
        java.sql.Connection connexion = null;
        java.sql.Statement statement = null;
        ResultSet resultat = null;
        String userQuery="";
 
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
        }
 
        try {
            connexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/Dlala", "IPLS", "password");
        } catch (SQLException e) {
            e.printStackTrace();
        }
 
        try {
            statement = connexion.createStatement();
 
            // Exécution de la requête
            resultat = statement.executeQuery("SELECT user FROM Client;");
 
            // Récupération des données
            while (resultat.next()) {
                userQuery = resultat.getString("user");
            }
        } catch (SQLException e) {
        } finally {
            // Fermeture de la connexion
            try {
                if (resultat != null)
                    resultat.close();
                if (statement != null)
                    statement.close();
                if (connexion != null)
                    connexion.close();
            } catch (SQLException ignore) {
            }
        }
        //************************************************//
 
        response.setContentType("text/html");   
        PrintWriter out = response.getWriter();   
 
        String n=request.getParameter("user");   
        String p=request.getParameter("pass");  
 
        HttpSession session = request.getSession(false); 
        if(session!=null) 
        session.setAttribute("name", n); 
 
        if( n.equals(userQuery)){   
            RequestDispatcher rd=request.getRequestDispatcher("home.jsp");   
            rd.forward(request,response);   
        }   
        else{  
            out.print("<p style=\"color:red\">Sorry username or password error</p>");   
            RequestDispatcher rd=request.getRequestDispatcher("login.jsp");   
            rd.include(request,response);   
        } 
        out.close(); 
    }
}

DatabseDAO cannot be resolved to a type // in the browser

// DAO class - in file 1
import java.sql.*;
import java.io.*;
import java.util.*;

public class DatabseDAO implements Serializable
{
        /// ........... all the code here
}

// bean class - in file 2
import java.io.*;

public class PersonBean implements Serializable
{
  /// ........... all the code here
}

<%
    DatabseDAO db2 = new DatabseDAO();

    ArrayList persons_list = db2.GetPersons("SELECT * FROM People");
    PersonBean person_bean = null;

    for (int i=0; i<persons_list.size(); i++)
    {
        person_bean = (PersonBean) persons_list.get(i);
%>

        <tr>
            <td><% =person_bean.getPersonId() %></td>
            <td><% =person_bean.getPersonName() %></td>
            <td><% =person_bean.getPersonAddress() %></td>
        </tr>
<%
    }
%>

int AB = 450;
    int BC = 140;
    int CD = 120;
    int DE = 320;
    int EF = 250;
    int FG = 80;
    String Place1, Place2, Place3, Place4, Place5, Place6, Place7, Place8, Place9, Place10;
    double MPG;
    double MPH;
    double Gallon;
    String Trip1;
    double Hour1;
    int Minute1;
    double Money1;
    int Dist1;
    String String;
    Scanner scan = new Scanner(new File("C:\\Users\\Evelyn\\workspace\\ACSL\\src\\testimput"));
    NumberFormat numfmt = NumberFormat.getCurrencyInstance();
    NumberFormat decfmt = new DecimalFormat("00");
    String delims = "[ ]+[,]";
    MPG = scan.nextDouble();
    Gallon = scan.nextDouble();
    MPH = scan.nextDouble();

    Place1 = scan.next();
    Place2 = scan.next();
    Place3 = scan.next();
    Place4 = scan.next();
    Place5 = scan.next();
    Place6 = scan.next();
    Place7 = scan.next();
    Place8 = scan.next();
    Place9 = scan.next();
    Place10 = scan.next();

Quote:

25, 3.79, 50
A, C
E, F
C, G
B, E
A, G

Exception in thread "main" java.util.InputMismatchException
	at java.util.Scanner.throwFor(Unknown Source)
	at java.util.Scanner.next(Unknown Source)
	at java.util.Scanner.nextDouble(Unknown Source)
	at Prog_2014.main(Prog_2014.java:34)

public class ServletAuthUser extends HttpServlet
{
	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
	  try
	  {
		String sUserName = request.getParameter("username");
		String sPassword = request.getParameter("password");

		String sURL = "Jdbc:Odbc:ServletsDB_DSN";
		String sForName = "sun.jdbc.odbc.JdbcOdbcDriver";
		MyDatabase db = new MyDatabase(sURL, sForName);		
			
		boolean bIsUserValid = (sUserName.equals("admin") && sPassword.equals("admin")) ? true : false;//boolean bIsUserValid = db.AuthUser(sUserName, sPassword);
		db.CloseConnection();
			
		if(bIsUserValid == true)
        		response.sendRedirect("welcome.html");
		else
			response.sendRedirect("error.html");
}

<html>
	<head>
		<title>Welcome</title>
	</head>
	<body>
		<h1>Welcome ADMIN.</h1>
	</body>
</html>