databaseoperate.java~5~

本系统图书馆管理系统

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,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+")";
                    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)
        {
        }

        //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)
        {
        }




}