?? databasequery.java
字號(hào):
try
{
String sql="select * from BookInformation where bookIndex="+books.book.getBookIndex();
rSet=DatabaseConnection.statement.executeQuery(sql);
while(rSet.next()!=false)
{
Vector rec_vector = new Vector();
rec_vector.addElement(rSet.getString("ISBN"));
rec_vector.addElement(String.valueOf(rSet.getInt("bookIndex")));
rec_vector.addElement(rSet.getString("bookName"));
rec_vector.addElement(rSet.getString("writer"));
rec_vector.addElement(rSet.getString("bookType"));
rec_vector.addElement(rSet.getString("press"));
rec_vector.addElement(rSet.getString("publishTime"));
rec_vector.addElement(rSet.getString("bookState"));
rec_vector.addElement(rSet.getString("shelf"));
vector.addElement(rec_vector); // 向量rec_vector加入向量vector中
}
rSet.close();
}
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();
}
}
return vector;
}
////////////////////////////////////////////////////////////////////////////
// query BooksList to whether the book exist with the input name
////////////////////////////////////////////////////////////////////////////
public static boolean bookInformationQueryForWhetherExistWithName(Books books)
{
try
{
String sql="select * from BookInformation where bookName='"+books.getBookName()+"'";
rSet=DatabaseConnection.statement.executeQuery(sql);
if(rSet.next()==false)
{
rSet.close();
return false;
}
}
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();
}
}
return true;
}
/////////////////////////////////////////////////////////////////////////
//query bookInformation to gain the information of one book with the name Index
/////////////////////////////////////////////////////////////////////////
public static Vector bookInformationQueryForInformationWithName(Books books,Vector vector)
{
Books bookOne=new Books();
try
{
String sql="select * from BookInformation where bookName='"+books.getBookName()+"'";
rSet=DatabaseConnection.statement.executeQuery(sql);
while(rSet.next()!=false)
{
Vector rec_vector = new Vector();
rec_vector.addElement(rSet.getString("ISBN"));
rec_vector.addElement(String.valueOf(rSet.getInt("bookIndex")));
rec_vector.addElement(rSet.getString("bookName"));
rec_vector.addElement(rSet.getString("writer"));
rec_vector.addElement(rSet.getString("bookType"));
rec_vector.addElement(rSet.getString("press"));
rec_vector.addElement(rSet.getString("publishTime"));
rec_vector.addElement(rSet.getString("bookState"));
rec_vector.addElement(rSet.getString("shelf"));
vector.addElement(rec_vector); // 向量rec_vector加入向量vector中
}
rSet.close();
}
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();
}
}
return vector;
}
////////////////////////////////////////////////////////////////////////////
// query BooksList to whether the book exist with the input name
////////////////////////////////////////////////////////////////////////////
public static boolean bookInformationQueryForWhetherExistWithType(Books books)
{
try
{
String sql="select * from BookInformation where bookType='"+books.getBookType()+"'";
rSet=DatabaseConnection.statement.executeQuery(sql);
if(rSet.next()==false)
{
rSet.close();
return false;
}
}
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();
}
}
return true;
}
/////////////////////////////////////////////////////////////////////////
//query bookInformation to gain the information of one book with the name Type
/////////////////////////////////////////////////////////////////////////
public static Vector bookInformationQueryForInformationWithType(Books books,Vector vector)
{
Books bookOne=new Books();
try
{
String sql="select * from BookInformation where bookType='"+books.getBookType()+"'";
rSet=DatabaseConnection.statement.executeQuery(sql);
while(rSet.next()!=false)
{
Vector rec_vector = new Vector();
rec_vector.addElement(rSet.getString("ISBN"));
rec_vector.addElement(String.valueOf(rSet.getInt("bookIndex")));
rec_vector.addElement(rSet.getString("bookName"));
rec_vector.addElement(rSet.getString("writer"));
rec_vector.addElement(rSet.getString("bookType"));
rec_vector.addElement(rSet.getString("press"));
rec_vector.addElement(rSet.getString("publishTime"));
rec_vector.addElement(rSet.getString("bookState"));
rec_vector.addElement(rSet.getString("shelf"));
vector.addElement(rec_vector); // 向量rec_vector加入向量vector中
}
rSet.close();
}
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();
}
}
return vector;
}
/////////////////////////////////////////////////////////////////////////
//query UserBorrowVies for imformation of one borrow books
/////////////////////////////////////////////////////////////////////////
public static Vector userBorrowViewQueryForInformation(User user,Vector vector)
{
try
{
String sql="select * from UserBorrowView where userID='"+user.getUserID()+"'";
rSet=DatabaseConnection.statement.executeQuery(sql);
while(rSet.next()!=false)
{
Vector rec_vector = new Vector();
rec_vector.addElement(rSet.getString("userID"));
rec_vector.addElement(rSet.getString("userName"));
rec_vector.addElement(String.valueOf(rSet.getInt("bookIndex")));
rec_vector.addElement(rSet.getString("bookName"));
rec_vector.addElement(rSet.getString("startDate"));
rec_vector.addElement(rSet.getString("endDate"));
vector.addElement(rec_vector); // 向量rec_vector加入向量vector中
}
rSet.close();
}
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();
}
}
return vector;
}
/////////////////////////////////////////////////////////////////////////
//query UserOrderVies for imformation of one order books
/////////////////////////////////////////////////////////////////////////
public static Vector userOrderViewQueryForInformation(User user,Vector vector)
{
try
{
String sql="select * from UserOrderView where userID='"+user.getUserID()+"'";
rSet=DatabaseConnection.statement.executeQuery(sql);
while(rSet.next()!=false)
{
Vector rec_vector = new Vector();
rec_vector.addElement(rSet.getString("userID"));
rec_vector.addElement(rSet.getString("userName"));
rec_vector.addElement(String.valueOf(rSet.getInt("bookIndex")));
rec_vector.addElement(rSet.getString("bookName"));
rec_vector.addElement(rSet.getString("startDate"));
rec_vector.addElement(rSet.getString("endDate"));
vector.addElement(rec_vector); // 向量rec_vector加入向量vector中
}
rSet.close();
}
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();
}
}
return vector;
}
private void jbInit() throws Exception {
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -