Results 1 to 2 of 2
- 01-20-2011, 02:33 PM #1
PLEASE SOMEONE HELP ME =( database.. im desperate
hi I'v got a brain freeze and what i need to do is :
if old is true ... update databaseJava Code:public static void connectDatabase(){ Connection con = null; if(database.equals("")){ JOptionPane.showMessageDialog(null, "Can't run without database!"); System.exit(0);} try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://", // Using anonymous cause i feel like it =) "root", "test"); if(!con.isClosed()) System.out.println("Duude youre connected " + "trough TCP/IP..."); stmt = con.createStatement(); try{ stmt.executeUpdate("USE " + database); System.out.println("Used old database!"); old = true; }catch (Exception e){ stmt.executeUpdate("CREATE DATABASE " + database); stmt.executeUpdate("USE " + database); System.out.println("Database created!"); } if(!old){ stmt.executeUpdate ("CREATE TABLE Borrowers (" + "cardnr INT," + "name CHAR(60), " + "street CHAR(40), " + "zip INT," + "town CHAR(50)," + "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY)"); stmt.executeUpdate ("CREATE TABLE GoodBooks (" + " ISBN long," + " CopyNumber INT," + " Title VARCHAR(60)," + " Author VARCHAR(30)," + " Publisher VARCHAR(50)," + " Year INT," + " Statistics INT," + " BorrowDate INT," + " ReturnDate INT," + " LibraryCardNumber INT," + "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY)"); } if(!old){ for(int j = 0 ; j < Borrowers.borrow.length; j++){ stmt.executeUpdate("INSERT INTO Borrowers " +"(cardnr, name, street, zip, town) " + "VALUES " + "('"+ Borrowers.borrow[j].LibraryCardNumber + "'," + "'"+ Borrowers.borrow[j].Name + "'," + "'"+ Borrowers.borrow[j].Street + "'," + "'"+ Borrowers.borrow[j].ZipCode + "'," + "'"+ Borrowers.borrow[j].Town + "')"); } for(int j = 0 ; j <Bookobjects.bookO.length ; j++){ stmt.executeUpdate("INSERT INTO goodbooks " +"(ISBN, CopyNumber, Title, Author, Publisher, Year, Statistics," + " BorrowDate, ReturnDate, LibraryCardNumber) " + "VALUES " + "('"+ Bookobjects.bookO[j].ISBN + "'," + "'"+ Bookobjects.bookO[j].CopyNumber + "'," + "'"+ Bookobjects.bookO[j].Title + "'," + "'"+ Bookobjects.bookO[j].Author + "'," + "'"+ Bookobjects.bookO[j].Publisher + "'," + "'"+ Bookobjects.bookO[j].Year + "'," + "'"+ Bookobjects.bookO[j].Statistics + "'," + "'"+ Bookobjects.bookO[j].BorrowDate + "'," + "'"+ Bookobjects.bookO[j].ReturnDate + "'," + "'"+ Bookobjects.bookO[j].LibraryCardNumber + "')"); } } }catch(Exception e) { System.err.println("Fail: " + e.getMessage()); System.out.println("Fail: " + e); }
check in for Bookobjects.bookO.length and
Borrowers.borrow.length for new objects
Thank you for any help =P
- 01-20-2011, 04:59 PM #2
Moderator
- Join Date
- Apr 2009
- Posts
- 10,484
- Rep Power
- 16
Similar Threads
-
help i'm desperate
By AniMaind in forum New To JavaReplies: 17Last Post: 01-08-2011, 01:05 AM -
Desperate for some help if possible :(
By SBOSlayer in forum New To JavaReplies: 1Last Post: 11-30-2010, 10:44 PM -
How to convert access database to mysql database?
By vrk in forum Advanced JavaReplies: 2Last Post: 02-11-2009, 04:43 AM -
In Desperate need for a good swing website
By Loop in forum New To JavaReplies: 4Last Post: 09-30-2008, 02:23 PM -
Multithreading + Networking (desperate)
By bluebarca in forum New To JavaReplies: 1Last Post: 11-07-2007, 02:14 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks