Cannot import java.sql. into localhost

Question

I am trying to make a visitor counter that uses an SQL database to store the number. I am writing JSP to do so. I am using an Apache httpd server that hosts my localhost. I am trying to store the number and will need an import to java.sql. I was told that this will do the import.

<html>
<% page import = "java.sql*." %>
<head>

Google Chrome's inspect gave me this.

Uncaught SyntaxError: Unexpected token <

I have tried putting <script> marks in the ends and putting it in the first line. Neither worked.

I don't understand, nor how this happened. Please help. Also, I'm quite a beginner for this, please forgive.

The syntax is incorrect, and 'import ... into localhost' is meaningless. — user207421, Jan 07 '18 at 09:39

Ori Marko · Answer 1 · 2018-01-07T09:51:59.363

1

If you want to import all classes in package you should add * sign after the dot. Because you can't import multiple packages in single statement:

  <%@  page import = "java.sql.*" %>

Also if you use only few classes inside package consider importing only them, for example:

<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.Connection" %>

edited Jan 07 '18 at 09:51

answered Jan 07 '18 at 09:40

Ori Marko

56,308
23
131
233

Maybe you have other lines with errors? can you should more of your code? – Ori Marko Jan 07 '18 at 10:27
But previous line effect this error. Please add previous lines – Ori Marko Jan 07 '18 at 10:34
Added the previous lines, why do they matter? – John Hao Jan 07 '18 at 10:43
How do you call your JSP? – Ori Marko Jan 07 '18 at 11:20
test.jsp is the name. – John Hao Jan 07 '18 at 12:59
I think you need apache tomcat, see https://stackoverflow.com/questions/30632/difference-between-the-apache-http-server-and-apache-tomcat – Ori Marko Jan 07 '18 at 13:02

Cannot import java.sql. into localhost

1 Answers1