{"id":422,"date":"2012-12-27T17:21:42","date_gmt":"2012-12-27T17:21:42","guid":{"rendered":"http:\/\/codeatelier.wordpress.com\/?p=422"},"modified":"2012-12-27T17:21:42","modified_gmt":"2012-12-27T17:21:42","slug":"updatating-database-through-bean","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/updatating-database-through-bean\/","title":{"rendered":"Updatating Database through bean"},"content":{"rendered":"<pre>\npackage com.javadb2.mugil.employee;\n\nimport java.io.BufferedReader;\nimport java.io.InputStreamReader;\nimport java.sql.DriverManager;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\n\nimport com.javadb2.mugil.db.display;\nimport com.mysql.jdbc.Connection;\nimport com.mysql.jdbc.PreparedStatement;\n\npublic class update\n{\t \n\tpublic static void main(String args[])\n\t{\n\t  bean objBean = new bean();\n\t  objBean.setEmpId(Integer.parseInt(getInput(\"Enter Employee Id :\")));\n\t  objBean.setEmpName((String)getInput(\"Enter Employee Name:\"));\n\t  objBean.setEmpSalary(Integer.parseInt(getInput(\"Salary\")));\n\t  updateValues(objBean);\n\t}\n\t\n\tpublic static void updateValues(bean objBean)\n\t{\t\n\t\tSystem.out.println(objBean.getEmpName());\n\t\tSystem.out.println(objBean.getEmpSalary());\n\t\t\n\t\tString strSQL = \"UPDATE employeelist\" +\n\t\t\t\t\"   SET empname = ? ,\" +\n\t\t\t\t\"       salary  = ?\" +\n\t\t\t\t\" WHERE empid = ?\";\n\t\t\n\t\ttry \n\t\t{\n\t\t\tConnection conn = (Connection) DriverManager.getConnection(\"jdbc:mysql:\/\/localhost\/test\", \"root\", \"pass\");\n\t\t\tPreparedStatement stmt = (PreparedStatement) conn.prepareStatement(strSQL);\n\t\t\t\n\t\t\tstmt.setString(1, objBean.getEmpName());\n\t\t\tstmt.setDouble(2, objBean.getEmpSalary());\n\t\t\tstmt.setInt(3, objBean.getEmpId());\n\t\t\t\n\t\t\tint affected = stmt.executeUpdate();\n\t\t\t\t\t\t\n\t\t\tif(affected == 1)\n\t\t\t{\n \t\t\t  System.out.println(\"Updated Successfully\");\n\t\t\t}\n\t\t\telse\n\t\t\t{\n\t\t\t  System.err.println(\"Unable to Update Employee\");\n\t\t\t}\n\t\t} \n\t\tcatch (SQLException e) \n\t\t{\n\t\t  e.printStackTrace();\n\t\t}\n\t}\n\n\tpublic static String getInput(String prompt)\n\t{\n\t\tBufferedReader stdin = new BufferedReader(new InputStreamReader(System.in));\n\t\t\n\t\tSystem.out.print(prompt);\n\t\tSystem.out.flush();\n\t\t\n\t\ttry \n\t\t{\n\t\t\treturn stdin.readLine();\n\t\t} \n\t\tcatch (Exception e) \n\t\t{\n\t\t\t\/\/ TODO: handle exception\n\t\t\treturn e.getMessage();\n\t\t}\n\t}\n}\t\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>package com.javadb2.mugil.employee; import java.io.BufferedReader; import java.io.InputStreamReader; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import com.javadb2.mugil.db.display; import com.mysql.jdbc.Connection; import com.mysql.jdbc.PreparedStatement; public class update { public static void main(String args[]) { bean objBean = new bean(); objBean.setEmpId(Integer.parseInt(getInput(&#8220;Enter Employee Id :&#8221;))); objBean.setEmpName((String)getInput(&#8220;Enter Employee Name:&#8221;)); objBean.setEmpSalary(Integer.parseInt(getInput(&#8220;Salary&#8221;))); updateValues(objBean); } public static void updateValues(bean objBean) { System.out.println(objBean.getEmpName()); System.out.println(objBean.getEmpSalary()); String strSQL = &#8220;UPDATE&hellip; <a href=\"https:\/\/codethataint.com\/blog\/updatating-database-through-bean\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3],"tags":[],"class_list":["post-422","post","type-post","status-publish","format-standard","hentry","category-database","category-java"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=422"}],"version-history":[{"count":0,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/422\/revisions"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}