booklist.java

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

package com.ivan.printBook;

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 BookList
{
	
	
	public static  Vector<String[]> getRowData(int model)
	{
		Vector<String[]> v = new Vector<String[]>();
		Connection connection;
		ResultSet rs=null;
		String sql=null;
		
		if(model==1)
			sql="select book.ISBN,bookId,bookName,author,press,edition,type,language,price,loc from" +
					" book,bookitem where book.ISBN=bookitem.ISBN ";
		else if(model==2)
			sql="select book.ISBN,bookId,bookName,author,press,edition,type,language,price,loc from" +
			" book,bookitem where book.ISBN=bookitem.ISBN and bookitem.status='已借出'";
		else if(model==3)
			sql="select book.ISBN,bookId,bookName,author,press,edition,type,language,price,loc from" +
			" book,bookitem where book.ISBN=bookitem.ISBN and bookitem.status='未借出'";
		
		connection = Database.getConnection();            //建立数据库连接
		Statement stmt=null;
		
		try 
		{
			stmt= connection.createStatement();
			rs=stmt.executeQuery(sql);
			
		     while(rs.next())
		     {
		    	
		    	
		    	String[] rowdata=new String[10];
				for(int i=1;i<11;i++)
					rowdata[i-1]=rs.getString(i);
				v.addElement(rowdata);
		      
		     }
		     
		     return v;
		} 
		catch (SQLException e) 
		{
			
			e.printStackTrace();
		}
		
		finally
		{
			try 
			{
				connection.close();
			} 
			catch (SQLException e)
			{
				
				e.printStackTrace();
			}
		}
		return null;
	}
	
	public static int getNumRows(ResultSet rs) 
	{
	    int result=0;
	    try {
			if(rs.last())
			{
			 result=rs.getRow();
			 rs.beforeFirst(); //指针回滚
			}
		}
	    catch (SQLException e) 
	    {
			
			e.printStackTrace();
		}
	    return result;
	}
	
	
}