Forum:

Other IDEs, Version Control

Problem in record viewing

Greenhorn

Posts: 7

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hai i am having problem in record viewing that is i can view the record in eclipse ide but once i closed and reopen the ide i cannot view the record i dont know what is the problem whether my code is wrong or not i dont know will you please check the code and tell where is the problem.Please reply me anybody.
shall i send the code

package myservlets;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class Nurse
 */
public class Doctor extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Doctor() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */

public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
       	
       	doGet(request , response );
       	
       }
       
       
      public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
   	   
   	   response.setContentType("text/html");
      	PrintWriter out = response.getWriter();

System.out.println("MySQL Connect Example.");
      	Connection conn = null;
      	Object PreparedStatement =null;
      	
      	String url = "jdbc:mysql://localhost:3306/";
      	String dbName = "dentist";
      	String driver = "com.mysql.jdbc.Driver";
      	String userName = "root"; 
      	String password = "admin";

String doc_id = request.getParameter("doc_id"); 
      	String first_name = request.getParameter("first_name");
      	String last_name = request.getParameter("last_name");
      	String sex = request.getParameter("sex");
      	String grade = request.getParameter("grade");
      	String e_mail = request.getParameter("e_mail");
      	String bttn_value = request.getParameter("submit");
      	
      	
      	Statement st;

try {

java.util.Date date = new java.util.Date();
      		Class.forName(driver).newInstance();
      		conn = DriverManager.getConnection(url+dbName,userName,password);
      		System.out.println("Connected to the database");
      		
      		int i=0;
      		if(bttn_value.equals("Add"))
      		{
      			String query_1 = "insert into doctor_details set first_name='"+first_name+"',last_name='"+last_name+"',sex='"+sex+"',grade='"+grade+"',e_mail='"+e_mail+"'";
      			out.println("query_1 " + query_1);
      			out.println("<br>");
      			st = conn.createStatement();
      			i = st.executeUpdate(query_1);
      			out.println("<br>");
      			out.println("i " + i);
      			
      			response.sendRedirect("http://localhost:8080/Employee/Doctor.jsp");
      		}
      		else if(bttn_value.equals("Update"))
      		{

String query_1 = "update  doctor_details set first_name='"+first_name+"',last_name='"+last_name+"' ,sex='"+sex+"',grade='"+grade+"',e_mail='"+e_mail+"'where doc_id='"+doc_id+"'";
      			out.println("query_1 " + query_1);
      			out.println("<br>");
      			st = conn.createStatement();
      			i = st.executeUpdate(query_1);
      			out.println("<br>");
      			out.println("i " + i);
      		
      			response.sendRedirect("http://localhost:8080/Employee/Doctor.jsp");
      		}

// pw.println(query1);
   conn.close();
   System.out.println("Disconnected from database");
   } catch (Exception e) {
   response.sendRedirect("DoctorView");
   e.printStackTrace();
   }
   }
}

