populate.java

beginJsp2.0外文书籍源代码

package com.wrox.library;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class populate {
String tstatus = "Error in creating Tables";
String pstatus = "Error in populating Tables";
  public void init() {
    try{
      Context ctx = new InitialContext();
      if(ctx == null )
        throw new Exception("Oops - No Context");

      DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/BooksDB");

      if (ds != null) {
        Connection conn = ds.getConnection();
      Statement stmt = conn.createStatement();
      String upd = "CREATE TABLE Author ("+
                   "Author_ID INTEGER NOT NULL PRIMARY KEY,"+
                   "Author_Name CHAR(50)) type=InnoDB;";
      stmt.executeUpdate(upd);

      upd = "CREATE TABLE Category ("+
            "Category_ID INTEGER NOT NULL PRIMARY KEY,"+
            "Category_Description CHAR(50)) type=InnoDB;";
      stmt.executeUpdate(upd);

      upd = "CREATE TABLE Book ("+
             "Title_ID INTEGER NOT NULL PRIMARY KEY,"+
             "Title CHAR(50),"+
             "Price FLOAT(8,2),"+
             "Category_ID INTEGER) type=InnoDB;";
      stmt.executeUpdate(upd);

      upd = "CREATE TABLE Contribution ("+
             "Contribution_ID INTEGER NOT NULL PRIMARY KEY,"+
             "Title_ID INTEGER,"+
             "Author_ID INTEGER) type=InnoDB;";
      stmt.executeUpdate(upd);
      tstatus = "Tables successfully created";
      upd = "INSERT INTO Category (Category_ID, Category_Description)"+
             "VALUES (1,'Java'), (2,'SQL');";
      stmt.executeUpdate(upd);

      upd = "INSERT INTO Book (Title_ID, Category_ID, Title, Price)"+
                    " VALUES (1,1,'Professional Java Data',59.99),"+
                           "(2,1,'Professional Java Security',49.99),"+
                           "(3,2,'Beginning SQL Programming',49.99)";
      stmt.executeUpdate(upd);

      upd = "INSERT INTO Author (Author_ID, Author_Name) VALUES "+
           "(1,'Danny Ayers'), (2,'John Bell'), (3,'Carl Calvert Bettis'),"+
           "(4,'Thomas Bishop'), (5,'Mike Bogovich'), (6,'Matthew Ferris'),"+
           "(7,'Rick Grehan'), (8,'Bjarki Holm'), (9,'Tony Loton'),"+
           "(10,'Glen E. Mitchell II'), (11,'Nitin Nanda'),"+
           "(12,'Kelly Lin Poon'), (13,'Sean Rhody'), (14,'Mark Wilcox'),"+
           "(15,'Jess Garms'), (16,'Daniel Somerfield'),"+
           "(17,'John Kauffman'), (18,'Brian Matsik'), "+
           "(19,'Kevin Spencer'), (20,'Tom Walsh');";
      stmt.executeUpdate(upd);
      pstatus = "Tables successfully populated";
      conn.close();

      }
    }catch(Exception e) {
      e.printStackTrace();
    }

  }
  public String gettstatus() {
    return tstatus;
  }
  public String getpstatus() {
     return pstatus;
  }
}