How to Calculate salary and view the record
Name of file-forms.html
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form action="DmlMenu">
Name:<input type="text" name="fname">
Salary:<input type="text" name="sal">
<input type="submit" value="check">
</form>
</body>
</html>
DmlMenu.java(Servlet page)
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//import java.sql.Connection;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class DmlMenu extends HttpServlet {
private static final long serialVersionUID = 1L;
public DmlMenu() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out=response.getWriter();
out.println("Hello DML");
String n=request.getParameter("fname");
int s=Integer.parseInt(request.getParameter("sal"));
out.println(n+s);
Connection conn;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:","hr","hr");
PreparedStatement ps=conn.prepareStatement("insert into myemp values('"+n+"','"+s+"')");
int i=ps.executeUpdate();
out.println(i+" "+"Rows Updated");
out.println("<html>");
out.println("<body>");
out.println("<form action=view>");
out.println("<input type=submit value=view");
out.println("</form>");
out.println("</body>");
out.println("</html>");
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
view.java(Servlet to view data)
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class view
*/
public class view extends HttpServlet {
private static final long serialVersionUID = 1L;
public view() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out=response.getWriter();
out.println("View Page");
Connection conn;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:","hr","hr");
PreparedStatement ps=conn.prepareStatement("select * from myemp");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.println(rs.getString("names"));
out.println("<br/>");
out.println(rs.getInt("salarys"));
}
}
catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
create table myemp
(
names varchar(22),
salarys number(3)
)
Comments
Post a Comment