bookiteminit.java

JAVA图书管理软件源码,是我师兄亲自参与编的毕业设计

package com.ivan.bookManage;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import com.ivan.db.Database;

public class BookItemInit
{

	public static Vector<String> getISBN()
	{
		Vector<String> isbn =new Vector<String>() ;
		Connection connection;
		ResultSet rs=null;
		String sql="select distinct ISBN from book";
		
		connection = Database.getConnection();            //建立数据库连接
		Statement stmt=null;
		
		try 
		{
			stmt= connection.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				isbn.add(rs.getString("ISBN"));
			}
				
			return isbn;
	   }
		catch (SQLException e) 
		{
			
			e.printStackTrace();
		}
		
		finally
		{
			try 
			{
				connection.close();
			} 
			catch (SQLException e)
			{
				
				e.printStackTrace();
			}
		}
		return null;
	}
	
	
	public static Vector<String> getBookId(String isbn)
	{
		Vector<String> bookId =new Vector<String>() ;
		Connection connection;
		ResultSet rs=null;
		String sql="select  bookId from bookitem where ISBN='"+isbn+"';";
		
		connection = Database.getConnection();            //建立数据库连接
		Statement stmt=null;
		
		try 
		{
			stmt= connection.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				bookId.add(rs.getString("bookId"));
			}
				
			return bookId;
	   }
		catch (SQLException e) 
		{
			
			e.printStackTrace();
		}
		
		finally
		{
			try 
			{
				connection.close();
			} 
			catch (SQLException e)
			{
				
				e.printStackTrace();
			}
		}
		return null;
	}
	
	public static String getStatus(String bookId)
	{
		String status="";
		Connection connection;
		ResultSet rs=null;
		String sql="select status from bookitem where bookId='"+bookId+"';";
		
		connection = Database.getConnection();            //建立数据库连接
		Statement stmt=null;
		
		try 
		{
			stmt= connection.createStatement();
			rs=stmt.executeQuery(sql);
			if(rs.next())			
				status=rs.getString("status");
			
				
			return status;
	   }
		catch (SQLException e) 
		{
			
			e.printStackTrace();
		}
		
		finally
		{
			try 
			{
				connection.close();
			} 
			catch (SQLException e)
			{
				
				e.printStackTrace();
			}
		}
		return null;
	}
}