simple web application using servlet and jsp in eclipse

Now, the Registration Part is Completed now will code for the login part. Out.println('data inserted sucessfully') Stmt.executeUpdate('insert into user (uname,upass,email)values(''+name+'',''+pass+'',''+email+'')')

String email = request.getParameter('email') String pass = request.getParameter('pass') String name = request.getParameter('name') when the user enters the user name and password and hits the login button the request will be sent to “Login.java” Ĭreate a servlet with the name “Main.java” that will get requests from “registration.jsp” and create an object of MyDb class to create a connection with MySQL and send the data to the MYSQL user table. Let’s create one more JSP or HTML file with the name “login.jsp or login.html”, this view(JSP file) contains two input fields and a login button. Ĭreate another HTML form to perform login activity. Create a connection with MYSQL DriverManager.getConnection('jdbc:mysql://localhost:3306/mydb', 'root', 'root') import Ĭon = DriverManager.getConnection('jdbc:mysql://localhost:3306/mydb', 'root', 'root') Ĭreate a JSP or HTML file with the name “registration.jsp”. this file contains HTML elements and an HTML form to design a registration form and when the user clicks on the registration button the request will be sent to “Main.java” which is defined into the action attribute of the form.Define a Connection variable public Connection con.Steps to create database connection with Java Below is the code for “MyDb.java”. this class contains method “getCon()” that will return a MySQL connection. PRIMARY KEY (`uid`)) Create MYSQL Database connection with JavaĬreate a class name as “MyDb.java” that will be responsible to create a database connection with MySQL. that will be required at the time of database connectivity with Java. Configure your MYSQL databaseĬreate a new database with the name “ mydb” and table name “user”. also, remember your database connection URL, User Name, and Password.

Let’s start the java database connectivity(JDBC) with MySQL. Tools and Technology to create a Java web project

Simple web application using servlet and jsp in eclipse