hospital management bill

hospital management bill

bill preperation

View Answers

January 29, 2012 at 7:16 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>
<%
Connection con;
Statement st;
String id,dfee,mfee,rfee,sfee;
id=request.getParameter("id");
dfee=request.getParameter("dfee");
mfee=request.getParameter("mfee");
rfee=request.getParameter("rfee");
sfee=request.getParameter("sfee");
//if(id!=null && id!="")
       {
  // int id1=Integer.parseInt(id);
      int dfee1=Integer.parseInt(dfee);
      int mfee1=Integer.parseInt(mfee);
      int rfee1=Integer.parseInt(rfee);
      int sfee1=Integer.parseInt(sfee);
      int tot=dfee1+mfee1+rfee1+sfee1;
    try
       {   
    String Url="jdbc:mysql://localhost:3306/mobile";
    Class.forName("com.mysql.jdbc.Driver");   
    con=DriverManager.getConnection(Url,"root","root123");
    st=con.createStatement();
    st.executeUpdate("insert into bill(dfee,mfee,rfee,sfee,tot) values('"+dfee+"','"+mfee+"','"+rfee+"','"+sfee+"','"+tot+"');");
    response.sendRedirect("http://localhost:8080/yahoo/billlfinal.jsp");
    //out.print("Sucessfull!!!");
     }catch(Exception e)
       {
    out.print(e);
       }
}%>

    </body>
</html>

January 29, 2012 at 7:16 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>
<%
Connection con;
Statement st;
String id,dfee,mfee,rfee,sfee;
id=request.getParameter("id");
dfee=request.getParameter("dfee");
mfee=request.getParameter("mfee");
rfee=request.getParameter("rfee");
sfee=request.getParameter("sfee");
//if(id!=null && id!="")
       {
  // int id1=Integer.parseInt(id);
      int dfee1=Integer.parseInt(dfee);
      int mfee1=Integer.parseInt(mfee);
      int rfee1=Integer.parseInt(rfee);
      int sfee1=Integer.parseInt(sfee);
      int tot=dfee1+mfee1+rfee1+sfee1;
    try
       {   
    String Url="jdbc:mysql://localhost:3306/mobile";
    Class.forName("com.mysql.jdbc.Driver");   
    con=DriverManager.getConnection(Url,"root","root123");
    st=con.createStatement();
    st.executeUpdate("insert into bill(dfee,mfee,rfee,sfee,tot) values('"+dfee+"','"+mfee+"','"+rfee+"','"+sfee+"','"+tot+"');");
    response.sendRedirect("http://localhost:8080/yahoo/billlfinal.jsp");
    //out.print("Sucessfull!!!");
     }catch(Exception e)
       {
    out.print(e);
       }
}%>

    </body>
</html>

January 29, 2012 at 9:21 PM

<body>

<%@page import="java.sql.*" %>

<!DOCTYPE html>

<html>

<body>
<%

int newid=0;
Connection con;
Statement st;
ResultSet rs=null;
PreparedStatement pst=null;
try
   {   
String Url="jdbc:mysql://localhost:3306/mobile";
Class.forName("com.mysql.jdbc.Driver");   
con=DriverManager.getConnection(Url,"root","root123");
st=con.createStatement();
rs=st.executeQuery("select * from bill order by id desc limit 1");
while(rs.next())
   {
newid=rs.getInt(1);
   }

pst=con.prepareStatement("select id,dfee,mfee,rfee,sfee,tot from bill where id=?");
            pst.setInt(1,newid);
            rs=pst.executeQuery();
}catch(Exception e)
   {
out.print(e);
   }

%>

<table>
<caption>Final Bill</caption>
<%
while(rs.next())
           {
    %>
<tr><td>Id</td><td><%=rs.getInt(1)%></td></tr>   
<tr><td>Doctor fee</td><td><%=rs.getInt(2)%></td></tr>
<tr><td>Medicine fee</td><td><%=rs.getString(3)%></td>
<tr><td>Room Fee</td><td><%=rs.getString(4)%></td>
<tr><td>Special Fee</td><td><%=rs.getString(5)%></td>
<tr><td>Total Fees</td><td><%=rs.getString(6)%></td>
    <%
           }%>
</table>
<%
%>
            </form>
   </body>

January 29, 2012 at 9:21 PM

