picturebean.java

j2ee做的电子相册网站

package userpicture;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.*;
import java.io.*;
import javax.servlet.http.HttpServletRequest;
import javax.sql.*;
import java.util.Date;
import java.util.SimpleTimeZone;
import java.text.SimpleDateFormat;


public class pictureBean {
	String id;
	String filename;
	String dir;
	String type;
	public String getFilename() {
		return filename;
	}
	public void setFilename(String filename) {
		this.filename = filename;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	
	public String getDir() {
		return dir;
	}
	public void setDir(String dir) {
		this.dir = dir;
	}
	public String getType() {
		return type;
	}
	public void setType(String type) {
		this.type = type;
	}
	
	public void upload()
	{
		try {
			System.out.println("insert dir:"+this.dir);
			SimpleDateFormat df = new SimpleDateFormat("yy-MM-dd");//设置日期格式
			Class.forName("com.mysql.jdbc.Driver");
			Connection c = DriverManager
					.getConnection("jdbc:mysql://localhost/myphone?user=root&password=123456"); // 连接mysql数据库
			Statement s = c.createStatement();

			String sql="insert into picture values('"+this.id+"','"+this.filename+"','"+this.dir+"','"
						+this.type+"','"+df.format(new Date())+"')"; 
			System.out.println(sql);
			s.executeUpdate(sql);
			s.close();
			
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	
	

}