<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
  <style>
  .tdcls{
  font-weight:bold;
}
A:visited  {color: #00000;font-weight:bold; text-decoration: underline}
A:link  {color: #FFC0C0; text-decoration: none}
A:active  {color: #C0FFC0; text-decoration: none}
A:hover   { color: #FF0000;  text-decoration: none}
  </style>
  <script>
  function validate()
  {
	  
	   if(document.frm.first_name.value=="")
	  {
		    alert("Please enter first name");
			document.frm.first_name.focus();
			return false;
	  }
	   if(document.frm.last_name.value=="")
	  {
		    alert("Please enter last name");
			document.frm.last_name.focus();
			return false;
	  }
	   
	  return true;
	   
  }
  </script>
  
   <script Language="JavaScript">
   function validatecombo(){
     var selectedCombobox=(frm.sex.value);
     if (selectedCombobox=="0") {
       alert("Please Select Sex");
       return false;
     }
     var selectedCombobox=(frm.grade.value);
     if (selectedCombobox=="0") {
       alert("Please Select Grade");
       return false;
     }
    
     return true;
   }
 </script>
  
  
  
  
  
  <script language = "Javascript">

function emailcheck(str) {

var at="@"
var dot="."
var lat=str.indexOf(at)
var lstr=str.length
var ldot=str.indexOf(dot)
if (str.indexOf(at)==-1){
alert("Invalid E-mail ID")
return false
}

if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
alert("Invalid E-mail ID")
return false
}

if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
alert("Invalid E-mail ID")
return false
}

if (str.indexOf(at,(lat+1))!=-1){
alert("Invalid E-mail ID")
return false
}

if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
alert("Invalid E-mail ID")
return false
}

if (str.indexOf(dot,(lat+2))==-1){
alert("Invalid E-mail ID")
return false
}

if (str.indexOf(" ")!=-1){
alert("Invalid E-mail ID")
return false
}
alert("valid E-mail ID")
return true 
}

function ValidateEmail(){
var emailID=document.frm.e_mail

if ((emailID.value==null)||(emailID.value=="")){
alert("Please Enter your Email Address")
emailID.focus()
return false
}
if (emailcheck(emailID.value)==false){
emailID.value=""
emailID.focus()
return false
}
return true
}
</script>
  
  
  
  
  
  
  
 </HEAD>

<BODY background="E:\projects\java\Employee\toothimg.bmp">
 <br><br>
 
 <form name="frm" action="http://localhost:8080/Employee/Doctor" method="post" onSubmit="return validate(),validatecombo(),ValidateEmail();">
 <%
 String doc_id = "";
  String first_name = "";
  String last_name = "";
 
  String sex = "";
  String grade = "";
  String e_mail = "";
  String readonly="";
String  bttn_value="Add";

if(request.getParameter("doc_id")!=null && request.getParameter("doc_id")!="")
 {
    doc_id= request.getParameter("doc_id").toString();
	 
   readonly = "readonly";
    Connection conn = null;
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "dentist";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "root"; 
    String password = "admin";
	bttn_value = "Update";
 
	Statement st;
	
	 
    try {
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      System.out.println("Connected to the database");
	
	   String query2 = "SELECT * from doctor_details where doc_id='"+doc_id+"'";
	 
 
	  st = conn.createStatement();

ResultSet rs2 = st.executeQuery(query2);

while(rs2.next())
		{
			  first_name = rs2.getString(2);
             last_name = rs2.getString(3);
             sex=rs2.getString(4);
             grade=rs2.getString(5);
             e_mail=rs2.getString(6);
			 
		}
		
	}
 
	catch (Exception e) {
      e.printStackTrace();
    }
    
 }

%>
   
  <table cellpadding=5 cellspacing=3 border=0>

<th  colspan=2>
		<font size=5 color="#DB70DB">Doctor Details</font>
		<br><font size=1></font>
	</th>
   <br>
   <br>
   
   <tr><td class="tdcls">First Name</td><td><input type="text" name="first_name" value="<%=first_name%>"></td></tr> 
      <tr><td class="tdcls">Last Name</td><td><input type="text" name="last_name" value="<%=last_name%>"></td></tr> 
      
	     <tr><td class="tdcls">Sex</td>
		 <td><select name="sex">
		 
		<option value=0>------Select------</option>
		    <option value="Male" <% if(sex.equals("Male"))out.println("selected");%>>Male</option>
		      <option value="Female" <% if(sex.equals("Female"))out.println("selected");%>>Female</option>
			</select>
			</td></tr>
			
			<tr><td class="tdcls">Grade</td>
			<td><select name="grade">
		 <option value=0>------Select------</option>
		
		    <option value="A" <% if(grade.equals("A"))out.println("selected");%>>A</option>
		      <option value="B" <% if(grade.equals("B"))out.println("selected");%>>B</option>
			</select>
			</td></tr>
			
			
		 <tr><td class="tdcls">Email</td><td><input type="text" name="e_mail" value="<%=e_mail%>"></td></tr> 
		  
     <tr><td colspan=2 align="center"><input type="submit" name="submit" value="<%=bttn_value%>">
      <input type="reset" value="Reset"></td></tr>
    </table>
	<br><br>
	<%
	 if(!(request.getParameter("doc_id")!=null && request.getParameter("doc_id")!=""));
		 
 
	 %>
	  <table width="100%" align="center">
	   <tr><td  align="center"><input type=button value="Back" onCLick="history.back()">
	   </td></tr>
    </table>
	 
	 
	 
	<table width="100%" align="center">
	   <tr><td  align="center"><a href="http://localhost:8080/Employee/DoctorView.jsp">Click here To show all records</a></td></tr>
    </table>
    
     <table width="100%" align="left">
	   <tr><td  align="center"><a href="http://localhost:8080/Employee/DoctorPatient.jsp">View Appointment</a></td></tr>
    </table>
    
    
    
    
    
    
	<%
 
 %>
	        
 </BODY>
</HTML>

this is my DoctorView.jsp

<%@page import="java.util.*"%>
<html>

<head>
<title>Doctor Details form</title>
<style>
A:visited  {color: #00000;font-weight:bold; text-decoration: underline}
A:link  {color: #FFC0C0; text-decoration: none}
A:active  {color: #C0FFC0; text-decoration: none}
A:hover   { color: #FF0000;  text-decoration: none}
.loginhead1{
text-align:left;
padding-left:5px;
}
</style>
</head>

<body>
<center>
<table border="1" width="800px" cellspacing="0" cellpadding="0" bgcolor="bluelight">
 <tr>
<td width="10%" class="loginhead1" align="center"><b>ID</b></td> 
<td width="10%" class="loginhead1" align="center"><b>FirstName</b></td>
<td width="19%" class="loginhead1" align="center"><b>LastName</b></td>
<td width="19%" class="loginhead1" align="center"><b>Sex</b></td>
<td width="19%" class="loginhead1" align="center"><b>Grade</b></td>

<td width="14%" class="loginhead1" align="center"><b>Update</b></td>
<td width="14%" class="loginhead1" align="center"><b>Delete</b></td>

</tr>
<%
//String ename="";

ArrayList  arList=null;
 ArrayList AdminPendrequest = (ArrayList)session.getAttribute("arDataList");
  //out.println(AdminPendrequest);
  out.println("<br>");
   int count=0;

if(AdminPendrequest!= null){
 for(int i=0;i<AdminPendrequest.size();i++)
	{
	   count++;
	  arList = (ArrayList)AdminPendrequest.get(i);
   
		  
	String doc_id =arList.get(0).toString();
	String first_name = arList.get(1).toString();
	String last_name = arList.get(2).toString();
	
	String sex = arList.get(3).toString();
	String grade = arList.get(4).toString();
	//String e_mail = arList.get(5).toString();
	//String date_of_joining = arList.get(6).toString();
	 //ename = first_name+ " " + last_name;
	
	
 
	 %>

<td width="19%" class="loginhead1" align="center"><input type="submit" name="submit" value="Update"></input></td>
<td width="19%" class="loginhead1" align="center"><a href='http://localhost:8080/Employee/DeleteRecord'>Delete
                                          </a>
	 <%

</tr>   
</form>
	 <%
		}

}
%>
	
 
</table>
<br>
<br>

<table>
<tr><td  align="center"><a href="Doctor.jsp">Add More Doctor</a></td></tr>
</table>

</center>

</html>

this is my DoctorView.java

package myservlets;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * Servlet implementation class DoctorView
 */
public class DoctorView extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DoctorView() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException,IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();

System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "dentist";
String driver = "com.mysql.jdbc.Driver";
String userName = "root"; 
String password = "admin";

Statement st;
ArrayList arData=null;
ArrayList arDataList=new ArrayList();
HttpSession session=request.getSession(true);
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Connected to the database");
String query = "SELECT *from doctor_details";

st = conn.createStatement();

ResultSet rs = st.executeQuery(query);

while(rs.next())
{
arData=new  ArrayList();

arData.add(rs.getInt(1));
arData.add(rs.getString(2));
arData.add(rs.getString(3));
arData.add(rs.getString(4));
arData.add(rs.getString(5));

arDataList.add(arData);
}

pw.println("query4 " + query);
pw.println("<br>");

session.setAttribute("arDataList",arDataList);
pw.println("arData " + arData);
pw.println("<br>");
pw.println("arDataList " + arDataList);
pw.println("<br>");
pw.println("session "+ session.getAttribute("arDataList"));
pw.println("<br>");
response.sendRedirect("DoctorView");

pw.println(query);
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
response.sendRedirect("DoctorView");
e.printStackTrace();
}
}

}

David Newton

Author

Posts: 12617

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Oh, my.

What *exactly* happens? Are you getting a message saying a port is already in use?

sakthi ramaraj

Greenhorn

Posts: 7

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

no i am getting any error at all i cannot able to view the record after i closed the eclipse ide and reopen it.

but once i rewrite the link in jsp page i can view it i dont know what is the problem can you tell what is the problem i am having.i.e in code i tell it

here in this link once i rewrite the jsp and run it is working and once i closed it i cannot view it .
reply me soon i have to finish the task today itself.

Consider Paul's rocket mass heater.