Create a java program with these options: #1 Register a company : Create usernam

Question

Create a java program with these options:

#1 Register a company : Create username and password, company name, stock price and the time

#2 Login a registered user : after entering the password a message apears " your login is successfull" or "your username or password is incorrect"

#3 add the changes to the stock price, by adding the latest stock price and the time of the change

#4 display all the prices in reverse chronological order i.e., starting with the current

price to the beginning price of the day

save usernames and passwords into a file and when we chose #2 retrive the inputed user from the file and put it into a stack to check the correctness of user and passwords

file could be csv or whatever

Explanation / Answer

import java.io.*;  

import java.sql.*;  

import javax.servlet.ServletException;  

import javax.servlet.http.*;  

public class Register extends HttpServlet {  

public void doPost(HttpServletRequest request, HttpServletResponse response)  

            throws ServletException, IOException {  

response.setContentType("text/html");  

PrintWriter out = response.getWriter();  

String n=request.getParameter("userName");  

String p=request.getParameter("userPass");  

String e=request.getParameter("userEmail");  

String c=request.getParameter("userCountry");  

try{  

Class.forName("oracle.jdbc.driver.OracleDriver");  

Connection con=DriverManager.getConnection(  

"jdbc:oracle:thin:@localhost:1521:xe","system","oracle");  

PreparedStatement ps=con.prepareStatement(  

"insert into registeruser values(?,?,?,?)");  

ps.setString(1,n);  

ps.setString(2,p);  

ps.setString(3,e);  

ps.setString(4,c);  

int i=ps.executeUpdate();  

if(i>0)  

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

}catch (Exception e2) {System.out.println(e2);}  

out.close();  

}  

}  

import java.io.*;  

import java.sql.*;  

import javax.servlet.ServletException;  

import javax.servlet.http.*;  

public class Search extends HttpServlet {  

public void doGet(HttpServletRequest request, HttpServletResponse response)  

            throws ServletException, IOException {  

response.setContentType("text/html");  

PrintWriter out = response.getWriter();  

String rollno=request.getParameter("roll");  

int roll=Integer.valueOf(rollno);  

try{  

Class.forName("oracle.jdbc.driver.OracleDriver");  

Connection con=DriverManager.getConnection(  

"jdbc:oracle:thin:@localhost:1521:xe","system","oracle");  

PreparedStatement ps=con.prepareStatement("select * from result where rollno=?");  

ps.setInt(1,roll);  

out.print("<table width=50% border=1>");  

out.print("<caption>Result:</caption>");  

ResultSet rs=ps.executeQuery();  

/* Printing column names */  

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>");  

/* Printing result */  

while(rs.next())  

{  

out.print("<tr><td>"+rs.getInt(1)+"</td><td>"+rs.getString(2)+"  

</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td></tr>");  

}  

out.print("</table>");  

}catch (Exception e2) {e2.printStackTrace();}  

finally{out.close();}  

}  

}

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.