JSP Devlopment

 Registration Form in JSP

For making enlistment frame, you should have a table in the database. You can compose the database rationale in JSP record, yet isolating it from the JSP page is better approach. Here, we will utilize DAO, Factory Method, DTO and Singleton configuration designs.

• jsp
• java
• jsp
• java
• java
• java

Example of Registration Form:

CREATE TABLE  "USER432"

(    "NAME" VARCHAR2(4000),

"EMAIL" VARCHAR2(4000),

"PASS" VARCHAR2(4000)

)/

index.jsp

process.jsp

<%@page import="bean.RegisterDao"%>

class="bean.User"/>

<%

int status=RegisterDao.register(obj);

if(status>0)

out.print("You are successfully registered");

%>

User.java

public class User {  package bean;

private String uname,upass,uemail;

public String getUname() {

return uname;

}

public void setUname(String uname) {

this.uname = uname;

}  public String getUpass() {

return upass;

}  public void setUpass(String upass) {

this.upass = upass;

}

public String getUemail() {

return uemail;

}

public void setUemail(String uemail) {

this.uemail = uemail;  }

}

Provider.java

package bean;

public interface Provider {

String DRIVER="oracle.jdbc.driver.OracleDriver";

String CONNECTION_URL="jdbc:oracle:thin:@localhost:1521:xe";

String USERNAME="system";

String PASSWORD="oracle";

}

ConnectionProvider.java

package bean;

import java.sql.*;

import static bean.Provider.*;

public class ConnectionProvider {

private static Connection con=null;

static{

try{

Class.forName(DRIVER);

con=DriverManager.getConnection(CONNECTION_URL,USERNAME,PASSWORD);

}catch(Exception e){}

}

public static Connection getCon(){

return con;

}

}

RegisterDao.java:

package bean;

import java.sql.*;

public class RegisterDao {

public static int register(User u){

int status=0;

try{

Connection con=ConnectionProvider.getCon();

PreparedStatement ps=con.prepareStatement("insert into user432 values(?,?,?)");

ps.setString(1,u.getUname());

ps.setString(2,u.getUemail());

ps.setString(3,u.getUpass());

status=ps.executeUpdate();

}catch(Exception e){}

return status;

}

}

JAVA Tutorial Video

[embed]https://www.youtube.com/watch?v=Mb8nG-NH6gg&t=2835s[/embed]Login and Logout:The DAO (Data Access Object), Factory method and DTO (Data Transfer Object) design patterns.

• jsp
• jsp
• jsp
• java
• java
• java
• java

 Example:logout.jsp  profile.jsp CREATE TABLE  "USER432"(    "NAME" VARCHAR2(4000),.          "EMAIL" VARCHAR2(4000),"PASS" VARCHAR2(4000))/index.jsp:login|logout|profilelogin.jsp:<%@ include file="index.jsp" %>

---

Login Form

<%String profile_msg=(String)request.getAttribute("profile_msg");if(profile_msg!=null){out.print(profile_msg);}String login_msg=(String)request.getAttribute("login_msg");if(login_msg!=null){out.print(login_msg);}%>
Email:

Password:

"loginprocess.jsp:<%@page import="bean.LoginDao"%>class="bean.LoginBean"/><%boolean status=LoginDao.validate(obj);if(status){out.println("You r successfully logged in");session.setAttribute("session","TRUE");}else{out.print("Sorry, email or password error");%><%}%>LoginBean.java:package bean;public class LoginBean {private String email,pass;public String getEmail() {return email;}       public void setEmail(String email) {this.email = email;}public String getPass() {return pass;}public void setPass(String pass) {this.pass = pass;}}Provider.java:package bean;public interface Provider {String DRIVER="oracle.jdbc.driver.OracleDriver";String CONNECTION_URL="jdbc:oracle:thin:@localhost:1521:xe";String USERNAME="system";String PASSWORD="oracle";}ConnectionProvider.javapackage bean;import java.sql.*;import static bean.Provider.*;public class ConnectionProvider {private static Connection con=null;static{try{Class.forName(DRIVER);con=DriverManager.getConnection(CONNECTION_URL,USERNAME,PASSWORD);}catch(Exception e){}}  public static Connection getCon(){return con;  }}LoginDao.javapackage bean;import java.sql.*;public class LoginDao {public static boolean validate(LoginBean bean){boolean status=false;try{Connection con=ConnectionProvider.getCon();PreparedStatement ps=con.prepareStatement("select * from user432 where email=? and pass=?");ps.setString(1,bean.getEmail());ps.setString(2, bean.getPass());ResultSet rs=ps.executeQuery();status=rs.next();}catch(Exception e){}return status;}}Uploading file to the server using JSP:There are numerous approaches to transfer the document to the server. One of the path is by the MultipartRequest class. For utilizing this class you need the cos.jar document. In this illustration, we are giving the cos.jar document alongwith the code.MultipartRequest class : It is an utility class to deal with the multipart/shape information ask. There are numerous constructors characterized in the MultipartRequest class.Commonly used Constructors of MultipartRequest class:

• MultipartRequest(HttpServletRequest request, String saveDirectory)
• MultipartRequest(HttpServletRequest request, String saveDirectory, int maxPostSize)
• MultipartRequest(HttpServletRequest request, String saveDirectory, int maxPostSize, String encoding)

index.jspSelect File:
 upload.jsp:<%@ page import="com.oreilly.servlet.MultipartRequest" %><%MultipartRequest m = new MultipartRequest(request, "d:/new");out.print("successfully uploaded");%>Downloading file from the server using JSP :In this illustration, we will download the jsp record. Be that as it may, you may download any document. For downloading the record from the server, you ought to determine the substance sort named APPLICATION/OCTET-STREAM.index.jspdownload the jsp filedownload.jsp<%String filename = "home.jsp";String filepath = "e:\\";response.setContentType("APPLICATION/OCTET-STREAM");response.setHeader("Content-Disposition","attachment; filename=\"" + filename + "\"");java.io.FileInputStream fileInputStream=new java.io.FileInputStream(filepath + filename);int i;while ((i=fileInputStream.read()) != -1) {out.write(i);}fileInputStream.close();%>