java连接mysql出错_JAVA连接MYSQL出错

id书名

以下是从MYSQL数据库读取的数据:

id

书名

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/jspdev","root","root");

Statement stmt=con.createStatement();

ResultSet rst=stmt.executeQuery("select * from book");

while(rst.next())

{

out.println("

");

out.println("

“+rst.getString(1)+"");

out.println("

"+rst.getString(2)+"");

out.println("

")

}

rst.close();

stmt.close();

con.close();

%>

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 7 in the jsp file: /testMysql.jsp

Syntax error on token "/", delete this token

4: 以下是从MYSQL数据库读取的数据:

5:

6:

id书名

7:

8: Class.forName("org.gjt.mm.mysql.Driver").newInstance();

9: Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/jspdev","root","root");

10: Statement stmt=con.createStatement();

An error occurred at line: 7 in the jsp file: /testMysql.jsp

String literal is not properly closed by a double-quote

4: 以下是从MYSQL数据库读取的数据:

5:

6:

id书名

7:

8: Class.forName("org.gjt.mm.mysql.Driver").newInstance();

9: Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/jspdev","root","root");

10: Statement stmt=con.createStatement();

An error occurred at line: 7 in the jsp file: /testMysql.jsp

Syntax error, insert ")" to complete Expression

4: 以下是从MYSQL数据库读取的数据:

5:

6:

id书名

7:

8: Class.forName("org.gjt.mm.mysql.Driver").newInstance();

9: Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/jspdev","root","root");

10: Statement stmt=con.createStatement();

An error occurred at line: 16 in the jsp file: /testMysql.jsp

Syntax error, insert ";" to complete Statement

13: {

14: out.println("

");

15: out.println("

“+rst.getString(1)+"");

16: out.println("

"+rst.getString(2)+"");

17: out.println("

")

18: }

19: rst.close();

展开