Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. Database.class
  2. -----------------------------------------
  3.  
  4. package adventureText;
  5.  
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11.  
  12. public class Database {
  13.  
  14. static String name;
  15. static Connection connection = null;
  16.  
  17. public static void main(String[] args) {
  18. }
  19.  
  20. public static void getConnection(){
  21.  
  22. Statement stmt = null;
  23.  
  24. try
  25. {
  26. Class.forName("org.sqlite.JDBC").newInstance();
  27. connection= DriverManager.getConnection("jdbc:sqlite:database/game.db");
  28. stmt = connection.createStatement();
  29. ResultSet rs = stmt.executeQuery("SELECT name FROM user");
  30. while (rs.next()){
  31. name = rs.getString("name");
  32. }
  33. }
  34. catch (Exception e){
  35. System.err.println(e.getClass().getName() + ": " + e.getMessage());
  36. System.exit(0);
  37. }
  38.  
  39. }
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement