fork download
copy 
  1. <%@ page import="java.io.*,java.util.*,java.sql.*"%>
  2. <%@ page import="javax.servlet.http.*,javax.servlet.*" %>
  3. <%@ taglib uri="http://j...content-available-to-author-only...n.com/jsp/jstl/core" prefix="c"%>
  4. <%@ taglib uri="http://j...content-available-to-author-only...n.com/jsp/jstl/sql" prefix="sql"%>
  5.  
  6. <html>
  7. <head>
  8. <title>INSERT Operation</title>
  9. </head>
  10. <body>
  11.  
  12. <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root"  password="MYsql2012"/>
  13. <sql:query dataSource="${snapshot}" var="result">
  14. INSERT INTO Employees VALUES (104, 2, 'Nuha', 'Ali');
  15. </sql:query>
  16.  
  17. <sql:query dataSource="${snapshot}" var="result">
  18. SELECT * from Employees;
  19. </sql:query>
  20.  
  21. <table border="1" width="100%">
  22. <tr>
  23.    <th>Emp ID</th>
  24.    <th>First Name</th>
  25.    <th>Last Name</th>
  26.    <th>Age</th>
  27. </tr>
  28. <c:forEach var="row" items="${result.rows}">
  29. <tr>
  30.    <td><c:out value="${row.id}"/></td>
  31.    <td><c:out value="${row.first}"/></td>
  32.    <td><c:out value="${row.last}"/></td>
  33.    <td><c:out value="${row.age}"/></td>
  34. </tr>
  35. </c:forEach>
  36. </table>
  37.  
  38. </body>
  39. </html>
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
Main.java:1: error: class, interface, or enum expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
^
Main.java:1: error: class, interface, or enum expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
 ^
Main.java:1: error: class, interface, or enum expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
         ^
Main.java:1: error: <identifier> expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
               ^
Main.java:1: error: <identifier> expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
                ^
Main.java:1: error: ';' expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
                                                  ^
Main.java:1: error: class, interface, or enum expected
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
                                                   ^
Main.java:2: error: class, interface, or enum expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
^
Main.java:2: error: class, interface, or enum expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
 ^
Main.java:2: error: class, interface, or enum expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
         ^
Main.java:2: error: <identifier> expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
               ^
Main.java:2: error: <identifier> expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
                ^
Main.java:2: error: ';' expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
                                                      ^
Main.java:2: error: class, interface, or enum expected
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
                                                        ^
Main.java:3: error: class, interface, or enum expected
<%@ taglib uri="http://j...content-available-to-author-only...n.com/jsp/jstl/core" prefix="c"%>
^
Main.java:3: error: class, interface, or enum expected
<%@ taglib uri="http://j...content-available-to-author-only...n.com/jsp/jstl/core" prefix="c"%>
 ^
Main.java:3: error: class, interface, or enum expected
<%@ taglib uri="http://j...content-available-to-author-only...n.com/jsp/jstl/core" prefix="c"%>
           ^
Main.java:4: error: class, interface, or enum expected
<%@ taglib uri="http://j...content-available-to-author-only...n.com/jsp/jstl/sql" prefix="sql"%>
           ^
Main.java:14: error: unclosed character literal
INSERT INTO Employees VALUES (104, 2, 'Nuha', 'Ali');
                                      ^
Main.java:14: error: unclosed character literal
INSERT INTO Employees VALUES (104, 2, 'Nuha', 'Ali');
                                           ^
Main.java:14: error: unclosed character literal
INSERT INTO Employees VALUES (104, 2, 'Nuha', 'Ali');
                                              ^
Main.java:14: error: unclosed character literal
INSERT INTO Employees VALUES (104, 2, 'Nuha', 'Ali');
                                                  ^
Main.java:15: error: class, interface, or enum expected
</sql:query>
^
Main.java:19: error: class, interface, or enum expected
</sql:query>
^
24 errors
stdout
copy 
Standard output is empty
https://ideone.com/OdffoG
language:
Java (HotSpot 12)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!