database.java

一个用java语言编写的基于数据库的系统

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

import javax.swing.JOptionPane;
import javax.swing.JTable;
public class DataBase {
	private JTable table=new JTable();
	private ResultSetMetaData rsMetaData;
	private Connection connection;
	private Statement statement;
	private ResultSet resultSet;
	public DataBase(){
		try{
    String drive="sun.jdbc.odbc.JdbcOdbcDriver";
    Class.forName(drive);
     connection = DriverManager.getConnection
      ("jdbc:odbc:BusManage");
       statement = connection.createStatement();
		}
		catch(Exception ex){
			System.out.println("连接数据库失败!");
		}
	}
	//判断用户是否为管理员
	public boolean isLogin(String UserName,String PassWord){
		boolean flag =true;
		try{
			   PreparedStatement sql=connection.prepareStatement("select * from T_User where UserID=? AND PassWord=?");
			   sql.setString(1,	UserName);
			   sql.setString(2, PassWord);
			   resultSet=sql.executeQuery();
			   if(resultSet.next()) flag=true;
			   else flag=false;
			   resultSet.close();
		}catch(Exception e){
			flag=false;
		}
		return flag;
	}
	public String query(String busNumber){
		String sitePass="";
		  try{
			   statement=connection.createStatement();
			   String sql="select * from T_RouteInfor where BusNumber='"+busNumber+"'";
               resultSet=statement.executeQuery(sql);
			   while(resultSet.next()){
			  	    sitePass=resultSet.getString("PassSite");
	   		   }
	     }
		   catch(Exception e){
			  
	   }
	   return sitePass;
    }
    public String query1(String Pass){
			String a="";
			try
			{
				statement=connection.createStatement();
				String sql1="SELECT DISTINCT T_SiteInfor.BusNumber, T_SiteInfor.SiteName FROM T_SiteInfor where SiteName='"+Pass+"'";
				resultSet=statement.executeQuery(sql1);
				while(resultSet.next()){
			  	    a+=resultSet.getString("BusNumber")+" ";
	   		           }
					}
			catch(Exception ex){

			}
		return a;
}
    
}