/*
 * 創建日期 2007-3-17
 *
 * TODO 要更改此生成的文件的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package edu.zgl.test;

import java.sql.*;
import java.util.*;
import java.io.*;
import sun.jdbc.odbc.JdbcOdbcDriver;

public class UserDB {	
	
	public static int getImgNo()
	{
		int lastNo=0;
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:zgl");			
			ps=con.prepareStatement("update img_no_def set last_no=last_no+1");
			ps.executeUpdate();
			
			ps=con.prepareStatement("select last_no from img_no_def");
			rs=ps.executeQuery();
			if(rs.next())
			{
				lastNo=rs.getInt(1);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try {
				rs.close();
				ps.close();
				con.close();
			} catch (Exception e) {				
				e.printStackTrace();
			}
		}	
		return lastNo;
	}
	public static List getList()
	{
		List v=new ArrayList();
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:zgl");
			String sql="select photo_name,photo from user_def";
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next())
			{
				User user=new User();				
				user.setName(rs.getString(1));
				user.setPhoto(rs.getBytes(2));		
				v.add(user);
			}			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try {
				rs.close();
				ps.close();
				con.close();
			} catch (Exception e) {				
				e.printStackTrace();
			}
		}	
		return v;
	}
	public static boolean insert(User user)
	{
		boolean ok=false;
		Connection con=null;
		PreparedStatement ps=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:zgl");
			String sql="insert into user_def(photo_name,photo) values(?,?)";
			ps=con.prepareStatement(sql);
			ps.setString(1,user.getName());
			ps.setBytes(2,user.getPhoto());
			ps.executeUpdate();
			ok=true;			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			try {
				ps.close();
				con.close();
			} catch (Exception e) {				
				e.printStackTrace();
			}
		}
		return ok;
	}
}