Sistem Manajemen Database Perpustakaan Java

Java Library Database Management System Project

    Kali ini saya akan memberikan contoh tentang sebuah sistem managemen database java sederhana yang pernah saya buat dengan menggunakan bahasa pemograman Java. Mungkin bagi temen - temen yang ingin mengembangkan project saya ini menjadi lebih baik lagi silakan saja.

java code

?

package connectingdatabase;

  

import ReportGen.ReportPanel;

import connectingdatabase.Search.AuthorSearch;

import connectingdatabase.Search.BookSearch;

import connectingdatabase.Search.BookStoreSearch;

import connectingdatabase.Search.PublisherSearch;

import connectingdatabase.Search.VisitorSearch;

import java.awt.BorderLayout;

import java.awt.Container;

import java.awt.Graphics;

import java.awt.Image;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.WindowEvent;

import java.awt.event.WindowListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import javax.swing.Icon;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JDialog;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JSplitPane;

import javax.swing.JTabbedPane;

import javax.swing.JTable;

import javax.swing.JTextArea;

import javax.swing.JToolBar;

import javax.swing.event.ChangeEvent;

import javax.swing.event.ChangeListener;

import javax.swing.table.AbstractTableModel;

import myMenuPack.myJMenu;

  

  

  

/**

 *

 * @author codemiles

 */

public class Main extends JFrame {

     

    /** Creates a new instance of Main */

    public Main()

    {

             start.show(); 

      setTitle("DataBase Project");

      setSize(800,700);

      setLocation(200,0);

       

          try {

         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

            System.out.println("Driver Exits !!!");

             

           connection = DriverManager.getConnection(

    "jdbc:microsoft:sqlserver://Casper:6666","msi_333","11991199");

            Main.myArea.append("Connection Established !!!\n");

            } catch (ClassNotFoundException ex) {

            ex.printStackTrace();

        }

          catch (SQLException ex) {

            Main.myArea.append(ex.toString());

        }

       

      Container cp=getContentPane();

      

       

       

      myTables[0]=new VisitorTable(connection);

      myTables[1]=new BookTable( connection);

      myTables[2]=new AuthorTable(connection);

      myTables[3]=new PublisherTable(connection);

      myTables[4]=new BookStoreTable(connection);

       

      mySP[0]=new JScrollPane(myTables[0],JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,

                    JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

        

      mySP[1]=new JScrollPane(myTables[1],JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,

                    JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

      mySP[2]=new JScrollPane(myTables[2],JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,

                    JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

      mySP[3]=new JScrollPane(myTables[3],JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,

                    JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

      mySP[4]=new JScrollPane(myTables[4],JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,

                    JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

       

      myToolbar =new myToolbar(tabbedPane,this,connection);

       

      tabbedPane.addTab("Vistor", mySP[0]);

        

      tabbedPane.addTab("Book", mySP[1]);

      tabbedPane.addTab("Author", mySP[2]);

      tabbedPane.addTab("Publisher", mySP[3]);

      tabbedPane.addTab("Book Store", mySP[4]);

       

       tabbedPane.addChangeListener(new ChangeListener() {

           public void stateChanged(ChangeEvent e) {

                switch(tabbedPane.getSelectedIndex())

                  {

                      case 0:((VisitorTable)(myTables[0])).ChangeModel() ;break;     

                      case 1:((BookTable)(myTables[1])).ChangeModel();break;

                      case 2:((AuthorTable)(myTables[2])).ChangeModel();break;

                      case 3:((PublisherTable)(myTables[3])).ChangeModel();break;

                      case 4:((BookStoreTable)(myTables[4])).ChangeModel();break;

                       

                      default :break;

                  }

                

           }

       });

      mySplitePane=new JSplitPane(JSplitPane.VERTICAL_SPLIT,tabbedPane,myControlArea);

      cp.add(myToolbar,BorderLayout.NORTH);

      cp.add(mySplitePane);

        

         

      addWindowListener(new WindowListener() {

          public void windowActivated(WindowEvent e) {

          }

          public void windowClosed(WindowEvent e) {

          }

          public void windowClosing(WindowEvent e) {

            Main.myArea.append("Connection Closed !!!\n")     ;

                try {

                    if(connection!=null) {

                        connection.close();

                    }

                     

                } catch (SQLException ex) {

                    ex.printStackTrace();

                }

               

          }

          public void windowDeactivated(WindowEvent e) {

          }

          public void windowDeiconified(WindowEvent e) {

          }

          public void windowIconified(WindowEvent e) {

          }

          public void windowOpened(WindowEvent e) {

          }

      });

       

     

           start.dispose();

        setJMenuBar(myJM);

      setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

      setVisible(true);

       

       

    }

      

    /**

     * @param args the command line arguments

     */

    public static void main(String[] args)  {

          

        // TODO code application logic here

         

        new Main();

    }

     

      

    public static Connection connection;

    private JTabbedPane tabbedPane=new JTabbedPane();

      

    public static JTextArea myArea=new JTextArea(1,1);

    private JScrollPane myControlArea=new JScrollPane(myArea,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS

            ,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

    private JSplitPane mySplitePane;

    private JPanel[] myTables=new JPanel[5];

    private JScrollPane[] mySP=new JScrollPane[5];

    private myToolbar myToolbar ;

    private myJMenu myJM=new myJMenu();

    public static String CompName="Casper";

    public static String Port="6666";

      private myStart start=new myStart();

}

class myToolbar extends JToolBar

{

    public myToolbar(final JTabbedPane Tabbed,final JFrame myMother,final Connection conn)

    {

      //  setLayout(null);

            AddImag=new ImageIcon("icons/Add.png");

             

        SearchImag=new ImageIcon("icons/Search.png");

        ModifyImag=new ImageIcon("icons/Modify.png");

        RemoveImag=new ImageIcon("icons/Remove.png");

        BorrowImag=new ImageIcon("icons/Borrow.png");

        ReturnImag=new ImageIcon("icons/Return.png");

        ReportImag=new ImageIcon("icons/Report.png");

        MasterImag=new ImageIcon("icons/Master.png");

         

        AddBut=new JButton("Add", AddImag);

        SearchBut=new JButton("Search",SearchImag);

        ModifyBut=new JButton("Modify",ModifyImag);

         RemoveBut=new JButton("Remove",RemoveImag);

         BorrowBut=new JButton("Borrow",BorrowImag);

         ReturnBut=new JButton("Return",ReturnImag);

         ReportBut=new JButton("Report",ReportImag);

         MasterBut=new JButton("Master",MasterImag);

          AddBut.setAlignmentY(CENTER_ALIGNMENT);

           SearchBut.setAlignmentY(CENTER_ALIGNMENT);

            ModifyBut.setAlignmentY(CENTER_ALIGNMENT);

              RemoveBut.setAlignmentY(CENTER_ALIGNMENT);

              ReturnBut.setAlignmentY(CENTER_ALIGNMENT);

                   ReportBut.setAlignmentY(CENTER_ALIGNMENT);

                   MasterBut.setAlignmentY(CENTER_ALIGNMENT);

         add(AddBut);

        add(SearchBut);

        add(ModifyBut);

        add(RemoveBut);

        add(BorrowBut);

        add(ReturnBut);

        add(ReportBut);

        add(MasterBut);

        AddBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e)

            {

                  

              

                  switch(Tabbed.getSelectedIndex())

                  {

                      case 0:((new VisitorPanel(conn,myMother))).show();break;     

                      case 1:(new BookPanel(conn,myMother)).show();break;

                      case 2:(new AuthorPanel(conn,myMother)).show();break;

                      case 3:(new PublisherPanel(conn,myMother)).show();break;

                      case 4:(new BookStorePanel(conn,myMother)).show();break;

                       

                      default :break;

                  }

               

            }

        });

         SearchBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                   

                 

                switch(Tabbed.getSelectedIndex())

                {

                    case 0:(new VisitorSearch(conn,myMother)).show();break;     

                    case 1:(new BookSearch(conn,myMother)).show();break;

                    case 2:(new AuthorSearch(conn,myMother)).show();break;

                    case 3:(new PublisherSearch(conn,myMother)).show();break;

                    case 4:(new BookStoreSearch(conn,myMother)).show();break;

                     

                    default :break;

                }

                   

                 

            }

        });

         ModifyBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                  

              

                 

                switch(Tabbed.getSelectedIndex())

                {

                    case 0:(new VisitorModifyPanel(conn,myMother)).show();break;     

                    case 1:(new BookModifyPanel(conn,myMother)).show();break;

                    case 2:(new AuthorModifyPanel(conn,myMother)).show();break;

                    case 3:(new PublisherModifyPanel(conn,myMother)).show();break;

                    case 4:(new BookStoreModifyPanel(conn,myMother)).show();break;

                     

                    default :break;

                }

                 

            }

        });

         RemoveBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                  

              

                 

                switch(Tabbed.getSelectedIndex())

                 {

                     case 0:(new VisitorRemovePanel(conn,myMother)).show();break;     

                     case 1:(new BookRemovePanel(conn,myMother)).show();break;

                     case 2:(new AuthorRemovePanel(conn,myMother)).show();break;

                     case 3:(new PublisherRemovePanel(conn,myMother)).show();break;

                     case 4:(new BookStoreRemovePanel(conn,myMother)).show();break;

                      

                     default :break;

                 }

            }

        });

         

         BorrowBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e)

            {

                new BorrowBookPanel(conn,myMother).show();

            }

        });

         

         ReturnBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                 

                new ReturnedBookPanel(conn,myMother).show();

            }

        });

         

         ReportBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                new ReportPanel(conn,myMother).show();

            }

        });

        MasterBut.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                new BKStoreMaster(conn,myMother).show();

            }

        });

    }

     

     

  private JButton AddBut ;

  private JButton SearchBut ;

  private JButton ModifyBut ;

  private JButton RemoveBut ;

  private JButton BorrowBut ;

  private JButton ReturnBut ;

  private JButton ReportBut ;

  private JButton MasterBut ;

  private  Icon AddImag;

  private  Icon SearchImag;

  private  Icon ModifyImag;

  private  Icon RemoveImag;

  private  Icon BorrowImag;

  private  Icon ReturnImag;

  private  Icon ReportImag;

  private  Icon MasterImag;

}

class myStart extends JDialog

{

    myStart()

    {

         

        setUndecorated(true);

      //  setIgnoreRepaint(true);

        setResizable(false);

        setSize(150,150);

        setLocation(400,300);

         

    }

      

    private Image Imgstart=new ImageIcon("icons/back.png").getImage();

    public void paint(Graphics g) {

        g.drawImage(Imgstart,0,0,this);

    }

}

Note : Shilakan mencoba bila masih kesulitan mebuat project

ini bisa komentar di bawah ini siap saya bantu.

Terimakasih telah mengunjungi blog saya ini.
Pengunjung yg baik selalu ninggalin jejak :)

Salam Wani Sinau!

ini sekalian sql codenya masbro dan mbakbro

Semua jars yang dibutuhkan ada di arsip proyek. Berikut adalah database SQL / DML

SQL Code

/*==============================================================*/

/* Database name:  ConceptualDataModel_4                        */

/* Created on:     12/17/2006 8:02:06 AM                        */

/*==============================================================*/

/*==============================================================*/

/* Table: Author                                                */

/*==============================================================*/

create table Author (

A_ID                 int                  not null,

Name                 text                 null,

Adress               text                 null,

"Phone.no"           bigint               null,

Nationality          text                 null,

constraint PK_AUTHOR primary key  (A_ID)

)

go

/*==============================================================*/

/* Table: Book                                                  */

/*==============================================================*/

create table Book (

B_ID                 int                  not null,

P_ID                 int                  not null,

Title                text                 null,

No_of_Copies         int                  null,

Price                int                  null,

ISBN                 text                 null,

Type                 text                 null,

constraint PK_BOOK primary key  (B_ID)

)

go

/*==============================================================*/

/* Index: publish_FK                                            */

/*==============================================================*/

create   index publish_FK on Book (

P_ID

)

go

/*==============================================================*/

/* Table: Book_store                                            */

/*==============================================================*/

create table Book_store (

BS_ID                int                  not null,

Storage_Space        int                  null,

Phone_no             text                 null,

Address              text                 null,

constraint PK_BOOK_STORE primary key  (BS_ID)

)

go

/*==============================================================*/

/* Table: Borrow                                                */

/*==============================================================*/

create table Borrow (

ID                   int                  not null,

memberChip_Serial    varchar(1)           not null,

B_ID                 int                  not null,

constraint PK_BORROW primary key  (ID, memberChip_Serial, B_ID)

)

go

/*==============================================================*/

/* Index: Borrow_FK                                             */

/*==============================================================*/

create   index Borrow_FK on Borrow (

ID,

memberChip_Serial

)

go

/*==============================================================*/

/* Index: Borrow2_FK                                            */

/*==============================================================*/

create   index Borrow2_FK on Borrow (

B_ID

)

go

/*==============================================================*/

/* Table: Contain                                               */

/*==============================================================*/

create table Contain (

BS_ID                int                  not null,

B_ID                 int                  not null,

constraint PK_CONTAIN primary key  (BS_ID, B_ID)

)

go

/*==============================================================*/

/* Index: Contain_FK                                            */

/*==============================================================*/

create   index Contain_FK on Contain (

BS_ID

)

go

/*==============================================================*/

/* Index: Contain2_FK                                           */

/*==============================================================*/

create   index Contain2_FK on Contain (

B_ID

)

go

/*==============================================================*/

/* Table: Member                                                */

/*==============================================================*/

create table Member (

ID                   int                  not null,

memberChip_Serial    varchar(1)           not null,

payment              money                null,

memberChip_End       datetime             null,

numOf_BorrBook       int                  null,

Name                 text                 null,

Address              text                 null,

Phone                char(11)             null,

Age                  int                  null,

Gander               text                 null,

isMember             bit                  null,

constraint PK_MEMBER primary key  (ID, memberChip_Serial)

)

go

/*==============================================================*/

/* Index: Inheritance_1_FK                                      */

/*==============================================================*/

create   index Inheritance_1_FK on Member (

ID

)

go

/*==============================================================*/

/* Table: Publisher                                             */

/*==============================================================*/

create table Publisher (

P_ID                 int                  not null,

Name                 text                 null,

Country              text                 null,

Address              text                 null,

"Phone.no"           bigint               null,

constraint PK_PUBLISHER primary key  (P_ID)

)

go

/*==============================================================*/

/* Table: Visitor                                               */

/*==============================================================*/

create table Visitor (

ID                   int                  not null,

Name                 text                 null,

Address              text                 null,

Phone                char(11)             null,

Age                  int                  null,

Gander               text                 null,

isMember             bit                  null,

constraint PK_VISITOR primary key  (ID)

)

go

/*==============================================================*/

/* Table: Write                                                 */

/*==============================================================*/

create table Write (

A_ID                 int                  not null,

B_ID                 int                  not null,

constraint PK_WRITE primary key  (A_ID, B_ID)

)

go

/*==============================================================*/

/* Index: Write_FK                                              */

/*==============================================================*/

create   index Write_FK on Write (

A_ID

)

go

/*==============================================================*/

/* Index: Write2_FK                                             */

/*==============================================================*/

create   index Write2_FK on Write (

B_ID

)

go

alter table Book

   add constraint FK_BOOK_PUBLISH_PUBLISHE foreign key (P_ID)

      references Publisher (P_ID)

go

alter table Borrow

   add constraint FK_BORROW_BORROW_MEMBER foreign key (ID, memberChip_Serial)

      references Member (ID, memberChip_Serial)

go

alter table Borrow

   add constraint FK_BORROW_BORROW2_BOOK foreign key (B_ID)

      references Book (B_ID)

go

alter table Contain

   add constraint FK_CONTAIN_CONTAIN_BOOK_STO foreign key (BS_ID)

      references Book_store (BS_ID)

go

alter table Contain

   add constraint FK_CONTAIN_CONTAIN2_BOOK foreign key (B_ID)

      references Book (B_ID)

go

alter table Member

   add constraint FK_MEMBER_INHERITAN_VISITOR foreign key (ID)

      references Visitor (ID)

go

alter table Write

   add constraint FK_WRITE_WRITE_AUTHOR foreign key (A_ID)

      references Author (A_ID)

go