userdb.java

上传文件和图片

/*
 * 创建日期 2007-5-5
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package cn.com.yzb.action;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import cn.com.yzb.form.PhotoForm;




public class UserDB {
	public static boolean insert(PhotoForm u)// 添加
	{
		boolean ok = false;
		Connection con = null;
		PreparedStatement pst = null;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection("jdbc:odbc:yao", "sa", "");
			String sql = "insert into cp_def (photo,photo_name) values (?,?)";
			pst = con.prepareStatement(sql);
			pst.setBytes(1, u.getFile().getFileData());
			// 做文件缓存，文件名获取转移到Action
			pst.setString(2, u.getPhotoName());
			pst.executeUpdate();
			ok = true;
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				pst.close();
				con.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return ok;
	}
	public static List select()// 查询
	{
		List v = new ArrayList();
		Connection con = null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection("jdbc:odbc:yao","sa","");
			String sql = "select photo_name from cp_def ";
			pst = con.prepareStatement(sql);
			rs = pst.executeQuery();
			while (rs.next()) {
				PhotoForm u = new PhotoForm();
				u.setPhotoName(rs.getString(1));
				v.add(u);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				pst.close();
				con.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return v;
	}

}