<script lang="javascript">
function search()
{
window.location.href="search.jsp";

}
function valid()
{
    //var uname=document.getElementById("u1");
    var uname = document.myform.user.value;
    //var pass=document.getElementById("p1");
    var pass = document.myform.pass.value;
    if(uname=="" || uname==null)
        {
            alert("Please Enter User Name");
            uname.focus();
            return false;
        }
        if(pass=="" || pass==null)
        {
            alert("Please Enter password");
            pass.focus();
            return false;
        }
        return true;

}
</script>

</head>
<body>

<form name="myform" action="Third.jsp" onsubmit="return valid()">
<table border="2" align="center">
<tr><td>username</td><td><input type="text" name="user" id="u1"/></td></tr>
<tr><td>password</td><td><input type="Password" name="pass" id="p1"/></td></tr>
<tr><td><input type="submit" value="submit"/></td><td><input type="button" value="search" onclick="search()"/></td></tr>

</table>
<label for="name">male</label>
</form>
 </body>

January 29, 2012 at 9:24 PM

<script lang="javascript">
    function search()
    {
    window.location.href="search.jsp";

    }
    function valid()
    {
        //var uname=document.getElementById("u1");
        var uname = document.myform.user.value;
        //var pass=document.getElementById("p1");
        var pass = document.myform.pass.value;
        if(uname=="" || uname==null)
            {
                alert("Please Enter User Name");
                uname.focus();
                return false;
            }
            if(pass=="" || pass==null)
            {
                alert("Please Enter password");
                pass.focus();
                return false;
            }
            return true;

    }
    </script>

</head>
<body>

<form name="myform" action="Third.jsp" onsubmit="return valid()">
<table border="2" align="center">
    <tr><td>username</td><td><input type="text" name="user" id="u1"/></td></tr>
    <tr><td>password</td><td><input type="Password" name="pass" id="p1"/></td></tr>
    <tr><td><input type="submit" value="submit"/></td><td><input type="button" value="search" onclick="search()"/></td></tr>

</table>
<label for="name">male</label>
    </form>
     </body>

January 29, 2012 at 9:31 PM

</head>
<body>

    <form name="myform" action="Third.jsp" onsubmit="return valid()">
        <table border="2" align="center">
            <tr><td>username</td><td><input type="text" name="user" id="u1"/></td></tr>
            <tr><td>password</td><td><input type="Password" name="pass" id="p1"/></td></tr>
            <tr><td><input type="submit" value="submit"/></td><td><input type="button" value="search" onclick="search()"/></td></tr>

        </table>
        <label for="name">male</label>
            </form>
             </body>

January 29, 2012 at 9:31 PM

<script lang="javascript">
    function search()
    {
    window.location.href="search.jsp";

    }
    function valid()
    {
        //var uname=document.getElementById("u1");
        var uname = document.myform.user.value;
        //var pass=document.getElementById("p1");
        var pass = document.myform.pass.value;
        if(uname=="" || uname==null)
            {
                alert("Please Enter User Name");
                uname.focus();
                return false;
            }
            if(pass=="" || pass==null)
            {
                alert("Please Enter password");
                pass.focus();
                return false;
            }
            return true;

    }
    </script>

</head>
<body>

<form name="myform" action="Third.jsp" onsubmit="return valid()">
<table border="2" align="center">
    <tr><td>username</td><td><input type="text" name="user" id="u1"/></td></tr>
    <tr><td>password</td><td><input type="Password" name="pass" id="p1"/></td></tr>
    <tr><td><input type="submit" value="submit"/></td><td><input type="button" value="search" onclick="search()"/></td></tr>

</table>
<label for="name">male</label>
    </form>
     </body>


January 29, 2012 at 9:31 PM

<script lang="javascript">
        function search()
        {
        window.location.href="search.jsp";

        }
        function valid()
        {
            //var uname=document.getElementById("u1");
            var uname = document.myform.user.value;
            //var pass=document.getElementById("p1");
            var pass = document.myform.pass.value;
            if(uname=="" || uname==null)
                {
                    alert("Please Enter User Name");
                    uname.focus();
                    return false;
                }
                if(pass=="" || pass==null)
                {
                    alert("Please Enter password");
                    pass.focus();
                    return false;
                }
                return true;

        }
        </script>

</head>
<body>

