Guest User

Untitled

a guest
Jul 16th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  2.  
  3. java.sql.Connection db =
  4. java.sql.DriverManager.getConnection(
  5. "jdbc:mysql://mysql.stud.ntnu.no/BRUKERNAVN_gjestebok",
  6. "BRUKERNAVN_admin",
  7. "BRUKERNAVN");
  8.  
  9. java.sql.Statement st = db.createStatement();
  10. java.sql.ResultSet rs;
  11.  
  12. rs=st.executeQuery("Insert into gjestebok values(now(), '" + name + "', '" + meld + "')");
  13.  
  14. rs = st.executeQuery("select * from gjestebok");
  15. while(rs.next())
  16. {
  17. out.println("<p>");
  18. out.println(rs.getString("dato"));
  19. out.println(rs.getString("navn"));
  20. out.println(rs.getString("melding"));
  21. out.println("</p>");
  22. }
  23. rs.close();
  24. %>
Add Comment
Please, Sign In to add comment