bookmanager.java

一个简单的网上订书系统 java的课程设计

package proxy;

import java.sql.*;

//import connector.Executor;
import connector.Searcher;

public class BookManager {

	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();

	public static int[] insertBooks(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		String insert = "";
		for (int i = 0; i < 20; i++, insert = "") {
			insert += "insert into book values ('BID" + i + "','author" + i
					+ "','title" + i + "','isbn" + i + "','P" + (i % 4)
					+ "','ed" + i + "','2007-1-" + i + "'," + i + ",'des" + i
					+ "','S" + i + "'); ";
			stmt.addBatch(insert);
		}
		return stmt.executeBatch();*/


		insert("BID00001","Isabel Allende","1,000 Places to See Before You Die: A Traveler\\'s Life List ","64915998 ","PID014","5 ","2005-12-21",104.53 ,"As a OOP language,C# is so extensive used. Would you like to learn is?This book may help you.","SCNO004");
		insert("BID00002","Mao Liu","1-2-3 Magic: Effective Discipline for Children 2-12","66100851 ","PID003","2 ","2007-4-24",104.53 ,"Keith Donohue\\'s sparkling debut novel was first presented by the publisher as.","SCNO006");
		insert("BID00003","Carlos Ruiz Zafon","90 Minutes in Heaven: A True Story of Death & Life ","64904443 ","PID012","5 ","2006-11-28",23.95 ,"As the infectious disease become more and more usual, the reseach in infectious disease as become more and more important.","SCNO010");
		insert("BID00004","Mao Liu","A Good Day","66299843 ","PID014","1 ","2007-4-24",34.99 ,"Starred Review. In this remarkable effort, National Book.","SCNO007");
		insert("BID00005","Tom  Adson","A Lesson Before Dying (Oprah\\'s Book Club)","73065552 ","PID011","1 ","2007-5-15",13.95 ,"Keith Donohue\\'s sparkling debut novel was first presented by the publisher as.","SCNO015");
		insert("BID00006","Tom  Adson","A Long Way Gone: Memoirs of a Boy Soldier ","72667569 ","PID013","2 ","2007-5-15",34.99 ,"It\\'s official! Harry Potter and the Deathly Hallows.","SCNO013");
		insert("BID00007","Arturo Perez-Reverte","A Thousand Splendid Suns ","64966073 ","PID012","4 ","2007-5-19",23.95 ,"Do you know the condition of Chinese agriculture? This book will tell you somethings about it. ","SCNO020");
		insert("BID00008","Rhonda Byrne","About diabetes","67692783 ","PID012","2 ","2007-5-1",58.94 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO014");
		insert("BID00009","D. J. MacHale","Absurdistan: A Novel","65023852 ","PID012","4 ","2007-5-5",58.94 ,"Do you want to be a good doctor.What should you do ? Just reading this book you will find out answer.","SCNO016");
		insert("BID00010","Arturo Perez-Reverte","All Together Dead (Southern Vampire Mysteries, Bk. 7) ","65037333 ","PID013","4 ","2007-5-1",34.99 ,"Do you want to be a Test Manager? This book will tell you how to be a good TM.","SCNO009");
		insert("BID00011","Yiming Huang","Always Reading","69284714 ","PID014","2 ","2007-5-5",54.82 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO022");
		insert("BID00012","John Bush","Angela and the Princess","64110937 ","PID011","2 ","2007-4-9",69.02 ,"Starred Review. In this remarkable effort, National Book.","SCNO022");
		insert("BID00013","Patrick Suskind","Animal, Vegetable, Miracle: A Year of Food Life ","64939110 ","PID009","5 ","2007-7-21",64.29 ,"Fragments of a Great Secret have been found in the oral tradition.","SCno004");
		insert("BID00014","Irene Nemirovsky","At the Center of the Storm: My Years at the CIA ","64937184 ","PID010","5 ","2007-7-21",66.66 ,"Fragments of a Great Secret have been found in the oral tradition.","SCno003");
		insert("BID00015","Cynthia Marie Rizzo","Back On Blossom Street (STP - Mira)","65021926 ","PID008","4 ","2007-5-5",38.25 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO017");
		insert("BID00016","John Bush","Bad Luck and Trouble ","63314971 ","PID014","1 ","2006-12-12",59.55 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO018");
		insert("BID00017","Shizhen Li","Ben Cao Gang Mu","58932145 ","PID012","2 ","2006-11-28",58.94 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO008");
		insert("BID00018","John Bush","Bird Songs ","63513962 ","PID014","1 ","2007-1-12",61.92 ,"It\\'s official! Harry Potter and the Deathly Hallows.","SCNO019");
		insert("BID00019","E. M. Forster","Blackwater: The Rise of the World\\'s Most Powerful Mercenary Army ","64908294 ","PID012","5 ","2006-11-28",16.00 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO008");
		insert("BID00020","Marisa de los Santos","Blink: The Power of Thinking Without Thinking ","64942962 ","PID015","5 ","2007-7-21",59.55 ,"Fragments of a Great Secret have been found in the oral tradition.","SCno004");
		insert("BID00021","John Bush","Brown Bear, Brown Bear, What Do You See?","63712954 ","PID013","1 ","2007-2-6",64.29 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO020");
		insert("BID00022","Christopher Hitchens ","C# Programing","61922031 ","PID008","1 ","2006-11-28",42.98 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO011");
		insert("BID00023","Angie Sage","Changing Light: A Novel","64977629 ","PID010","4 ","2007-5-15",104.53 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO014");
		insert("BID00024","J.K. Rowling","Christine Falls: A Novel","65054667 ","PID008","3 ","2007-4-24",12.00 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO026");
		insert("BID00025","Sara Gruen","Customers","84572654 ","PID010","2 ","2007-7-21",12.00 ,"You see if there is no Dr.Yuan maybe we don\\'t enough food to eat. This book is just tell you about the cross rice and Yuan himself.","SCno003");
		insert("BID00026","John Bush","DataBase","63911945 ","PID010","1 ","2007-4-5",66.66 ,"Keith Donohue\\'s sparkling debut novel was first presented by the publisher as.","SCNO021");
		insert("BID00027","Ken Follett","Eat, Pray, Love: One Woman\\'s Search for Everything Across Italy, India and Indonesia  ","65056593 ","PID012","3 ","2007-4-24",12.00 ,"How much do you know about diabetes which is one of the greatest killer for human being","SCNO025");
		insert("BID00028","Jodi Picoult","Eclipse1","65066223 ","PID013","3 ","2007-2-6",59.55 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO020");
		insert("BID00029","Ernest J. Gaines","Eclipse2","65045037 ","PID001","3 ","2007-4-24",97.43 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO005");
		insert("BID00030","Jonathan Safran Foer","Eclipse3","65050815 ","PID008","3 ","2007-4-24",23.00 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO002");
		insert("BID00031","Debbie Macomber","Einstein: His Life and Universe ","64962221 ","PID007","4 ","2007-5-22",58.94 ,"Do you want to be a good doctor.What should you do ? Just reading this book you will find out answer.","SCNO022");
		insert("BID00032","Thrity Umrigar","Eldest (Inheritance, Book 2)","65093186 ","PID010","5 ","2006-5-15",16.00 ,"Do you want to be a Test Manager? This book will tell you how to be a good TM.","SCNO006");
		insert("BID00033","J.R.R. Tolkien","Epicenter: Why Current Rumblings in the Middle East Will Change Your Future ","65100890 ","PID003","5 ","2004-2-16",104.53 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO002");
		insert("BID00034","Dongjian Zhang","Epidemiology","64309928 ","PID012","2 ","2007-4-24",12.00 ,"Starred Review. In this remarkable effort, National Book.","SCNO023");
		insert("BID00035","Bill Martin Jr.","Eventide","64993036 ","PID008","4 ","2007-5-8",12.00 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO006");
		insert("BID00036","David Wiesner","Extreme Fat Smash Diet ","64991110 ","PID007","4 ","2007-5-8",23.00 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO007");
		insert("BID00037","Rowling J. K.","Extremely Loud and Incredibly Close: A Novel","64981481 ","PID014","4 ","2007-5-15",99.80 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO012");
		insert("BID00038","Kent Haruf","Falling Man: A Novel ","64917924 ","PID014","5 ","2005-2-4",102.17 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO003");
		insert("BID00039","Claire Messud","Fancy Nancy and the Posh Puppy (Fancy Nancy) ","65018074 ","PID009","4 ","2007-5-5",42.98 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO019");
		insert("BID00040","Pam Jenoff","Flotsam (Caldecott Medal Book)","65083556 ","PID008","8 ","2006-11-28",38.25 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO011");
		insert("BID00041","Margaret Wise Brown","For One More Day","65095112 ","PID013","1 ","2006-2-15",13.95 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO005");
		insert("BID00042","Zhongxiang Wang","For One More Day ","71672612 ","PID009","1 ","2007-5-8",95.06 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO008");
		insert("BID00043","J.K ROb","Freakonomics [Revised and Expanded]: A Rogue Economist Explores the Hidden Side of Everything ","69682697 ","PID013","2 ","2007-5-8",59.55 ,"Starred Review. In this remarkable effort, National Book.","SCNO024");
		insert("BID00044","Kiran Desai","Getting Things Done: The Art of Stress-Free Productivity ","64933332 ","PID002","5 ","2007-7-21",12.00 ,"It will bring you to the world of physics.You will know something that you may be supprise.","SCno003");
		insert("BID00045","Bella Andre","God Is Not Great: How Religion Poisons Everything ","65046963 ","PID009","3 ","2007-4-24",95.06 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO004");
		insert("BID00046","Pam Jenoff","Good to Great ","64946813 ","PID012","5 ","2007-5-22",54.82 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCno005");
		insert("BID00047","Marisa de los Santos","Goodnight Moon (Board Book)","65064297 ","PID010","3 ","2007-4-5",61.92 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO021");
		insert("BID00048","Don Huaffman","Gos Noion Pohing","64707911 ","PID012","1 ","2007-4-24",23.00 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO025");
		insert("BID00049","Dongjian Zhang","Grikgi Skirk ","64508920 ","PID015","2 ","2007-4-24",12.00 ,"It\\'s official! Harry Potter and the Deathly Hallows.","SCNO024");
		insert("BID00050","J.K. Rowling","Harry Potter and the Chamber of Secrets (Book 2)  ","94489505 ","PID003","1 ","2004-2-16",25.95 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO002");
		insert("BID00051","J.K. Rowling","Harry Potter and the Deathly Hallows (Book 7)","46579807 ","PID011","1 ","2006-6-2",24.99 ,"It\\'s official! Harry Potter and the Deathly Hallows.","SCNO007");
		insert("BID00052","J.K. Rowling","Harry Potter and the Goblet of Fire (Book 4)","43111973 ","PID014","1 ","2005-12-21",16.00 ,"Starred Review. In this remarkable effort, National Book.","SCNO004");
		insert("BID00053","J.K. Rowling","Harry Potter and the Half-Blood Prince (Book 6)","82701709 ","PID010","1 ","2006-5-15",23.95 ,"Fragments of a Great Secret have been found in the oral tradition.","SCNO006");
		insert("BID00054","Yu Wang","Harry Potter and the Half-Blood Prince (Book 6) ","70478663 ","PID015","1 ","2007-5-8",69.02 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO002");
		insert("BID00055","J.K. Rowling","Harry Potter and the Order of the Phoenix (Book 5)","74106789 ","PID013","1 ","2006-2-15",22.00 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO005");
		insert("BID00056","J.K. Rowling","Harry Potter and the Prisoner of Azkaban (Book 3)","40096537 ","PID014","1 ","2005-2-4",13.95 ,"Keith Donohue\\'s sparkling debut novel was first presented by the publisher as.","SCNO003");
		insert("BID00057","J.K. Rowling","Harry Potter and the Sorcerer\\'s Stone (Book 1)","45010225 ","PID001","1 ","2003-2-3",34.99 ,"It\\'s official! Harry Potter and the Deathly Hallows.","SCNO001");
		insert("BID00058","J.K. Rowling","Harry Potter Boxset Books 1-7","54687426 ","PID005","1 ","2007-7-21",95.06 ,"Do you want to be a good doctor.What should you do ? Just reading this book you will find out answer.","SCno002");
		insert("BID00059","J.K. Rowling","Harry Potter Paperback Box Set (Books 1-6) ","65091260 ","PID011","2 ","2006-6-2",22.00 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO007");
		insert("BID00060","Cynthia Marie Rizzo","Harry Potter Paperback Box Set (Books 1-6) ","64900591 ","PID012","5 ","2006-11-28",58.94 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO012");
		insert("BID00061","J.K. Rowling","Healthy Sleep Habits, Happy Child","65048889 ","PID007","3 ","2007-4-24",6.00 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO003");
		insert("BID00062","Zhongxiang Wang","How Doctors Think ","72070595 ","PID003","1 ","2007-5-15",99.80 ,"Starred Review. In this remarkable effort, National Book.","SCNO010");
		insert("BID00063","Don Huaffman","How to plant corn","65105894 ","PID012","1 ","2007-4-24",6.00 ,"Starred Review. In this remarkable effort, National Book.","SCNO001");
		insert("BID00064","Yiming Huang","How to Win Friends & Influence People ","69085723 ","PID003","1 ","2007-5-5",52.45 ,"It\\'s official! Harry Potter and the Deathly Hallows.","SCNO021");
		insert("BID00065","Gary Shteyngart","I Feel Bad About My Neck: And Other Thoughts on Being a Woman ","87458425 ","PID009","2 ","2007-7-21",97.43 ,"How much do you know about diabetes which is one of the greatest killer for human being","SCno002");
		insert("BID00066","Barbara Kingsolver","I Heard That Song Before: A Novel ","64914072 ","PID013","5 ","2006-2-15",34.99 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO005");
		insert("BID00067","Keith Donohue","In Lucia\\'s Eyes","74060509 ","PID012","2 ","2007-5-19",58.94 ,"Keith Donohue\\'s sparkling debut novel was first presented by the publisher as.","SCNO020");
		insert("BID00068","Jonathan Safran Foer","Infidel ","64906368 ","PID015","5 ","2006-11-28",22.00 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO009");
		insert("BID00069","Susan Elizabeth Phillips","Invisible Prey ","64941036 ","PID002","5 ","2007-7-21",61.92 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCno004");
		insert("BID00070","Susan Elizabeth Phillips","It\\'s Time to Call 911: What to Do in an Emergency (It\\'s Time to)","65031555 ","PID012","4 ","2007-5-1",16.00 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO012");
		insert("BID00071","Don Huaffman","Java Programing","65304885 ","PID008","1 ","2007-4-24",95.06 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO002");
		insert("BID00072","Patrick Suskind","Jesus of Nazareth ","65081630 ","PID012","5 ","2006-11-28",40.62 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO012");
		insert("BID00073","Tom  Adson","Julie and the Unicorn 1","72866561 ","PID010","2 ","2007-5-15",25.95 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO014");
		insert("BID00074","Sara Gruen","Julie and the Unicorn 2","54266716 ","PID003","2 ","2007-7-21",23.00 ,"Do you know the condition of Chinese agriculture? This book will tell you somethings about it. ","SCno003");
		insert("BID00075","Sara Gruen","Julie and the Unicorn 3","41254465 ","PID002","5 ","2007-7-21",6.00 ,"The great works is medicine field. You will find the power of Cao Medicine.","SCno002");
		insert("BID00076","Kevin Henkes","Law of Attraction: The Science of Attracting More of What You Want and Less of What You Don\\'t ","64996888 ","PID008","4 ","2007-5-8",69.02 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO004");
		insert("BID00077","Khaled Hosseini ","Lean Mean Thirteen (Stephanie Plum Novels) ","75055467 ","PID003","1 ","2007-5-22",47.72 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCNO025");
		insert("BID00078","Benjamin Black","Little Green Book of Getting Your Way: How to Speak, Write, Present, Persuade, Influence, and Sell Your Point of View to Others ","64925628 ","PID009","5 ","2007-7-21",6.00 ,"It\\'s difficult to imagine a harder first act to follow than The Kite Runner.","SCno002");
		insert("BID00079","Nathaniel Philbrick","Love Walked In","71075638 ","PID012","2 ","2007-5-8",23.00 ,"In his sixth book of combustible investigative journalism, Langewiesche.","SCNO005");