📄 newregister1.jsp
字号:
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!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>New Hospital</title>
<style type="text/css">
<!--
.style22 {
font-size: 18px;
color: #6600CC;
font-weight: bold;
}
.style35 {color: #CC6600; font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 16px; }
.style39 {color: #009900; font-weight: bold; font-size: 14px; }
.style40 {font-size: 14px}
.style41 {font-size: 16px}
.style42 {
color: #660000;
font-size: 14px;
font-family: "Times New Roman", Times, serif;
}
-->
</style>
</head>
<script language="javascript">
function validate(frm)
{
if(frm.firstname.value=="")
{
alert("First Name is Empty");
return false;
}
if(frm.middlename.value=="")
{
alert("Middle Name is Empty");
return false;
}
if(frm.Lastname.value=="")
{
alert("Last Name is Empty");
return false;
}
if(frm.address.value=="")
{
alert("Address is Empty");
return false;
}
if(frm.age.value=="")
{
alert("Age is Empty");
return false;
}
if(frm.gender.value==-1)
{
alert("Please select your gender");
return false;
}
if(frm.date1.value=="")
{
alert("Date is Empty");
return false;
}
if(frm.place.value=="")
{
alert("Place is empty");
return false;
}
if(frm.email1.value=="")
{
alert("Enter your email id");
return false;
}
}
</script>
<body>
<form name="form1" method="post" action="" onSubmit="return validate(form1)">
<table width="838" border="1" align="center" bordercolor="#00CC00">
<tr>
<td width="828" height="310" align="center" valign="middle" bordercolor="#00CC00" background="Ayur2.JPG"><div align="center"></div></td>
</tr>
<tr>
<td height="485" align="center" valign="top" bordercolor="#00CC00"><div align="center">
<table width="818" border="0">
<tr>
<td width="225" valign="top"><p> </p>
<table width="100%" >
<tr>
<td height="418" valign="top" background="parch-ayur.gif"><p> </p>
<p> </p>
<table width="97%" >
<tr>
<td height="25" valign="middle"><div align="center" class="style39"><u><a href="newhome1.jsp">HOME</a></u></div></td>
</tr>
<tr>
<td height="26" valign="middle"><div align="center" class="style39"><u><a href="new_kle_society.jsp">KLE SOCIETY</a> </u></div></td>
</tr>
<tr>
<td height="28" valign="middle"><div align="center" class="style39">
<p><u>ABOUT AYURVEDA</u></p>
</div></td>
</tr>
<tr>
<td height="28" valign="middle"><div align="center" class="style39"><u>DEPARTMENTS</u></div></td>
</tr>
<tr>
<td height="22" valign="middle"><div align="center" class="style39"><u><a href="newpanch1.jsp">FACILITIES</a></u></div></td>
</tr>
<tr>
<td height="25" valign="middle"><div align="center" class="style39"><u><a href="newregister1.jsp">REGISTER</a></u></div></td>
</tr>
<tr>
<td height="24" valign="middle"><div align="center" class="style39"><u>LOGIN</u></div></td>
</tr>
<tr>
<td height="26" valign="middle"><div align="center" class="style39"><u>VIEW PROFILE</u> </div></td>
</tr>
<tr>
<td height="27" valign="middle"><div align="center"><span class="style39"><u>CONTACT US </u></span></div></td>
</tr>
</table>
<p> </p></td>
</tr>
<tr>
<td height="21"> </td>
</tr>
</table></td>
<td width="583" align="center" valign="top"><div align="right">
<p align="center" class="style22 style42"><marquee>Please enter your details to get the admission in the hospital...</marquee> </p>
<p align="center" class="style22"><u>KLE's B.M.KANKANWADI AYURVED HOSPITAL</u></p>
<table width="59%" border="0" align="center">
<tr>
<td><div align="center" class="style35">First Name:</div></td>
<td><div align="left">
<input name="firstname" type="text" id="firstname">
</div></td>
</tr>
<tr>
<td><div align="center" class="style35">Middle Name: </div></td>
<td><div align="left">
<input name="middlename" type="text" id="middlename">
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style35">Last Name: </span></div></td>
<td><div align="left">
<input name="lastnmae" type="text" id="lastnmae">
</div></td>
</tr>
<tr>
<td><div align="center" class="style35">Address:</div></td>
<td><div align="left">
<textarea name="address" id="address"></textarea>
</div></td>
</tr>
<tr>
<td><div align="center" class="style35">Age:</div></td>
<td><div align="left">
<input name="age" type="text" id="age">
</div></td>
</tr>
<tr>
<td height="25"><div align="center" class="style35">Gender:</div></td>
<td><div align="left">
<select name="gender" id="gender">
<option value="-1">Select </option>
<option value="m">Male</option>
<option value="f">Female</option>
</select>
</div></td>
</tr>
<tr>
<td><div align="center" class="style35">Diagnosis:</div></td>
<td><div align="left">
<textarea name="diagnosis" id="diagnosis"></textarea>
</div></td>
</tr>
<tr>
<td height="24"><div align="center" class="style35">Date:</div></td>
<td><p align="left">
<input name="date1" type="text" id="date1" value="dd/mm/yyyy">
</p></td>
</tr>
<tr>
<td height="28"><div align="center" class="style35">Place:</div></td>
<td><p align="left">
<input name="place" type="text" id="place">
</p></td>
</tr>
<tr>
<td height="28"><div align="center" class="style35">Email:</div></td>
<td><div align="left">
<input name="email1" type="text" id="email1">
</div></td>
</tr>
<tr>
<td height="28"> </td>
<td><div align="left">
<input name="Register" type="submit" id="Register" value="Register">
<input name="cancel" type="submit" id="cancel" value="Cancel">
</div></td>
</tr>
</table>
<p align="center" class="style22"><span class="style40">ALREADY REGISTERED?</span> <u><span class="style41">LOGIN</span> </u></p>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
<div align="center"></div>
</form>
<%
if(request.getMethod().equals("POST"))
{
String firstname,middlename,lastname,address,age,gender,diagnosis,date1,place,email1,opdnumber;
boolean flag=false;
firstname=request.getParameter("firstname");
middlename=request.getParameter("middlename");
lastname=request.getParameter("lastname");
address=request.getParameter("address");
age=request.getParameter("age");
gender=request.getParameter("gender");
diagnosis=request.getParameter("diagnosis");
date1=request.getParameter("date1");
place=request.getParameter("place");
email1=request.getParameter("email1");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:padduDB");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from opdregister");
while(rs.next())
{
//if(firstname.equals(rs.getString("firstname")))
if(firstname.equals(rs.getString("firstname"))&& email1.equals(rs.getString("email1")))
{
flag=true;
break;
}
else
{
flag=false;
}
}
if(flag)
{
out.println("<script language='javascript'>alert('Registration Unsuccessful')</script>");
//out.print("not registered");
}
else
//'"+firstname+"','"+middlename+"','"+lastname+"','"+address+"','"+age+"','"+gender+"','"+diagnosis+"','"+date1+"','"+place+"','"+email1+"'
{
PreparedStatement insertStmt=con.prepareStatement("INSERT INTO opdregister(firstname,middlename,lastname,address,age,gender,diagnosis,date1,place,email1) values(?,?,?,?,?,?,?,?,?,?)");
insertStmt.setString(1,firstname);
insertStmt.setString(2,middlename);
insertStmt.setString(3,lastname);
insertStmt.setString(4,address);
insertStmt.setString(5,age);
insertStmt.setString(6,gender);
insertStmt.setString(7,diagnosis);
insertStmt.setString(8,date1);
insertStmt.setString(9,place);
insertStmt.setString(10,email1);
insertStmt.executeUpdate();
out.println("<script language='javascript'>alert('Registration Successful')</script>");
//response.sendRedirect("new_opd_register.jsp?&firstname="+firstname+"&email1="+email1);
//response.sendRedirect("new_opd_register.jsp");
}
}
catch(Exception e)
{
out.println(e);
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -