public static void add(String a, String b, File x, String s) throws Exception {
fis = new FileInputStream(x);
pa.setString(1, "" + dt);
pa.setInt(2, pid);
pa.setString(3, pfnm);
pa.setString(4, pmnm);
pa.setString(5, plnm);
pa.setString(6, gen);
pa.setInt(7, age);
pa.setString(8, wt);
pa.setString(9, a);
pa.setString(10, cno);
pa.setString(11, dnm);
pa.setString(12, b);
pa.setString(13, dig);
pa.setInt(14, fee);
pa.setString(15, bg);
pa.setString(17, s);
pa.setBinaryStream(16, (InputStream) fis, (int) (x.length()));
pa.executeUpdate();
}
public static void mod(File x, String s) throws Exception {
try {
System.out.println(x);
fis = new FileInputStream(x);
// tmp=con.prepareStatement("update patient set
// dt=?,pfnm=?,pmnm=?,plnm=?,gen=?,age=?,wt=?,addr=?,cno=?,dnnm=?,sym=?,dig=?,fee=? where
// pid=1");
tmp =
con.prepareStatement(
"update patient set dt=?,pfnm=?,pmnm=?,plnm=?,gen=?,age=?,wt=?,addr=?,cno=?,dnm=?,sym=?,dig=?,fee=?,bg=?,i=?,path=? where pid="
+ pid);
// tmp.setString(1,pfnm);
tmp.setString(1, "" + dt);
tmp.setString(2, pfnm);
tmp.setString(3, pmnm);
tmp.setString(4, plnm);
tmp.setString(5, gen);
tmp.setInt(6, age);
tmp.setString(7, wt);
tmp.setString(8, addr);
tmp.setString(9, cno);
tmp.setString(10, dnm);
tmp.setString(11, sym);
tmp.setString(12, dig);
tmp.setInt(13, fee);
tmp.setString(14, bg);
tmp.setString(16, s);
tmp.setBinaryStream(15, (InputStream) fis, (int) (x.length()));
tmp.executeUpdate();
} catch (Exception ee) {
System.out.println("mod123 " + ee);
}
}