Advertisement
Guest User

Untitled

a guest
Mar 4th, 2019
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. String str = (String)session.getAttribute("UserName");
  2. String q = "insert into Data (UserName, Marks) values ('"+str+"' , "+count+")";
  3. System.out.println(q);
  4.  
  5. Connection con = null;
  6. String url = "jdbc:mysql://localhost:3306/";
  7. String db = "jdbctutorial";
  8. String driver = "com.mysql.jdbc.Driver";
  9. try {
  10. Class.forName(driver);
  11. con = DriverManager.getConnection(url + db, "root", "root");
  12. try {
  13. String str = (String)session.getAttribute("UserName");
  14. String q =
  15. "insert into Data (UserName, Marks) values ('" + str +
  16. "' , " + count + ")";
  17. Statement st = con.createStatement();
  18. int val = st.executeUpdate(q);
  19. System.out.println("Marks added.");
  20. } catch (SQLException s) {
  21. System.out.println("SQL statement is not executed!");
  22. }
  23.  
  24. }
  25.  
  26. String sql = "INSERT into Data VALUES(?,?)";
  27. PreparedStatement prest = con.prepareStatement(sql);
  28. prest.setString(1, str);
  29. prest.setInt(2, count);
  30. ps.executeUpdate();
  31. System.out.println("Marks added.");
  32. con.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement