trainmanager.java

是以JAVA所编程的简单的火车订票系统.

/*班级管理类实现数据库与界面的操作*/
package Manager;
import java.sql.*;
import java.util.Vector;
import database.DB;
import Manager.Train;
import javax.swing.*;
import true_false.*;

public class TrainManager
{
	Connection con=null;
	Statement stmt=null;
	public TrainManager()
	{
		
		try
		{
			DB db=new DB();
			con=db.getConnection();
			stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		}
		catch(Exception e)
		{
			e.printStackTrace();	
		}	
	}	
	public ResultSet QueryString(String strSql)
	{
		ResultSet rs=null;
		try
		{
			if (strSql.equals(""))
			{
				rs=stmt.executeQuery("select * from chapiao");
			}
			else
			{
				rs=stmt.executeQuery(strSql);
			}
			return(rs);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return(null);	
		}
	}
	public Vector QueryString()
	{
		Vector v=new Vector();
		ResultSet rs=null;
		try
		{
			rs=stmt.executeQuery("select * from chapiao");
			while(rs.next())
			{
				Train bj=new Train();
				bj.setBh(rs.getString(1));
				bj.setName(rs.getString(2));
				v.addElement(bj);	
			}
			return(v);
		}
		catch(Exception e)
		{
			e.printStackTrace();	
			return(null);
		}	
	}
	public void insertBj(String strSql) //throws Exception
	
	{
	try{
		//String strSql="insert into bj values('"+bj.getBh()+"','"+bj.getName()+"','"+bj.getSem()+"')";
		stmt.executeUpdate(strSql);	
		//return(true);
		JOptionPane.showMessageDialog(null,"定票成功");
		}
	catch(Exception e)
		{
		e.printStackTrace();
		JOptionPane.showMessageDialog(null,"定票失败");
		//return(false);
		}
	}
	public void updateBj(Train bj) throws Exception
	{
		String strSql="update bj set bj_name='"+bj.getName()+"',bj_sem='"+bj.getSem()+"' where bj_bh='"+bj.getBh()+"'";
		stmt.executeUpdate(strSql);
	}
	public void deleteBj(String strSql) //throws Exception
	{
		try{
		//String strSql="delete from bj where bj_bh='"+classnumber+"'";
		//stmt.executeUpdate(strSql);
		stmt.execute(strSql);
		}
		catch(Exception e)
		{
			//JOptionPane.showMessageDialog(null,"退 票 失 败");
			e.printStackTrace();
		}
	}
	
	public void deletetui(String strSql,String str) //throws Exception
	{
		ResultSet rs=null;
		//boolean bl=null;
		true_false tf =new true_false();
		try{
		rs=stmt.executeQuery(str);
		
			if(rs.isAfterLast()==false && rs.isBeforeFirst()==false)
			{
				tf.set_true_false(false);
			}
			else
			{
				stmt.execute(strSql);
				tf.set_true_false(true);
			}
			//return(bl);	
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,"数 据 库 错 误");
			e.printStackTrace();
			//return(false);
		}
	}
	
	
}