src/com/bean/BankBean.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 BankBean {

	private List list;
	private ResultSet rs = null;
	private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	private String date2=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
	
	////
	public int addIo(String type,String title,String money,String intero,String adder ){
		String sql = "insert into io (type,title,money,intero,addtime,adder) values ('"+type+"','"+title+"','"+money+"','"+intero+"','"+date+"','"+adder+"')";
		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 upIo(String id,String type,String title,String money,String intero){
		String sql = "update io set type='"+type+"',title='"+title+"',money='"+money+"',intero='"+intero+"' 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 List getAllIo(String sql){
		//String sql = "select * from io where adder='"+adder+"' order by id desc ";
		DBO dbo = new DBO();