I need help creating a netbeans application and linking database with steps Part II – Next,...

Question

Question

I need help creating a netbeans application and linking database with steps Part II – Next,...

I need help creating a netbeans application and linking database with steps

Part II – Next, build a simple Servlet called LoginServlet in your “Bank” Project. Now make it so that when the Customer logs in, the LoginServlet will get called and will validate the user id and password.

At first, just make sure that the Servlet gets called correctly. So just print a simple message like “LoginServlet Running…”.
Remember, to call the LoginServlet, you will need to modify the FORM tag in the “Login.html” file:

Test it out. When you click the Login Button on the LoginForm, you should see “LoginServlet Running….”

Part III – Now, modify the LoginServlet.

Make it so that when the Servlet gets called, it reads the id and password from the Login Form.

Use : request.getParameter() to get these items. At first just read in these 2 strings and display them to the Server Log.

2.) If the id = “admin” and the Password = “123”, return an HTML page that says “Valid Login”.

3.) If not return an HTML page that says “InValid Login”. Use out.println() to send these HTML messages.

4.) Test out your WebApp.

Part IV– Lastly, create a new LoginServletDB. This time we are going to go to the database to verify the user login. First look at the Bank database. There is a Customers table. In this table there is a UserID and a Passwd. (SHOW STEPS OF CONNECTING DATABASE (.accdb, .mdb) files to NETBEANS IDE 8.2

Write the database code, in your LoginServlet to let anyone of these customers login, using their own ids and passwords.(Hint: You will need to add all 6 database steps[Load Driver, get connection….] to your LoginServletDB. Then get the password from the database and compare it to the one you read from the HTML file.
Remember, to call the LoginServletDB, you will need to modify the FORM tag in the “Login.html” file:

<form action=”http://localhost:8080/Bank/LoginServletDB”

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Login.html

<html>
<head>
<title>Bank login Page</title>
</head>
<body>
<form method="post" action="http://localhost:8080/Bank/LoginServlet.java">
User ID:<input type="text" name="userid" /><br/>
Password:<input type="password" name="pass" /><br/>
<input type="submit" value="login" />
</form>
</body>
</html>

LoginServlet.java validating without using database

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Login extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { //for exception handling
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

String UserId = request.getParameter("userid"); //getting the parameters userId
String Passwrd = request.getParameter("pass"); //getting the parameter password

if(UserId.equls("admin")&&Passwrd.equls('123')) //normal checking of values
       {
           out.println("<h2> Valid login </h2>");
       }
else
{
out.println("<h2> invalid Login </h2>");

}
}
}

LoginServlet.java validation using database

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Login extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { //for exception handling
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

String UserId = request.getParameter("userid"); //getting the parameters userId
String Passwrd = request.getParameter("pass"); //getting the parameter password

       if(checkUser(UserId, Passwrd)) //calling checkUser function to validate user from database
{
out.println("<h2> welcome " + UserId + "</h2>"); //if validation successful print welcome username
       }
else
{
out.println("<h2> invalid Login </h2>");

}
}

public static boolean checkUser(String userid,String pass)
{
boolean st =false;
try {
Class.forName("com.mysql.jdbc.Driver"); //loading drivers for mysql

           //creating connection with the database
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","1234");
PreparedStatement state = conn.prepareStatement("select * from CustomerTab where UserID=? and Passwd=?");
state.setString(1, userid);
state.setString(2, pass);
ResultSet rs = state.executeQuery();
st = rs.next();

}
catch(Exception e) {
e.printStackTrace();
}
return st;
}
}

Add a comment

Answer 2

I need help creating a netbeans application and linking database with steps Part II – Next,...

Homework Answers

Add Answer to:
I need help creating a netbeans application and linking database with steps Part II – Next,...

Post as a guest

Earn Coins

Part I – Build a simple Servlet called MyServlet using NetBeans. Add this Servlet to you...

PHP Programming with MySQL - Why do I get the following error and how do I...

i need help with this python assignment asking for creating a simple database (client application )...

NEED HELP with HTML with Javascript embedding for form validation project below. I have my code...

I have created an HTML form. I need to connect this to a database to update...

// I need help in creating and publishing a website with two pages for this assignment,...

IN php .... I need Help I Need to Modify this application so it uses a...

I need help for part B and C 1) Create a new project in NetBeans called...

Posting this again because day limit has run out. Again I really need help with this....

Form Processing HTML One of the most ubiquitous uses of JavaScript is validating form data on...

I need help creating a netbeans application and linking database with steps Part II – Next,...

Homework Answers

Add Answer to: I need help creating a netbeans application and linking database with steps Part II – Next,...

Post as a guest

Earn Coins

Add Answer to:
I need help creating a netbeans application and linking database with steps Part II – Next,...