i need help to edit the two methods below so that i can have them work...

Question

Question

i need help to edit the two methods below so that i can have them work in the class provided after the two methods.

Insert and Select methods below

public void insert(String pCode, String pName,String pDesc, double c){
    setProcCode(pCode);
    setProcName(pName);
    setProcDesc(pDesc);
    setCost(c);

    try {
        FileWriter ff=new FileWriter("Procedures.txt",true);
        BufferedWriter b=new BufferedWriter(ff);
        PrintWriter pp=new PrintWriter(b);
        pp.println(pCode+":"+pName+":"+pDesc+":"+c);
        pp.close();
    }
    catch(Exception ep){
        ep.printStackTrace();
    }
}
public void select(String pCode){

    try{
        FileReader ff=new FileReader("Procedures.txt");
        BufferedReader b=new BufferedReader(ff);
        String ll;
        StringTokenizer tt;

        while((ll=b.readLine())!=null){
            tt=new StringTokenizer(ll,":");
            String proCode=tt.nextToken();
            if(proCode.equalsIgnoreCase(pCode)) {
                procCode=proCode;
                procName=tt.nextToken();
                procDesc=tt.nextToken();
                cost = Double.parseDouble(tt.nextToken());
                break;
            }
        }
        b.close();
    }
    catch(Exception ep){
        ep.printStackTrace();
    }
}

Patient class below

public class Patient extends Person {

    /** Properties **/
    private String patId;
    private String passwd;
    private String addr;
    private String insCo;
    private Appointment appoint;

    /** Constructors **/
    public Patient(){
        super();
        setPatId("");
        setPasswd("");
        setAddr("");
        setInsCo("");
        appoint = new Appointment();
    }
    public Patient(String fn, String ln, String em, String pid,
                   String pass, String ad, String ico, Appointment ap){
        super(fn, ln, em);
        setPatId(pid);
        setPasswd(pass);
        setAddr(ad);
        setInsCo(ico);
        appoint = ap;
    }

    /** Behaviors **/
    public void setPatId(String pId){ patId = pId; }
    public String getPatId(){ return patId; }
    public void setPasswd(String pw){ passwd = pw; }
    public String getPasswd(){ return passwd; }
    public void setAddr(String a){ addr = a; }
    public String getAddr(){ return addr; }
    public void setInsCo(String ic){ insCo = ic; }
    public String getInsCo(){ return insCo; }

    public String toString(){
        return super.toString() + "Patient ID:\t" + getPatId() +
                "\nPassword:\t" + getPasswd() +
                "\nAddress:\t" + getAddr() +
                "\nInsurance Company: " + getInsCo() +
                "\n" + appoint.toString();
    }

    public static void main(String[] args){
        Appointment a1;
        a1 = new Appointment("Dec 1, 2013, 9am","A900","D201","P321");
        Patient p1;
        p1 = new Patient("Bill","Smith","[email protected]",
                "A901","9999","Acworth","Aetna",a1);
        System.out.println(p1.toString());
    }
}

then below is what the outcome of the data we add to the file we ill create when we get the two methods above to work will look like

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

package pis;

