Advertisement
Guest User

Untitled

a guest
Sep 17th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.15 KB | None | 0 0
  1.     public void SetSQL()
  2.     {
  3.         try
  4.  
  5.         {
  6.  
  7.         //get an instance of the driver
  8.  
  9.         //Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
  10.         //Class.forName("org.gjt.mm.mysql.Driver");
  11.  
  12.         //enter the details for your database user account
  13.  
  14.         String myUsername = "website";
  15.  
  16.         String myPassword = "crystal";
  17.  
  18.         //the URL and DBMS for your database
  19.  
  20.         String myDatabaseURL = "jdbc:mysql://24.33.91.230:22/web";
  21.  
  22.         //get a connection to the database
  23.     //The following line throws the exception
  24.         Connection myDBConnection = DriverManager.getConnection(myDatabaseURL,myUsername,myPassword);
  25.  
  26.         //create a statement handle instance to carry out queries
  27.  
  28.         Statement myStatHandle = myDBConnection.createStatement();
  29.         System.out.println("SQL!");
  30.         ResultSet result = myStatHandle.executeQuery("SELECT EpisodeName FROM UnityLevel WHERE EpisodeName='"+EpisodeName+"'");
  31.         while(result.next()) {
  32.             Ep.sqldata = result.getString("EpisodeData");
  33.             System.out.println("Test"+result.getString("EpisodeData"));
  34.         }
  35.         }
  36.  
  37.         catch( Exception e )
  38.  
  39.         { e.printStackTrace(); }
  40.  
  41.  
  42.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement