Homework SourseI really need help on this question Create a program that al
I really need help on this question.
Create a program that allows the user to manage vehicle information including License plate number Owner name Owner phone number The user interface will be text based providing the following capabilities Add up to 100 vehicles Remove specified vehicles View a sorted list of all known license plates View the data for a specified vehicle Save the database contents into a file Load a saved database from a file
-Please and thank you.
Solution
<html>
<head>
<title>Add Photo</title>
</head>
<body>
<h2>Add Photo</h2>
<form id=\"form1\" enctype=\"multipart/form-data\" action=\"addData\" method=\"post\">
<table>
<tr>
<td>Enter Plate Number :</td>
<td><input type=\"text\" name=\"id\"/></td>
</tr>
<tr>
<td>Enter Owner name :</td>
<td><input type=\"text\" name=\"name\"/></td>
</tr>
<tr>
<td>Enter Phno Number </td>
<td><input type=\"text\" name=\"phno\" />
</tr>
</table>
<p/>
<input type=\"submit\" value=\"Add Data\"/>
</form>
<p/>
</body>
</html>
Delete Record
....................
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.http.Cookie;
public class Delete extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType(\"text/html\");
PrintWriter out = response.getWriter();
try {
String email=request.getParameter(\"id\");
Class.forName(\"oracle.jdbc.driver.OracleDriver\");
Connection con=DriverManager.getConnection(\"jdbc:oracle:thin:@localhost:1521:xe\",\"system\",\"tiger\");
Cookie ck[]=request.getCookies();
for(int i=0;i<ck.length;i++)
{
PreparedStatement ps=con.prepareStatement(\"delete from datatable where id=?\");
ps.setString(1,ck[i].toString());
ResultSet rs=ps.executeQuery();
}
response.sendRedirect(\"Tack3\");
}catch(Exception ex)
{
out.println(ex);
}
}
// <editor-fold defaultstate=\"collapsed\" desc=\"HttpServlet methods. Click on the + sign on the left to edit the code.\">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return \"Short description\";
}// </editor-fold>
}
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.http.Cookie;
/**
*
* @author USER
*/
public class Tack3 extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(\"text/html\");
PrintWriter out = response.getWriter();
try {
Class.forName(\"oracle.jdbc.driver.OracleDriver\");
Connection con=DriverManager.getConnection(\"jdbc:oracle:thin:@localhost:1521:xe\",\"system\",\"tiger\");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(\"select * from dataTable\");
out.print(\"<table width=50% border=1 >\");
out.print(\"<caption>Result:</caption>\");
ResultSetMetaData rsmd=rs.getMetaData();
int total=rsmd.getColumnCount();
out.print(\"<tr>\");
for(int i=1;i<=total;i++)
{
out.print(\"<th>\"+rsmd.getColumnName(i)+\"</th>\");
}
out.print(\"</tr>\");
out.println(\"<form action=Delete method=post>\");
while(rs.next())
{
String id=rs.getString(3);
out.print(\"<tr><td><input type=checkbox name=check value=\'\"+id+\"\'></td><td>\"+rs.getString(1)+\"</td><td>\"+rs.getString(2)+\" </td><td>\"+rs.getString(3)+\"</td><td>\"+\"</td></tr>\");
Cookie ck=new Cookie(\"id\",\"id\");
response.addCookie(ck);
}
out.println(\"<input type=submit value=submit></form>\");
}catch (Exception e2)
{
e2.printStackTrace();
}
}
// <editor-fold defaultstate=\"collapsed\" desc=\"HttpServlet methods. Click on the + sign on the left to edit the code.\">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return \"Short description\";
}// </editor-fold>
}
Add data to database
...................
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import javax.servlet.RequestDispatcher;
/**
*
* @author USER
*/
public class LoginVal extends HttpServlet
{
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(\"text/html;charset=UTF-8\");
PrintWriter out = response.getWriter();
try {
String id=request.getParameter(\"id\");
String name=request.getParameter(\"name\");
int phno=Integer.parseInt(request.getParameter(\"phno\"));
Class.forName(\"oracle.jdbc.driver.OracleDriver\");
Connection con=DriverManager.getConnection(\"jdbc:oracle:thin:@localhost:1521:xe\",\"system\",\"tiger\");
PreparedStatement ps=con.prepareStatement(\"insert into dataTable values(?,?,?)\");
ps.setString(1,id);
ps.setInt(2,name);
ps.setString(3,phno);
int i=ps.executeUpdate();
if(i>0)
{
out.println(\"Record added successfully\");
}
}catch(Exception ex)
{
out.println(ex);
}
}
}