import java.sql.*;
import java.util.ArrayList;
public class Patient {
private String id,name,dob,complaints,gender,referedby, contactno,mrvid;
private int age;
private ArrayList<Visit> visits;
public Patient() {
}

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getDob() {
return dob;
}

public void setDob(String dob) {
this.dob = dob;
}

public String getComplaints() {
return complaints;
}

public void setComplaints(String complaints) {
this.complaints = complaints;
}

public String getGender() {
return gender;
}

public void setGender(String gender) {
this.gender = gender;
}

public String getReferedby() {
return referedby;
}

public void setReferedby(String referedby) {
this.referedby = referedby;
}

public String getContactno() {
return contactno;
}

public void setContactno(String contactno) {
this.contactno = contactno;
}

public String add() {
Connection con = null;
try {
con = Database.getConnection();
Statement st = con.createStatement();
// get patient id
ResultSet rs = st.executeQuery("select nvl(max(pid),0) + 1 from patients");
rs.next();
id = rs.getString(1);
rs.close();

PreparedStatement ps = con.prepareStatement("insert into patients values(?,?,?,?,?,?,null,?)");
ps.setString(1,id);
ps.setString(2,name);
ps.setString(3,dob);
ps.setString(4,gender);
ps.setString(5,contactno);
ps.setString(6,complaints);
ps.setString(7,referedby);
if ( ps.executeUpdate() == 1)
return id;
else
return null; // error
}
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
finally {
Database.close(con);
}
} // add()

public static boolean update(String pid, String contactno, String complaints) {
Connection con = null;
try {
con = Database.getConnection();
PreparedStatement ps = con.prepareStatement("update patients set contactno =?, complaints = ? where pid = ?");
ps.setString(1,contactno);
ps.setString(2,complaints);
ps.setString(3,pid);
if ( ps.executeUpdate() == 1)
return true;
else
return false; // error
}
catch(Exception ex) {
System.out.println(ex.getMessage());
return false;
}
finally {
Database.close(con);
}
} // update()

public int getAge() {
return age;
}

public void setAge(int age) {
this.age = age;
}

public ArrayList<Visit> getVisits() {
return visits;
}

public void setVisits(ArrayList<Visit> visits) {
this.visits = visits;
}

public static Patient getAllDetails(String pid) {
// connect and get all details of the given patient
Connection con= null;
try{
con = Database.getConnection();
PreparedStatement ps = con.prepareStatement("select name,gender, dob, (sysdate - dob) / 365 age, complaints, contactno, referedby from patients where pid = ?");
ps.setString(1,pid);
ResultSet rs = ps.executeQuery();
if (! rs.next () )
return null;
// System.out.println("Patient Found");
// create Patient object and load data from row to object
Patient p = new Patient();
p.setId(pid);
p.setName( rs.getString("name"));
p.setContactno( rs.getString("contactno"));
p.setComplaints( rs.getString("complaints"));
p.setGender( rs.getString("gender"));
p.setDob( rs.getString("dob"));
p.setAge( rs.getInt("age"));
p.setReferedby( rs.getString("referedby"));
rs.close();

// Get details of visits of this patient
ps = con.prepareStatement("select vid, to_char(visitdate) vdate,complaint from visits where pid = ? order by visitdate desc");
ps.setString(1,pid);
rs = ps.executeQuery();
ArrayList<Visit> visits = new ArrayList<Visit>();
Visit v;
while ( rs.next()) {
visits.add(new Visit(rs.getString("vid"), pid,rs.getString("complaint"), rs.getString("vdate")));
}
rs.close();
p.setVisits(visits);
return p;
} // end of try
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
finally {
Database.close(con);
}

} // getAllDetails()



public static Patient getDetails(String pid) {
Connection con= null;
try{
con = Database.getConnection();
PreparedStatement ps = con.prepareStatement("select name,gender, dob, (sysdate - dob) / 365 age, complaints, contactno, referedby from patients where pid = ?");
ps.setString(1,pid);
ResultSet rs = ps.executeQuery();
if (! rs.next () )
return null;
Patient p = new Patient();
p.setId(pid);
p.setName( rs.getString("name"));
p.setContactno( rs.getString("contactno"));
p.setComplaints( rs.getString("complaints"));
p.setGender( rs.getString("gender"));
p.setDob( rs.getString("dob"));
p.setAge( rs.getInt("age"));
p.setReferedby( rs.getString("referedby"));
rs.close();
return p;
} // end of try
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
finally {
Database.close(con);
}

} // getDetails()

public static ArrayList<Patient> getPatients(String pname,String fromage, String toage, String gender) {
String cond = " 1 = 1 ";
if ( pname.length() > 0 )
cond += " and upper(name) like '%" + pname.toUpperCase() + "%'";

if ( fromage.length() > 0 )
cond += " and (sysdate - dob)/365 >= " + fromage;

if ( toage.length() > 0 )
cond += " and (sysdate - dob)/365 <= " + toage;

if (! gender.equals("a"))
cond += " and gender = '" + gender + "'";
Connection con = null;
ArrayList<Patient> pl = new ArrayList<Patient>();
try {
con = Database.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select p.pid,name,decode(gender,'m','Male','Female') gender, (sysdate-dob) / 365 age, complaints, to_char(visitdate) visitdate,contactno, referedby from patients p, visits v where p.mrvid = v.vid and " + cond);
while ( rs.next()) {
Patient p = new Patient();
p.setId( rs.getString("pid"));
p.setName( rs.getString("name"));
p.setGender( rs.getString("gender"));
p.setContactno( rs.getString("contactno"));
p.setComplaints( rs.getString("complaints"));
p.setAge( rs.getInt("age"));
p.setReferedby( rs.getString("referedby"));
p.setMrvid( rs.getString("visitdate"));
pl.add(p);
} // while
return pl;
}
catch(Exception ex) {
System.out.println(ex.getMessage());
return pl;
}
finally {
Database.close(con);
}
} // getPatients

public String getMrvid() {
return mrvid;
}

public void setMrvid(String mrvid) {
this.mrvid = mrvid;
}
} // Patient class

