BF2S Forums Help with java

If i was at uni i could link you my coursework that did this but im not, however i think i can find the code for it.

Our Database is MySQL This is brilliant and free!
Driver is mysql-connect.jar
java -cp .\mysql-connect.jar
Or put it in:
    C:\j2sdk1.x.x\jre\lib\ext
This is always in the CLASSPATH

About the Database
host = “sauron.cs.nott.ac.uk”;
database = “wisdom”;
port  = 3306;
user = “xxx03u”;
password = “ISentYouThis";


Register the Driver
Connect to Database
Create and Execute a Statement
Statement st = con.createStatement();
String qry = “SELECT ...”;
ResultSet rs = st.executeQuery(qry);

String qry = “INSERT ...”;
st.executeUpdate(qry);
JDBC Statements

Getting the data returned
String code = rs.getString(“code");
Needs to be in a try block
Of course other methods are:

getInt();
getDouble();
Navigating the ResultSet
while(rs.next()) {
    … process a row
}


How to connect in Java
DBconnect() {
       try  {
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             pConnection=DriverManager.getConnection("jdbc:odbc:mydb.mdb","","");
             pStatement = pConnection.createStatement();
       }
       catch(Exception e) {
             e.getMessage(); // print this out
       }
}



Those are the bullet points from the slides. I think the last section is the bit u need.

Last edited by Vilham (2007-05-16 06:18:16)

Thanks for your help dude. I got it done but abandoned the java as it was apparently a bad way to connect to a database through an applet, oh well thanks again.