src/com/bean/TraveBean.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.bean;

import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import com.util.Constant;
import com.util.DBO;

public class TraveBean {

	private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	private List list;
	private ResultSet rs = null;
	
	//add 
	public int addTrave(String title,String url,String address,String time,String price,String tel,String linkman,String content){
		String sql = "insert into trave (title,url,address,time,price,tel,linkman,content,addtime,flag) " +
				"values ('"+title+"','"+url+"','"+address+"','"+time+"','"+price+"','"+tel+"','"+linkman+"','"+content+"','"+date+"','普通线路')";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	
	//update 
	public int updateTrave(int id,String title,String url,String address,String time,String price,String tel,String linkman,String content){
		String sql = "update trave set title = '"+title+"',url='"+url+"',address='"+address+"'," +
				"time='"+time+"',price='"+price+"',tel='"+tel+"',linkman='"+linkman+"',content='"+content+"' where id = '"+id+"' ";
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}