src/com/bean/TrainBean.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 TrainBean {
	private List list;
	private ResultSet rs;
	private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	
	////////////////////////////////////////////////////////车次
	//增加  车次管理 times 例如： 沈阳-北京 2510次 时间：xx点xx分发车 xx点xx分到达 软座  硬座 卧铺 票价
    //增加  车次管理 train  例如：id,train,num,stime,etime,soft,softprice,hard,hardprice,sleep,sleepprice,addtime
	public int addTrain(String train,String num,String stime,String etime,String sitetype,String price,String sl){
		String sql = "insert into train (train,num,stime,etime,sitetype,price,addtime,sl) " +
				"values('"+train+"','"+num+"','"+stime+"','"+etime+"','"+sitetype+"','"+price+"','"+date+"','"+sl+"')";
		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();
		}
	}
	// 修改
	public int upTrain(int id,String train,String num,String stime,String etime,String sitetype,String price,String sl){
		String sql = "update train set train='"+train+"',num='"+num+"',stime='"+stime+"',etime='"+etime+"',sitetype='"+sitetype+"'," +
				"price='"+price+"',sl='"+sl+"' 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();
		}
	}
	// 删除
	public int delTrain(int id){
		String sql = "delete from train where id='"+id+"'";
		DBO dbo = new DBO();