petdiarydao.java

网上电子宠物系统

package com.zc.PetProject.DAO;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import com.zc.PetProject.DAO.Base.BaseDAO;
import com.zc.struts.form.PetDiaryForm;

public class PetDiaryDAO extends BaseDAO {

	Connection con=null;
	
	// 写日记的方法
	public boolean addPetDiary(PetDiaryForm diary) {
		
		String sql = "insert into PetDiary values("
				+ diary.getDiary_pet_id() + ",'" + diary.getDiary_date() + "','"
				+ diary.getDiary_title() + "','" + diary.getDiary_weather() + "','"
				+ diary.getDiary_context() + "'," + diary.getDiary_is_public() + ",'"
				+ diary.getDiary_last_modify() + "','" + diary.getDiary_author()
				+ "','" + diary.getDiary_author_email() + "')";
		try {
			con=this.getConnection();
			Statement st=con.createStatement();
			int n=st.executeUpdate(sql);
			if(n>0){
				return true;
			}else{
				return false;
			}
		} catch (SQLException e) {
			
			cloceConnection(con);
			e.printStackTrace();
		}finally{
			cloceConnection(con);
		}
		return false;
	}

}