QuestionAsk Questions?
manigandan
Java Hospital management system
3 Answer(s) a year and 4 months ago
Posted in : Servlet Interview Questions
3 Answer(s) a year and 4 months ago
Posted in : Servlet Interview Questions
hospital management
View Answers
January 29, 2012 at 7:05 PM
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<body>
<form action="rejijav.jsp">
<table border="2" align="center">
<tr><td>id</td><td><input type="text" name="id" class="txt"/></td></tr>
<tr><td>fname</td><td><input type="text" name="fname" class="txt"/></td></tr>
<tr><td>lname</td><td><input type="text" name="lname" class="txt"/></td></tr>
<tr><td>age</td><td><input type="text" name="age" class="txt"/></td></tr>
<tr><td>dob</td><td><input type="text" name="dob" class="txt"/></td></tr>
<tr><td>address</td><td><input type="text" name="address" class="txt"/></td></tr>
<tr><td><input type="submit" value="submit"/></td></tr>
</table>
<%
Connection con;
Statement st;
ResultSet rs;
PreparedStatement pst=null;
String id,lname,fname,age,dob,address;
id=request.getParameter("id");
fname=request.getParameter("fname");
lname=request.getParameter("lname");
age=request.getParameter("age");
dob=request.getParameter("dob");
address=request.getParameter("address");
if(id!=null && id!="")
{
int id1=Integer.parseInt(id);
try
{
String Url="jdbc:mysql://localhost:3306/mobile";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(Url,"root","root123");
st=con.createStatement();
if(fname!=null && fname!="")
{
pst=con.prepareStatement("update register set fname=? where id=?");
pst.setString(1,fname);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(lname!=null && lname!="")
{
pst=con.prepareStatement("update register set lname=? where id=?");
pst.setString(1,lname);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(age!=null && age!="")
{
int age1=Integer.parseInt(age);
pst=con.prepareStatement("update register set age=? where id=?");
pst.setInt(1,age1);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(dob!=null && dob!="")
{
pst=con.prepareStatement("update register set dob=? where id=?");
pst.setString(1,dob);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(address!=null && address!="")
{
pst=con.prepareStatement("update register set address=? where id=?");
pst.setString(1,address);
pst.setInt(2,id1);
pst.executeUpdate();
}
out.print("Sucessfull!!!");
}catch(Exception e)
{
out.print(e);
}
}%>
</form>
</body>
</html>
January 29, 2012 at 7:05 PM
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<body>
<form action="rejijav.jsp">
<table border="2" align="center">
<tr><td>id</td><td><input type="text" name="id" class="txt"/></td></tr>
<tr><td>fname</td><td><input type="text" name="fname" class="txt"/></td></tr>
<tr><td>lname</td><td><input type="text" name="lname" class="txt"/></td></tr>
<tr><td>age</td><td><input type="text" name="age" class="txt"/></td></tr>
<tr><td>dob</td><td><input type="text" name="dob" class="txt"/></td></tr>
<tr><td>address</td><td><input type="text" name="address" class="txt"/></td></tr>
<tr><td><input type="submit" value="submit"/></td></tr>
</table>
<%
Connection con;
Statement st;
ResultSet rs;
PreparedStatement pst=null;
String id,lname,fname,age,dob,address;
id=request.getParameter("id");
fname=request.getParameter("fname");
lname=request.getParameter("lname");
age=request.getParameter("age");
dob=request.getParameter("dob");
address=request.getParameter("address");
if(id!=null && id!="")
{
int id1=Integer.parseInt(id);
try
{
String Url="jdbc:mysql://localhost:3306/mobile";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(Url,"root","root123");
st=con.createStatement();
if(fname!=null && fname!="")
{
pst=con.prepareStatement("update register set fname=? where id=?");
pst.setString(1,fname);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(lname!=null && lname!="")
{
pst=con.prepareStatement("update register set lname=? where id=?");
pst.setString(1,lname);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(age!=null && age!="")
{
int age1=Integer.parseInt(age);
pst=con.prepareStatement("update register set age=? where id=?");
pst.setInt(1,age1);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(dob!=null && dob!="")
{
pst=con.prepareStatement("update register set dob=? where id=?");
pst.setString(1,dob);
pst.setInt(2,id1);
pst.executeUpdate();
}
if(address!=null && address!="")
{
pst=con.prepareStatement("update register set address=? where id=?");
pst.setString(1,address);
pst.setInt(2,id1);
pst.executeUpdate();
}
out.print("Sucessfull!!!");
}catch(Exception e)
{
out.print(e);
}
}%>
</form>
</body>
</html>
January 29, 2012 at 7:07 PM
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body >
<form action="delete2.jsp">
<table>
<tr><td>id</td><td><input type="text" name="id" class="txt"/></td></tr>
</table>
<input type="submit" value="Delete"/>
</form>
<%
Connection con;
Statement st;
PreparedStatement pst=null;
String id=request.getParameter("id");
if(id!=null && id!="")
{
int id1=Integer.parseInt(id);
try
{
String Url="jdbc:mysql://localhost:3306/mobile";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(Url,"root","root123");
st=con.createStatement();
pst=con.prepareStatement("delete from register where id=?");
pst.setInt(1,id1);
pst.executeUpdate();
out.println("Deleted Sucessfully");
}catch(Exception e)
{
out.print(e);
}
}%>
</body>
</html>
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
