slideshow.java

一个用jsp开发的网上测试系统

package shenyan.album;

import shenyan.album.*;
import java.io.*;
import java.sql.*;
import java.util.*;


public class SlideShow
{
	
	private ArrayList pictureBox = null;
	public SlideShow() {}
	public void setPicture(String albumName, String userName)
	{
			SqlConn2 database = null; //new SqlConn2();
			String sql = null;
			try {
				database = new SqlConn2();
				database.connectDB();
				pictureBox = new ArrayList();
				database.sqlStmt = database.conn.createStatement();
				sql = "select picID from picture where albumName = '" + albumName + "' and userName = '" 
					+ userName + "'";
				database.rs = database.sqlStmt.executeQuery(sql);
				while ( database.rs.next() )
				{
					pictureBox.add((String)database.rs.getString("picID"));
				}
			} catch ( Exception ex ) {
				System.out.println("Exception happen!");
				ex.printStackTrace();
			} finally {
				database.closeDBConn();
				
			}
			
	}
	public String getAddress(int pos)
	{
		if ( pictureBox == null || pictureBox.size() == 0 )
			return "default"; 
		return 	(String)pictureBox.get(pos); 
	}
	
	public int getSize()
	{
		if ( pictureBox == null )
			return 0;
		return pictureBox.size();
	}
	
	
}