有错运行不了错误提示是The server encountered an internal error () that prevented it from fulfilling this request
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*;"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
Connection conn=null;
Statement statement=null;
ResultSet rs=null;
/* String sql=""; /
String str==null?"":str;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();/ 获取 驱动*/
String userName="root";
String password="123";
sql="SELECT*FROM books";
conn=DriverManager.getConnection("jdbc:mysql://loclhost:3306/test",userName,password);/* 连接数据库*/
statement=conn.createStatement();/* 通过connection数据库链接对象 创建一个statement对象数据库操作对象 */
rs=statement.executeQuery(sql);
out.print("
"+"id"); out.print(" |
"+"bookname"); out.print(" |
"+"bookwriter"); out.print(" |
"+"publisher"); out.print(" |
"+"type"); out.print(" |
"+"price"); out.print(" |
---|---|---|---|---|---|
"+rs.getString(1)+" | ");"+rs.getString(2)+" | ");"+rs.getString(3)+" | ");"+rs.getString(4)+" | ");"+rs.getString(5)+" | ");"+rs.getString(6)+" | "); */