<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
学生信息
<%
String driverClass = "com.mysql.jdbc.Driver";
String url = "jabc:mysql://localhost:3306/test";
Connection conn;
try{
Class.forName(driverClass);
conn = DriverManager.getConnection(url,"root","123");
System.out.println("0.0");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from student");
while(rs.next()){
%>
<%
}
}catch(Exception e){
e.printStackTrace();
}
%>
学号 | 姓名 | 性别 | 年龄 |
<%=rs.getInt(1) %> | <%=rs.getString(2) %> | <%=rs.getString(3) %> | <%=rs.getInt(4) %> |
链接数据库和操作数据库分开来写。查询语句放到try外面试试
按理说代码是没问题的,你看看你连接数据库的驱动导入了没有