package ST_assign_package;

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

public class DatabaseCon {
    private static Connection c;

    private static  Connection getConnection()throws Exception{
        if (c==null) {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            c=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/<ur database name>", "root", "<ur password>");
            return c;
            
        } else {
            return c;
        }

    }

    public static ResultSet selectQue(String x)throws Exception
    {
        ResultSet r = getConnection().createStatement().executeQuery(x);
        return r;

    }

    public static void update(String s)throws Exception
    {
        getConnection().createStatement().executeUpdate(s);

    }
}