package mydbconsoleapp;
import java.sql.*;

public class db implements dbprocedure {
	//declaration
	private String classname;
	private String constring;
	private Connection con;
	public db() {
		classname="com.mysql.jdbc.Driver";
		constring="jdbc:mysql://192.168.1.181/intech?user=root&password=password";
	}

	@Override
	public void init() {
		try {
			Class.forName(classname);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	@Override
	public void opencon() {
		try {
			con=DriverManager.getConnection(constring);
			System.out.println("Connection to mysql error");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	@Override
	public void closecon() {
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}