Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String result = "";
- String userid = request.getParameter("userid");
- String pswd = request.getParameter("pswd");
- String name = request.getParameter("name");
- request.setCharacterEncoding("UTF-8");
- String bloodgroup = request.getParameter("bloodgroup");
- String mob = request.getParameter("mob");
- String city = request.getParameter("city");
- String Availability = request.getParameter("Availability");
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/blood", "root", "root");
- String s = "insert into registration values(?,?,?,?,?,?,?)";
- PreparedStatement ps = con.prepareStatement(s);
- ps.setString(1, name);
- ps.setBytes(2, bloodgroup.getBytes("UTF-8"));
- ps.setString(3, mob);
- ps.setString(4, city);
- ps.setString(5, userid);
- ps.setString(6, pswd);
- ps.setString(7, Availability);
- int x = ps.executeUpdate();
- if (x > 0) {
- result = "Data Saved";
- }
- } catch (Exception e) {
- result = e.toString();
- }
- PrintWriter pw = response.getWriter();
- pw.write(result);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement