databaseoperate.java~3~

本系统图书馆管理系统

package databaseoperate;

import baseclass.Book;
import baseclass.Worker;
import baseclass.Books;
import baseclass.UserBook;
import baseclass.User;

/**
 * <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 {

        //insert the list of  UserList
        public static void insertUserList(User user)
        {
                String sql;
                sql="insert into UserList 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(Exception e) {
                    System.out.println(e);
                }
        }


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




}