conn_user.java

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

//与用户相关的数据库操作(建立数据源+查询+更新+数据源关闭)
package gongjiaochexitong.renyuan;

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

public class conn_User {
	
	DataSource dataSource= null;
	Connection conn=null;
	ResultSet rs=null;
	int result=0;	
	
	public conn_User(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();
			}
		}
		
	}

}