StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>HORRIBLE SOLUTIONS everywhere on internet. This is probably the simplest in the world.</p> <pre><code>PrintWriter out=response.getWriter(); out.print("&lt;html>"); out.print("&lt;body>"); out.print("&lt;form>"); out.print("&lt;textarea rows='5' columns='500' name='t1'>&lt;/textarea>"); //out.print("&lt;input type='text' name='t2'>"); //out.print("c&lt;input type='checkbox' value='c' name='t1'>"); //out.print("d&lt;input type='checkbox' value='d' name='t1'>"); out.print("&lt;input type='submit' value='execute' name='b1'>"); // out.print("&lt;input type='submit' value='show' name='b1'>"); //out.print("&lt;input type='submit' value='query' name='b1'>"); String a,c; a=request.getParameter("t1"); //b=request.getParameter("t2"); c=request.getParameter("b1"); if(c!=null) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/saransh","root",""); Statement st=con.createStatement(); if(a.startsWith("delete")) { out.print("<br>"); out.print("delete query execution..."); //st.executeUpdate("insert into student2(name,address) values('"+a+"',"+b+"')") ; st.executeUpdate(a); } else if(a.startsWith("select")) { out.print("<br>"); out.print("select query execution..."); ResultSet rs=st.executeQuery(a); ResultSetMetaData m1=rs.getMetaData(); out.print("<br>"); for(int i=1;i<=m1.getColumnCount();i++) {String x1=m1.getColumnLabel(i); out.print(" "+x1);} out.print("<br>");//name of label while(rs.next()) { String s0=rs.getString("Stu_roll"); String s1=rs.getString("name"); String s2=rs.getString("address"); out.print(s0+" "+s1+" "+s2); out.print("<br>"); }} else if(a.startsWith("insert")) { out.print("<br>"); out.print("insert query execution..."); st.executeUpdate(a); } else if(a.startsWith("drop")) { out.print("<br>"); out.print("drop query execution..."); st.executeUpdate(a); } } catch (Exception e) { out.print(e); // TODO: handle exception } } out.print("&lt;/form>"); out.print("&lt;/body>"); out.print("&lt;/html>"); </code></pre> <p>remove commented lines. only problem is that queries are case sensitive. You can figure out what string operation to use to make it 'ignore case'.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload