conn_bus.java

来自「java做的 公交车查询系统....毕业设计」· Java 代码 · 共 63 行

//与公交车相关的数据库操作(建立数据源+查询+更新+数据源关闭)
package gongjiaochexitong.gongjiaoche;

import java.sql.*;
import javax.sql.DataSource;

public class conn_Bus {
	
	DataSource dataSource;      
	Connection conn=null;
	ResultSet rs=null;
	int result=0;
	
	public conn_Bus(DataSource dataSource) {
		
			this.dataSource = dataSource;
	}
		
    public ResultSet exeQuery(String query) throws Exception{
    			
		try{
			conn= dataSource.getConnection();
			Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(query);
		}
		catch(SQLException ex){
			ex.printStackTrace();			
		}		
		
		return rs;
	}
    
	public int exeUpdate(String update) throws Exception{		
		
		try{
			conn= dataSource.getConnection();
			Statement stmt=conn.createStatement();
			result=stmt.executeUpdate(update);
		}
		catch(SQLException ex){
			ex.printStackTrace();
		}		
		
		return result;
	}
	
	public void conn_Close() throws Exception{
		
		if(conn!=null){
			try{
				conn.close();
				conn=null;
			}
			catch(SQLException ex){
				ex.printStackTrace();
			}
		}
		
	}
	    

}