package pis;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
public class Visit {
private String vid, pid, complaint,visitdate;
private ArrayList<Drug> drugs;
private ArrayList<Test> tests;
public Visit() {}
public Visit( String vid, String pid, String complaint, String visitdate) {
this.setVid(vid);
this.pid = pid;
this.complaint = complaint;
this.visitdate = visitdate;
drugs = new ArrayList<Drug>();
tests = new ArrayList<Test>();
}

public String getPid() {
return pid;
}

public void setPid(String pid) {
this.pid = pid;
}

public String getComplaint() {
return complaint;
}

public void setComplaint(String complaint) {
this.complaint = complaint;
}

public String getVisitdate() {
return visitdate;
}

public void setVisitdate(String visitdate) {
this.visitdate = visitdate;
}

public ArrayList<Drug> getDrugs() {
return drugs;
}

public void setDrugs(ArrayList drugs) {
this.drugs = drugs;
}

public ArrayList<Test> getTests() {
return tests;
}

public void setTests(ArrayList tests) {
this.tests = tests;
}

public String getVid() {
return vid;
}

public void setVid(String vid) {
this.vid = vid;
}

public static String add(String pid, String complaint, String drugnames[], String dosage[], String nodays[], String tests[]) {
Connection con = null;
String vid;
try {
con = Database.getConnection();
// begin a transaction
con.setAutoCommit(false);
Statement st = con.createStatement();
// get visit id
ResultSet rs = st.executeQuery("select nvl(max(vid),0) + 1 from visits");
rs.next();
vid = rs.getString(1);
rs.close();
PreparedStatement ps = con.prepareStatement("insert into visits values(?,?,sysdate,?)");
ps.setString(1,vid);
ps.setString(2,pid);
ps.setString(3,complaint);
if ( ps.executeUpdate() != 1)
return null; // error
System.out.println("Visit added");
// insert into DRUGS
ps = con.prepareStatement("insert into drugs values(?,?,?,?)");
for ( int i = 0; i < 5; i ++) {
if ( drugnames[i].trim().length() == 0 ) continue;
ps.setString(1,vid);
ps.setString(2,drugnames[i]);
ps.setString(3,dosage[i]);
ps.setString(4,nodays[i]);
if ( ps.executeUpdate() == 0 )
throw new Exception("Could not insert drug details");
else
System.out.println("drug added");
}
// insert into TESTS
ps = con.prepareStatement("insert into tests values(?,?,null,null)");
for (int i = 0 ; i < 5 ; i ++) {
if ( tests[i].trim().length() == 0 ) continue;
ps.setString(1,vid);
ps.setString(2,tests[i]);
if ( ps.executeUpdate() == 0 )
throw new Exception("Could not insert test details");
else
System.out.println("Test added");
}

// update patients data
ps = con.prepareStatement("update patients set mrvid = ? where pid = ?");
ps.setString(1,vid);
ps.setString(2,pid);
ps.executeUpdate();
con.commit();
return vid;
}
catch(Exception ex) {
try {
con.rollback();
}
catch(Exception nex) {}
System.out.println(ex.getMessage());
return null;
}
finally {
Database.close(con);
}
} // add()



public static boolean updateTests(String vid, String testnames[], String testdates[], String testresults[]) {
Connection con = null;
try {
con = Database.getConnection();
// begin a transaction
con.setAutoCommit(false);
PreparedStatement ps = con.prepareStatement("update tests set testdate = ? , result = ? where vid = ? and testname = ?");
for ( int i = 0 ; i < testnames.length ; i ++) {
if ( testdates[i].trim().length() > 0 && testresults[i].trim().length() > 0 ) {
ps.setString(1,testdates[i]);
ps.setString(2,testresults[i]);
ps.setString(3,vid);
ps.setString(4, testnames[i]);
if ( ps.executeUpdate() != 1) return false;
}
}
con.commit();
return true;
}
catch(Exception ex) {
try {
con.rollback();
}
catch(Exception nex) {}
System.out.println(ex.getMessage());
return false;
}
finally {
Database.close(con);
}
} // add()

public static Visit getAllDetails(String vid) {
// connect and get all details of the given visit
Connection con= null;
try{
con = Database.getConnection();
PreparedStatement ps = con.prepareStatement("select vid,to_char(visitdate) visitdate, complaint from visits where vid = ?");
ps.setString(1,vid);
ResultSet rs = ps.executeQuery();
if (! rs.next () )
return null;
Visit v = new Visit( );
v.setVid(vid);
v.setVisitdate( rs.getString("visitdate"));
v.setComplaint( rs.getString("complaint"));

// Get details of drugs related to visit
ps = con.prepareStatement("select drugname, dosage, nodays from drugs where vid = ?");
ps.setString(1,vid);
rs = ps.executeQuery();
ArrayList<Drug> drugs = new ArrayList<Drug>();
while ( rs.next()) {
drugs.add(new Drug(vid, rs.getString("drugname"), rs.getString("dosage"), rs.getInt("nodays")));
}
rs.close();
v.setDrugs(drugs);

// Get details of tests related to visit
ps = con.prepareStatement("select testname, nvl(to_char(testdate),' ') testdate, nvl(result,' ') result from tests where vid = ?");
ps.setString(1,vid);
rs = ps.executeQuery();
ArrayList<Test> tests = new ArrayList<Test>();
while ( rs.next()) {
tests.add(new Test(vid, rs.getString("testname"), rs.getString("testdate"), rs.getString("result")));
}
rs.close();
v.setTests(tests);

return v;

} // end of try
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
finally {
Database.close(con);
}
} // getAllDetails()



public static ArrayList<Test> getTests(String vid) {
Connection con= null;
try{
con = Database.getConnection();
// Get details of tests related to visit
PreparedStatement ps = con.prepareStatement("select testname, nvl(to_char(testdate),' ') testdate, nvl(result,' ') result from tests where vid = ?");
ps.setString(1,vid);
ResultSet rs = ps.executeQuery();
ArrayList<Test> tests = new ArrayList<Test>();
while ( rs.next()) {
tests.add(new Test(vid, rs.getString("testname"), rs.getString("testdate"), rs.getString("result")));
}
rs.close();
return tests;
} // end of try
catch(Exception ex) {
System.out.println(ex.getMessage());
return null;
}
finally {
Database.close(con);
}
} // getAllDetails()
}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>New Patient</title>
</head>
<body>
<%@include file="head.html"%>
<h2>New Patient</h2>
<form action="newpatient.jsp" method="post">
<table>
<tr>
<td>Patient Name :
<td><input type="text" name="name" size-="20" />
</tr>
<tr>
<td>Date of birth :</td>
<td><input type="text" name="dob" value="" size="10" /> (dd-mon-yyyy)
</tr>
<tr>
<td>Gender :</td>
<td><input type="radio" name="gender" value="m" />Male
<input type="radio" name="gender" value="f" />Female
</tr>

