package achievo.dtree.dbmanager;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBManager {
	private Connection conn = null;
	private ResultSet rst = null;
	private Statement sta = null;
	public Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/dtree", "root", "root");
			sta = conn.createStatement();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
	public ResultSet getResultSet(String sql) {
		this.getConnection();
		try {
			rst = sta.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rst;
	}
	public void close() {
		try {
			rst.close();
			sta.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
//	public static void main(String args[]) {
//		DBManager db = new DBManager();
//		ResultSet rs = null;
//		try {
//			rs = db.getResultSet("select * from student");
//			System.out.println();
//			while(rs.next()) {
//				System.out.println(rs.getString("sname"));
//			}
//		} catch (SQLException e) {
//			e.printStackTrace();
//		}
//		System.out.println();
//		
//	}
}