import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class servlet extends HttpServlet {

    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

        doPost(request,response);
    }


    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        String sqlStatement=request.getParameter("sqlStatement");
        String sqlResult="";
        try{



            String dbURL="jdbc:mysql://172.16.4.148:3306/nicobas_db";
            String username="nicobas";
            String password="mysql";
            Connection connection=DriverManager.getConnection(dbURL,username,password);
            Statement statement=connection.createStatement();
            String sql = "insert into users(lastName,email,income,userId)" + "values('ramadan','sramadan@data',20000,7)";
            int num= statement.executeUpdate(sql);

            ResultSet rs = statement.executeQuery("select * from users");
                ResultSetMetaData md = rs.getMetaData();

                int cols = md.getColumnCount(); //How many fields
                for(int j = 1;j <= cols;j++)
                System.out.print(md.getColumnName(j) + "\t");

                while(rs.next())
                    {
                    for(int k = 1;k <= cols; k++)
                        {
                            System.out.print(rs.getString(k) + "\t");
                        }
                System.out.println();
                }

 rs.close();


           // sqlStatement=request.getParameter("commands");
           // sqlStatement=sqlStatement.trim();


          //  if(sqlStatement.length()>=6)




          //      String sqlType=sqlStatement.substring(0,6);
             //   if(sqlType.equalsIgnoreCase("select"))


                    ResultSet resultSet=statement.executeQuery(sqlStatement);
                                ResultSetMetaData metadata= resultSet.getMetaData();
            int colsp=metadata.getColumnCount();
            for(int col=1;col<=colsp;col++)
                {
                System.out.print(metadata.getColumnName(col)+"\t");
                }
            System.out.println();

                    while(resultSet.next())
                    {

                         System.out.println(resultSet.getString(1)+" "+resultSet.getString(2)+" "+resultSet.getString(3)+" "+resultSet.getString(4));
                    }
                }



        catch(Exception e)
  {
          System.out.println("sdfsdf");
  }
        }


    }