1.
Display Data Using Servlet
import java.io.*;
import java.io.PrintWriter;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(urlPatterns = {"/NewServlet12"})
public class NewServlet12 extends HttpServlet {
ResultSet rs;
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet NewServlet</title>");
out.println("</head>");
out.println("<body>");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection
nn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","passpass");
Statement
st=nn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATA
BLE);
rs=st.executeQuery("select * from EMPLOYEES");
out.println("<table><tr>");
out.println("<td>ID</td> <td>First Name</td> <td>Last Name</td><td>
Email</td></tr>");
while(rs.next()){
int id =rs.getInt("EMPLOYEE_ID");
String First = rs.getString("FIRST_NAME");
String Last = rs.getString("LAST_NAME");
String Email = rs.getString("EMAIL");
//Display values
out.println("<tr><td>"+id+"</td><td> "+ First +" </td><td>"+ Last +" </td><td>"+
Email +"</td></tr>");
}
out.println("</table><a href=index.html>Back</a>");
out.println("<a href=NewServlet1>next</a>");
out.println("</body>");
out.println("</html>");
rs.close();
st.close();
nn.close();
}
catch (Exception ee){
System.out.print(ee.getMessage());
}}}
2. Registration
A. RegisJSP.jsp
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>User Data</title>
</head>
<body>
<h1>Registration Form</h1>
<form action="Regist" method="post">
<table style="with: 50%">
<tr><td> Student ID</td> <td><input type="text" name="Stuid" /></td></tr>
<tr><td>First Name</td><td><input type="text" name="fname" /></td></tr></table>
<input type="submit" value="register" />
</form>
</body></html>
B.Resist.java
import java.io.*;
import javax.servlet.annotation.WebServlet;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(urlPatterns = {"/Regist"})
public class Regist extends HttpServlet {
ResultSet rs;
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String id = request.getParameter("Stuid");
String fname = request.getParameter("fname");
if (id.isEmpty() || fname.isEmpty()) {
RequestDispatcher rd = request.getRequestDispatcher("newjsp.jsp");
out.println("<font color=red>Please fill all the fields</font>");
rd.include(request, response);
} else {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection
nn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","passpass");
Statement st=nn.createStatement();
String query = "insert into STUDENT(IDNO,NAME) values('"+id+"','"+fname+"')";
st.executeUpdate(query);
out.println("<HTML><BODY><H3>The Data has been added
Successfully</H3></BODY></HTML>");
nn.close();
} catch (Exception e) {
e.getMessage();
}}}}
3. Display Data using JSP
<%@page import="java.sql.*"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<!DOCTYPE html>
<html><body>
<h1>Retrieve data from database in jsp</h1>
<table border="1">
<tr>
<td>IDNO</td>
<td>NAME</td></tr>
<%
try{
ResultSet rs=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection
nn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","passpass");
Statement
st=nn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATA
BLE);
rs=st.executeQuery("select * from STUDENT");
while(rs.next()){
%>
<tr><td><%=rs.getString("IDNO") %></td>
<td><%=rs.getString("NAME") %></td></tr>
<%
}
rs.close();
st.close();
nn.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
</table>
</body>
</html>
RMI Example
1. LoginInterface.java
package login_formm;
import java.rmi.*;
public interface LoginInterface extends Remote {
public boolean getLogin(String user,String pass) throws RemoteException;
}
2. LoginImplement.java
package login_formm;
import java.rmi.*;
import java.rmi.server.UnicastRemoteObject;
public class LoginImplement extends UnicastRemoteObject implements LoginInterface {
public LoginImplement() throws RemoteException{
}
public boolean getLogin(String user,String pass) throws RemoteException{
boolean found=false;
try{
if(user.equals("admin")&&pass.equals("123")){
return found=true;
}
else{
return found=false;
} }
catch(Exception ee){
ee.printStackTrace();
}
return found;
}}
3. LoginServer.java
package login_formm;
import java.rmi.*;
import java.rmi.registry.LocateRegistry;
import java.rmi.registry.Registry;
public class LoginServer {
public static void main(String[] args) {
try{
Registry reg=LocateRegistry.createRegistry(1099);
LoginImplement lpp=new LoginImplement();
reg.rebind("Login", lpp);
System.out.println("Server is Ready");
}
catch(Exception ex){
ex.printStackTrace();
}}}
4.
private void BloginActionPerformed(java.awt.event.ActionEvent evt) {
boolean f=false;
try{
Registry reg=LocateRegistry.getRegistry("127.0.0.1",1099);
LoginInterface lf=(LoginInterface)reg.lookup("Login");
f=lf.getLogin(Tuser.getText(), Tpass.getText());
if(f==true){
JOptionPane.showMessageDialog(null,"Well come succsessfull");
}
else{
JOptionPane.showMessageDialog(null,"fail");
} }
catch(Exception er){
er.printStackTrace();
}
// TODO add your handling code here:
}