<tr>
<td>Contact No. :</td>
<td><input type="text" name="contactno" value="" size="15" />
</tr>

<tr>
<td>Complaints : </td>
<td><textarea name="complaints" rows="4" cols="30"></textarea>
</tr>

<tr>
<td>Refered By :</td>
<td><input type="text" name="referedby" value="" size="20" />
</tr>
</table>
<p/>
<input type="submit" value="Add Patient" />
<input type="reset" value="Clear All" />
</form>
<%@include file="footer.html"%>
</body>
</html>

Add a comment

Answer 2

i need help to edit the two methods below so that i can have them work...

Homework Answers

Add Answer to:
i need help to edit the two methods below so that i can have them work...

Post as a guest

Earn Coins

I need help with this code This is what I need to do: Implement the Stack...

I have Majority of the code written but I just need to implement the <,>,and =...

Hello! I have a problem in my code please I need help, I don't know How I can wright precondition, so I need help about assertion of pre_condition of peek. Java OOP Task is! Improve the circular a...

Can someone help me to figure that error I have put below. JAVA ----jGRASP exec: javac...

could you please help me with this problem, also I need a little text so I...

Can you help me make these two methods listed below work? I have code written but...

Hi. Could you help me with the code below? I need to validate the code below, using expressions that can carry out the actions or that make appropriate changes to the program’s state, using conditiona...

The following are screen grabs of the provided files Thanks so much for your help, and have a n...

i need help to edit the two methods below so that i can have them work...

Homework Answers

Add Answer to: i need help to edit the two methods below so that i can have them work...

Post as a guest

Earn Coins

Add Answer to:
i need help to edit the two methods below so that i can have them work...