Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void SetSQL()
- {
- try
- {
- //get an instance of the driver
- //Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
- //Class.forName("org.gjt.mm.mysql.Driver");
- //enter the details for your database user account
- String myUsername = "website";
- String myPassword = "crystal";
- //the URL and DBMS for your database
- String myDatabaseURL = "jdbc:mysql://24.33.91.230:22/web";
- //get a connection to the database
- //The following line throws the exception
- Connection myDBConnection = DriverManager.getConnection(myDatabaseURL,myUsername,myPassword);
- //create a statement handle instance to carry out queries
- Statement myStatHandle = myDBConnection.createStatement();
- System.out.println("SQL!");
- ResultSet result = myStatHandle.executeQuery("SELECT EpisodeName FROM UnityLevel WHERE EpisodeName='"+EpisodeName+"'");
- while(result.next()) {
- Ep.sqldata = result.getString("EpisodeData");
- System.out.println("Test"+result.getString("EpisodeData"));
- }
- }
- catch( Exception e )
- { e.printStackTrace(); }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement