databaseoperate.java~8~

本系统图书馆管理系统

package databaseoperate;

import baseclass.Book;
import baseclass.Worker;
import baseclass.Books;
import baseclass.UserBook;
import baseclass.User;
import java.sql.SQLException;
import java.sql.ResultSet;
import javax.swing.JOptionPane;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
///////////////////////////////////////////////////////
//define the operation to the database
///////////////////////////////////////////////////////

public class DatabaseOperate {

    public static ResultSet rSet = null; // 定义数据库查询的结果集
    public static ResultSet rSet1 = null;


    //insert the list of  UserList
    public static void insertUserList(User user) {
        String sql;
        sql = "select * from UserList where userID='" + user.getUserID() + "'";
        try {
            rSet = DatabaseConnection.statement.executeQuery(sql);
            if (rSet.next() != false) {
                JOptionPane.showOptionDialog(null,
                        "the ID has already been registered!",
                                             "WARNING",
                                             JOptionPane.OK_CANCEL_OPTION,
                                             JOptionPane.WARNING_MESSAGE, null, null, null);
                return;
            } else {
                sql = "insert into UserList (userID,userPWD,userType,userName,userSex,userIC,userDept,userAdd,userTel,userEmail,numOfBook,sumOfBook)values('" +
                      user.getUserID()
                      + "','" + user.getUserPWD() + "','" + user.getUserType()
                      + "','" + user.getUserName() + "','" + user.getUserSex()
                      + "','" + user.getUserIC() + "','" + user.getUserDept()
                      + "','" + user.getUserAdd() + "','" + user.getUserTel()
                      + "','" + user.getUserEmail() + "',0,"
                      + 0 + ")";
                DatabaseConnection.statement.executeUpdate(sql);
            }
        } catch (SQLException ex) { // 捕捉异常
            System.out.println("\nERROR:----- SQLException -----\n");
            while (ex != null) {
                System.out.println("Message:   " + ex.getMessage());
                System.out.println("SQLState:  " + ex.getSQLState());
                System.out.println("ErrorCode: " + ex.getErrorCode());
                ex = ex.getNextException();
            }
        }
        /*sql="insert into UserList (userID,userPWD,userType,userName,userSex,userDept,userIC,userAdd,userTel,userEmail,numOfBook,sumOfBook)values('"+user.getUserID()
                    +"','"+user.getUserPWD()+"','"+user.getUserType()
                    +"','"+user.getUserName()+"','"+user.getUserSex()
                    +"','"+user.getUserIC()+"','"+user.getUserDept()
                    +"','"+user.getUserAdd()+"','"+user.getUserTel()
                    +"','"+user.getUserEmail()+"',0,"
                    +0+")";
                     try{
                DatabaseConnection.statement.executeUpdate(sql);
            }
                     catch(SQLException ex)
                     {                                   // 捕捉异常
            System.out.println("\nERROR:----- SQLException -----\n");
            while (ex != null)
            {
                System.out.println("Message:   " + ex.getMessage());
                System.out.println("SQLState:  " + ex.getSQLState());
                System.out.println("ErrorCode: " + ex.getErrorCode());
                ex = ex.getNextException();
            }

                     }*/
    }


    //insert the list of BooksList
    public static void insertBooksList(Books books)
    {
        try
        {
            String sql;
            sql = "insert into booksList(ISBN,bookName,writer,press,summary,bookType,sumOfBook,numAtLib,price,shelf,publishTime) values ('" +
                  books.getISBN()+ "','" + books.getBookName()+"','"+books.getWriter()+"','"
                  +books.getPress()+"','"+books.getSummary()+"','"+books.getBookType()+"',"
                  +books.getSumOfBook()+","+books.getSumOfBook()+","+books.getPrice()+",'"
                  +books.getShelf()+"','"+books.getPublishTime()+"'";
            DatabaseConnection.statement.executeUpdate(sql);
        }
        catch (SQLException ex)
        { // 捕捉异常
            System.out.println("\nERROR:----- SQLException -----\n");
            while (ex != null)
            {
                System.out.println("Message:   " + ex.getMessage());
                System.out.println("SQLState:  " + ex.getSQLState());
                System.out.println("ErrorCode: " + ex.getErrorCode());
                ex = ex.getNextException();
            }
        }

    }

    //insert the list of BookList
    public static void insertBookList(Book book) {
    }

    //insert the list of BorrowList
    public static void insertBorrowList(UserBook userBook) {
    }

    //insert the list of OrderList
    public static void insertOrderList(UserBook userBook) {
    }

    //insert the list of LackList
    public static void insertLackList(Books Books) {
    }

    //insert the list of DestroyBooksList
    public static void insertDestroyBooksList(Books books) {
    }

    //insert the list of DestroyBookList
    public static void insertDestroyBookList(Book book) {
    }

    //insert the list of WorkerList
    public static void insertWorkerList(Worker worker) {
    }


}