package beans;

import java.sql.*;

public class Condb{
	String jdbc="sun.jdbc.odbc.JdbcOdbcDriver";
	String dbname="jdbc:odbc:Music";
	ResultSet rs=null;
	Connection con=null;
	Statement stmt=null;
	public Condb(){
		try{
			Class.forName(jdbc);
		}catch(ClassNotFoundException e1){
			System.err.println(e1);
		}try{
			con=DriverManager.getConnection(dbname);
		}catch(SQLException e3){
			System.err.print(e3);
		}
	}public ResultSet executeQuery(String sql){
		try{
			stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
		}catch(SQLException e2){
			System.err.print(e2);
		}
			return rs;
	}public int excuteUpdate(String sql){
		int rt=0;
		try{
			stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rt=stmt.executeUpdate(sql);
		}catch(SQLException ex){
			System.err.print(ex);
		}
		return rt;
	}public void close(){
		try{
			if(con!=null)
				con.close();
		}catch(Exception e){
			System.out.print(e);
		}try{
			if(rs!=null)
				rs.close();
		}catch(Exception e){
			System.out.println(e);
		}
	}
}