<form name="myform" action="Third.jsp" onsubmit="return valid()">
    <table border="2" align="center">
        <tr><td>username</td><td><input type="text" name="user" id="u1"/></td></tr>
        <tr><td>password</td><td><input type="Password" name="pass" id="p1"/></td></tr>
        <tr><td><input type="submit" value="submit"/></td><td><input type="button" value="search" onclick="search()"/></td></tr>

    </table>
    <label for="name">male</label>
        </form>
         </body>


January 29, 2012 at 9:38 PM

<body>
    <form action="search.jsp">
    Search by Idc
    Id<input type="text" name="id"/>
    Search by Id
    Mobile<input type="text" name="mobile"/>
    <input type="submit" value="Go" />


    <%
Connection con;
Statement st;
ResultSet rs;
String id,mobile,qr;
int temp=0;
id=request.getParameter("id");
mobile=request.getParameter("mobile");
if(( id !=null && id!="") && (mobile != null && mobile!=""))
{
try
{
String Url="jdbc:mysql://localhost:3306/mobile";
Class.forName("com.mysql.jdbc.Driver");   
con=DriverManager.getConnection(Url,"root","root123");
st=con.createStatement();
qr="select name from record where id='"+id+"'";
rs=st.executeQuery(qr);
%>
    <table border="2" align="center">
         <tr>
         <th>Name</th>

         </tr>
             <%
    while(rs.next())
     {
      %>

         <tr >
        <td><%=rs.getString(1)%></td>
          </tr>  

         <% 
     }
%>

</table>
    <%                
     }catch(Exception e)
     {
          out.println(e);
                 }
}
    %>


</form>
</body>
</html>









