API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 27th, 2017
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.68 KB | None | 0 0
raw download clone embed print report
  1. Hospital Inventory App using MySQL and JSP
  2.  
  3. HTML Code <form action="/hospitalinv.jsp" method=”post”>
  4. Inventory moved to room:<br />
  5. <input name="roomto" type="text" value="" /><br />Inventory moved from room:<br />
  6. <input name="roomfrom" type="text" value="" /><br /><br />
  7. Type of inventory moved:<br /> <input name="inv" type="text" value="" /><br /><br />
  8. Number of inventory moved:<br /> <
  9. input name="num" type="text" value="" /><br /><br /> <
  10. “room”=1 ><
  11. input type="submit" value="Submit" /></form>
  12.  
  13.  
  14.  
  15.  
  16.  
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36. JSP Code
  37. <%@ page language="java"
  38. contentType="text/html; charset=ISO-8859-1"
  39. pageEncoding="ISO-8859-1"
  40. <%@ page import=java.sql.*”%>
  41. <%@ page import=java.io.*”%>
  42. <%@ page import=java.net.*”%>
  43. <html>
  44. <head>
  45. <title>HospitalInventoryJSP</title>
  46. </head>
  47. <body>
  48. <%
  49. String roomto = request.getParameter("roomto");
  50.  
  51. String roomfrom = request.getParameter("roomfrom");
  52.  
  53. String inv = request.getParameter("inv");
  54.  
  55. String num = request.getParameterValues("num");
  56.  
  57. String roomnumber=request.getParameterValues(“room”)
  58. Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:8888/hospitalinv”);
  59.  
  60. Statement stmt = conn.createStatement();
  61.  
  62. if (roomto==”” && roomfrom != “”){
  63. String sqlStr = "SELECT *”+ “FROM hospitalinven”+ “WHERE room== roomnumber”;
  64.  
  65. if (inv ==ventilators){
  66. ResultSet qs=stmt.executeQuery(sqlStr);
  67. if (qs.getInt(3)-num<0){
  68. System.out.print(“Invalid entry”)
  69. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  70. ResultSet rs=stmt.executeQuery(sqlStr);
  71.  
  72. while (rs.next()) {
  73. System.out.println(rs.getString("room") + "\t" +
  74. rs.getString("ventilators") + "\t" +
  75. rs.getInt ("ventnum")+"\t" +
  76. rs.getString("heartlungmachines") +"\t" +
  77. rs.getString("heartlungnum") +"\t" +
  78. rs.getString("dialysismachines") +"\t" +
  79. rs.getString("dialnum"));
  80. }
  81.  
  82. else{
  83. String sqlUpdate = "UPDATE hospitalinven "
  84. + "SET ventnum = qs.getInt(3)-num "
  85. + "WHERE id = roomnumber";
  86. conn.executeUpdate(sqlUpdate);
  87. String sqlUpdate=”UPDATE hospitalinven”
  88. +”SET ventnum=ventum+num”+”WHERE id=roomto”;
  89. conn.executeUpdate(sqlUpdate)
  90. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  91. ResultSet rs=stmt.executeQuery(sqlStr);
  92.  
  93. while (rs.next()) {
  94. System.out.println(rs.getString("room") + "\t" +
  95. rs.getString("ventilators") + "\t" +
  96. rs.getInt ("ventnum")+"\t" +
  97. rs.getString("heartlungmachines") +"\t" +
  98. rs.getString("heartlungnum") +"\t" +
  99. rs.getString("dialysismachines") +"\t" +
  100. rs.getString("dialnum"));
  101. }}
  102.  
  103. else if (inv==heartlungmachines){
  104.  
  105. if (qs.getInt(5)-num<0){
  106. System.out.print(“Invalid entry”)
  107. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  108. ResultSet rs=stmt.executeQuery(sqlStr);
  109.  
  110. while (rs.next()) {
  111. System.out.println(rs.getString("room") + "\t" +
  112. rs.getString("ventilators") + "\t" +
  113. rs.getInt ("ventnum")+"\t" +
  114. rs.getString("heartlungmachines") +"\t" +
  115. rs.getString("heartlungnum") +"\t" +
  116. rs.getString("dialysismachines") +"\t" +
  117. rs.getString("dialnum"));
  118. }
  119.  
  120. else{
  121. String sqlUpdate = "UPDATE hospitalinven "
  122. + "SET heartlungnum = qs.getInt(5)-num "
  123. + "WHERE id = roomnumber";
  124. conn.executeUpdate(sqlUpdate);
  125. String sqlUpdate=”UPDATE hospitalinven”
  126. +”SET heartlungnum=heartlungnum+num”+”WHERE id=roomto”;
  127. conn.executeUpdate(sqlUpdate)
  128. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  129. ResultSet rs=stmt.executeQuery(sqlStr);
  130.  
  131. while (rs.next()) {
  132. System.out.println(rs.getString("room") + "\t" +
  133. rs.getString("ventilators") + "\t" +
  134. rs.getInt ("ventnum")+"\t" +
  135. rs.getString("heartlungmachines") +"\t" +
  136. rs.getString("heartlungnum") +"\t" +
  137. rs.getString("dialysismachines") +"\t" +
  138. rs.getString("dialnum"));
  139. }}
  140.  
  141. if (inv==dialysismachines){
  142.  
  143. if (qs.getInt(7)-num<0){
  144. System.out.print(“Invalid entry”)
  145. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  146.  
  147. ResultSet rs=stmt.executeQuery(sqlStr);
  148.  
  149. while (rs.next()) {
  150. System.out.println(rs.getString("room") + "\t" +
  151. rs.getString("ventilators") + "\t" +
  152. rs.getInt ("ventnum")+"\t" +
  153. rs.getString("heartlungmachines") +"\t" +
  154. rs.getString("heartlungnum") +"\t" +
  155. rs.getString("dialysismachines") +"\t" +
  156. rs.getString("dialnum"));
  157. }
  158.  
  159. else{
  160. String sqlUpdate = "UPDATE hospitalinven "
  161. + "SET dialnum = qs.getInt(7)-num "
  162. + "WHERE id = roomnumber";
  163. conn.executeUpdate(sqlUpdate);
  164. String sqlUpdate=”UPDATE hospitalinven”
  165. +”SET dialnum=dialnum+num”+”WHERE id=roomto”;
  166. conn.executeUpdate(sqlUpdate)
  167. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  168.  
  169. ResultSet rs=stmt.executeQuery(sqlStr);
  170. while (rs.next()) {
  171. System.out.println(rs.getString("room") + "\t" +
  172. rs.getString("ventilators") + "\t" +
  173. rs.getInt ("ventnum")+"\t" +
  174. rs.getString("heartlungmachines") +"\t" +
  175. rs.getString("heartlungnum") +"\t" +
  176. rs.getString("dialysismachines") +"\t" +
  177. rs.getString("dialnum"));
  178. }}}
  179.  
  180. else if (roomto!=”” && roomfrom == “”){
  181. String sqlStr = "SELECT *”+ “FROM hospitalinven”+ “WHERE room== roomfrom”;
  182. if (inv ==ventilators){
  183.  
  184. ResultSet qs=stmt.executeQuery(sqlStr);
  185. if (qs.getInt(3)-num<0){
  186. System.out.print(“Invalid entry”)
  187. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  188.  
  189. ResultSet rs=stmt.executeQuery(sqlStr);
  190.  
  191. while (rs.next()) {
  192. System.out.println(rs.getString("room") + "\t" +
  193. rs.getString("ventilators") + "\t" +
  194. rs.getInt ("ventnum")+"\t" +
  195. rs.getString("heartlungmachines") +"\t" +
  196. rs.getString("heartlungnum") +"\t" +
  197. rs.getString("dialysismachines") +"\t" +
  198. rs.getString("dialnum"));
  199. }
  200.  
  201. else{
  202. String sqlUpdate = "UPDATE hospitalinven "
  203. + "SET ventnum = qs.getInt(3)-num "
  204. + "WHERE id = roomfrom";
  205. conn.executeUpdate(sqlUpdate);
  206. String sqlUpdate=”UPDATE hospitalinven”
  207. +”SET ventnum=ventum+num”+”WHERE id=roomnumber”;
  208. conn.executeUpdate(sqlUpdate)
  209. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  210.  
  211. ResultSet rs=stmt.executeQuery(sqlStr);
  212. while (rs.next()) {
  213. System.out.println(rs.getString("room") + "\t" +
  214. rs.getString("ventilators") + "\t" +
  215. rs.getInt ("ventnum")+"\t" +
  216. rs.getString("heartlungmachines") +"\t" +
  217. rs.getString("heartlungnum") +"\t" +
  218. rs.getString("dialysismachines") +"\t" +
  219. rs.getString("dialnum"));
  220. }}
  221. else if (inv==heartlungmachines){
  222. if (qs.getInt(5)-num<0){
  223. System.out.print(“Invalid entry”)
  224. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  225.  
  226. ResultSet rs=stmt.executeQuery(sqlStr);
  227.  
  228. while (rs.next()) {
  229. System.out.println(rs.getString("room") + "\t" +
  230. rs.getString("ventilators") + "\t" +
  231. rs.getInt ("ventnum")+"\t" +
  232. rs.getString("heartlungmachines") +"\t" +
  233. rs.getString("heartlungnum") +"\t" +
  234. rs.getString("dialysismachines") +"\t" +
  235. rs.getString("dialnum"));
  236. }
  237. else{
  238. String sqlUpdate = "UPDATE hospitalinven "
  239. + "SET heartlungnum = qs.getInt(5)-num "
  240. + "WHERE id = roomfrom";
  241. conn.executeUpdate(sqlUpdate);
  242. String sqlUpdate=”UPDATE hospitalinven”
  243. +”SET heartlungnum=heartlungnum+num”+”WHERE id=roomnumber”;
  244. conn.executeUpdate(sqlUpdate)
  245. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  246.  
  247. ResultSet rs=stmt.executeQuery(sqlStr);
  248. while (rs.next()) {
  249. System.out.println(rs.getString("room") + "\t" +
  250. rs.getString("ventilators") + "\t" +
  251. rs.getInt ("ventnum")+"\t" +
  252. rs.getString("heartlungmachines") +"\t" +
  253. rs.getString("heartlungnum") +"\t" +
  254. rs.getString("dialysismachines") +"\t" +
  255. rs.getString("dialnum"));
  256. }}
  257.  
  258. if (inv==dialysismachines){
  259. if (qs.getInt(7)-num<0){
  260. System.out.print(“Invalid entry”)
  261. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  262.  
  263. ResultSet rs=stmt.executeQuery(sqlStr);
  264. while (rs.next()) {
  265. System.out.println(rs.getString("room") + "\t" +
  266. rs.getString("ventilators") + "\t" +
  267. rs.getInt ("ventnum")+"\t" +
  268. rs.getString("heartlungmachines") +"\t" +
  269. rs.getString("heartlungnum") +"\t" +
  270. rs.getString("dialysismachines") +"\t" +
  271. rs.getString("dialnum"));
  272. }
  273.  
  274. else{
  275. String sqlUpdate = "UPDATE hospitalinven "
  276. + "SET dialnum = qs.getInt(7)-num "
  277. + "WHERE id = roomfrom";
  278. conn.executeUpdate(sqlUpdate);
  279. String sqlUpdate=”UPDATE hospitalinven”
  280. +”SET dialnum=dialnum+num”+”WHERE id=roomnumber”;
  281. conn.executeUpdate(sqlUpdate)
  282. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  283.  
  284. ResultSet rs=stmt.executeQuery(sqlStr);
  285. while (rs.next()) {
  286. System.out.println(rs.getString("room") + "\t" +
  287. rs.getString("ventilators") + "\t" +
  288. rs.getInt ("ventnum")+"\t" +
  289. rs.getString("heartlungmachines") +"\t" +
  290. rs.getString("heartlungnum") +"\t" +
  291. rs.getString("dialysismachines") +"\t" +
  292. rs.getString("dialnum"));
  293. }}}
  294. else if {roomto==0 && roomfrom==0){
  295. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  296.  
  297. ResultSet rs=stmt.executeQuery(sqlStr);
  298. while (rs.next()) {
  299. System.out.println(rs.getString("room") + "\t" +
  300. rs.getString("ventilators") + "\t" +
  301. rs.getInt ("ventnum")+"\t" +
  302. rs.getString("heartlungmachines") +"\t" +
  303. rs.getString("heartlungnum") +"\t" +
  304. rs.getString("dialysismachines") +"\t" +
  305. rs.getString("dialnum"));
  306. }
  307. else if (roomto!=0 && roomfrom!=0){
  308. System.out.println(“Invalid entry. Can only enter one.”)
  309. String sqlStr = "SELECT *”+ “FROM hospitalinven”;
  310.  
  311. ResultSet rs=stmt.executeQuery(sqlStr);
  312. while (rs.next()) {
  313. System.out.println(rs.getString("room") + "\t" +
  314. rs.getString("ventilators") + "\t" +
  315. rs.getInt ("ventnum")+"\t" +
  316. rs.getString("heartlungmachines") +"\t" +
  317. rs.getString("heartlungnum") +"\t" +
  318. rs.getString("dialysismachines") +"\t" +
  319. rs.getString("dialnum"));
  320. }
  321.  
  322. </body>
  323. </html>
  324.  
  325.  
  326.  
  327.  
  328.  
  329.  
  330.  
  331.  
  332.  
  333.  
  334.  
  335.  
  336.  
  337.  
  338.  
  339.  
  340.  
  341.  
  342.  
  343.  
  344.  
  345. MySQL
  346. mysql> CREATE DATABASE hospitalinv;
  347. mysql> USE hospitalinv;
  348. mysql> CREATE TABLE hospitalinven (
  349. room INT UNSIGNED NOT NULL AUTO_INCREMENT,
  350. ventilators CHAR(3) NOT NULL DEFAULT '',
  351. ventnum INT UNSIGNED NOT NULL DEFAULT 5,
  352. hearlungmachines CHAR(3) NOT NULL DEFAULT '',
  353. heartlungnum INT UNSIGNED NOT NULL DEFAULT 2,
  354. dialysismachines CHAR(3) NOT NULL DEFAULT ''
  355. dialnum CHAR(3) INT UNSIGNED NOT NULL DEFAULT 3
  356. PRIMARY KEY (room)
  357. );
  358.  
  359. mysql> INSERT INTO hospitalinv VALUES (1, ‘’,5,’’,2,’’,3)
  360. mysql> INSERT INTO hospitalinv VALUES (2, ‘’,5,’’,2,’’,3)
  361. mysql> INSERT INTO hospitalinv VALUES (3, ‘’,5,’’,2,’’,3)
  362. mysql> INSERT INTO hospitalinv VALUES (4, ‘’,5,’’,2,’’,3)
  363. mysql> INSERT INTO hospitalinv VALUES (5, ‘’,5,’’,2,’’,3)
  364. mysql> INSERT INTO hospitalinv VALUES (6, ‘’,5,’’,2,’’,3)
  365. mysql> INSERT INTO hospitalinv VALUES (7, ‘’,5,’’,2,’’,3)
  366. mysql> INSERT INTO hospitalinv VALUES (8, ‘’,5,’’,2,’’,3)
  367. mysql> INSERT INTO hospitalinv VALUES (9, ‘’,5,’’,2,’’,3)
  368. mysql> INSERT INTO hospitalinv VALUES (10, ‘’,5,’’,2,’’,3)
  369. mysql> INSERT INTO hospitalinv VALUES (11, ‘’,5,’’,2,’’,3)
  370. mysql> INSERT INTO hospitalinv VALUES (12, ‘’,5,’’,2,’’,3)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!