Related Tutorials/Questions & Answers:
hospital management bill
hospital management bill  bill preperation
hospital management bill
hospital management bill  bill preperation
Advertisements
hospital management bill
hospital management bill  bill preperation
hospital management bill
hospital management bill  bill preperation    <%@page...=con.createStatement(); st.executeUpdate("insert into bill(dfee,mfee,rfee,sfee,tot...=con.createStatement(); st.executeUpdate("insert into bill(dfee,mfee,rfee,sfee,tot) values
hospital Management System
hospital Management System  hello sir i want hospital management system Source code in java swing Back-end Oracle 9i. i want these type of model 1. Username and password 2. staff details i. Doctor details ii. nurse
Java Hospital management system
Java Hospital management system  hospital management    <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import="java.sql.*" %> <!DOCTYPE html> <html> <body>
Hospital project
Hospital project  hello sir i want hospital management system Source code in C # swing Back-end sql sever 2005. i want these type of model 1. Username and password 2. staff details i. Doctor details ii. nurse details iii
Hospital Patient
Hospital Patient  import java.util.ArrayList; import... java.util.Map; import java.util.Scanner; public class Hospital... { System.out.println("::::::::Hospital::::::::"); System.out.println("Enter 1.Add a patient
hospital patient
hospital patient  import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.Scanner; public class PatientFunction { Scanner s=new Scanner(System.in); public Patient
ModuleNotFoundError: No module named 'hospital'
ModuleNotFoundError: No module named 'hospital'  Hi, My Python... 'hospital' How to remove the ModuleNotFoundError: No module named 'hospital... to install padas library. You can install hospital python with following
ModuleNotFoundError: No module named 'bill'
ModuleNotFoundError: No module named 'bill'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'bill' How to remove the ModuleNotFoundError: No module named 'bill' error
Generating bill in servlet - Development process
Generating bill in servlet  I want to generate the bill using servlet for the resturant so any one please send me code
bill - Java Beginners
bill  WAP in java to create a bill using the information given below:- Input:-date of purchase,name of the buyer,price of each item on that day ,quantities of each item. Output:-make the appropriate title,include data and name
regarding bill generation - JSP-Servlet
regarding bill generation  in this program it is connected with database in mysql.when a customer or user enters he can able to see his payable amount as well as what he paid before as bill
ModuleNotFoundError: No module named 'hospital-logfile-analyzer'
ModuleNotFoundError: No module named 'hospital-logfile-analyzer'  Hi...: No module named 'hospital-logfile-analyzer' How to remove the ModuleNotFoundError: No module named 'hospital-logfile-analyzer' error? Thanks  
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'  Hi...: No module named 'Toggl-API-Bill-Generator' How to remove the ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator' error? Thanks  
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'  Hi...: No module named 'Toggl-API-Bill-Generator' How to remove the ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator' error? Thanks  
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'  Hi...: No module named 'Toggl-API-Bill-Generator' How to remove the ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator' error? Thanks  
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'  Hi...: No module named 'Toggl-API-Bill-Generator' How to remove the ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator' error? Thanks  
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'
ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator'  Hi...: No module named 'Toggl-API-Bill-Generator' How to remove the ModuleNotFoundError: No module named 'Toggl-API-Bill-Generator' error? Thanks  
ModuleNotFoundError: No module named 'utility-bill-scraper'
ModuleNotFoundError: No module named 'utility-bill-scraper'  Hi...: No module named 'utility-bill-scraper' How to remove the ModuleNotFoundError: No module named 'utility-bill-scraper' error? Thanks   Hi
ModuleNotFoundError: No module named 'utility-bill-scraper'
ModuleNotFoundError: No module named 'utility-bill-scraper'  Hi...: No module named 'utility-bill-scraper' How to remove the ModuleNotFoundError: No module named 'utility-bill-scraper' error? Thanks   Hi
ModuleNotFoundError: No module named 'att-bill-splitter'
ModuleNotFoundError: No module named 'att-bill-splitter'  Hi, My... named 'att-bill-splitter' How to remove the ModuleNotFoundError: No module named 'att-bill-splitter' error? Thanks   Hi, In your
jsp program for bill generation - JSP-Servlet
jsp program for bill generation  hi, i just want to know how i write the jsp program for generation of bill for a gas connectivity systm  Hi Friend, Please provide some information like structure of bill. Thanks
Management
Management  Hi, Can anyone give me full details of Management? Thanks   Hi, Please see the thread What is management? Thanks
how to generate automatic bill based on selected values using jsp/javascript?
how to generate automatic bill based on selected values using jsp/javascript?  how to generate automatic bill based on selected values using jsp/javascript
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution'
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line...: ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution...-account-bill-line-distribution' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution'
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line...: ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution...-account-bill-line-distribution' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution'
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line...: ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution...-account-bill-line-distribution' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution'
ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line...: ModuleNotFoundError: No module named 'odoo12-addon-account-bill-line-distribution...-account-bill-line-distribution' error? Thanks   Hi, In your
SEVERE: Context [/hospital] startup failed due to previous errors
SEVERE: Context [/hospital] startup failed due to previous errors  Hi my application is hospital i am facing this problem my build.xml file... org.apache.catalina.core.StandardContext start SEVERE: Context [/hospital] startup failed due to previous errors Jan
Learn Management
Learn Management  Hi, How to learn Management online? Thanks   Hi, You can learn management at Management tutorials section. Thanks
memory management
memory management  memory management in java
attendance management
VB attendance management software  i want source code for attendance management system in vb.net.
attendance management
attendance management software in Visual Basic  i want source code for attendance management system in vb.net.
attendance management
How to develop a attendance management software  i want source code for attendance management system in vb.net.
attendance management
Java attendance management application  i want source code for attendance management system in vb.net.
attendance management
attendance management application  i want source code for attendance management system in vb.net.
What is Management?
What is Management?  Hi, I am beginner in the software Industry. Can anyone tell about Management. I want to know What is Management? Thanks
Event management
Event management   Hi, I want event management application like maintaining email notifications while task creation and update in broader way using spring java
Project Management
Project Management  What is Project Management and how it useful in managing a software project. What all certification courses are available for Software Project Management? How to become a good project manager? Thanks
library management
library management   i need java script code for library management system with html
library management
library management   i need java script code for library management system with html
travel management
travel management  how many tables will be use in travel management system project
attendance management
attendance management  i want source code for attendance management system in vb.net.
library management
library management   i need java script code for library management system with html
library management
library management   i need java script code for library management system with html
sessiom management
sessiom management  Hi I am a fresher and working as a java developer, I am facing problem with session and session management concepts, so please give me some reference tutorials and examples on session and session management
for management system
for management system  i need to store some data and to display the stored data and again to modify the data that have been stored and also with either java swing or java awt in format of similar to tat of form
complaint management
complaint management  Complaint Management System Hi......i have to create a complaint management system for an organisation where the employee can register his complain and the complain automatically transfers to higher

Ads