<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = java.sql.DriverManager("jdbc:microsoft:sqlserver://127.0.0.1:8181;DtatbaseName=red","sa","sunwei");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test;");
while(rs.next()){
out.println(rs.getString("name"));
out.println(rs.getString("userid"));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
%>帮我看看错在哪了?
<%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection conn = java.sql.DriverManager("jdbc:microsoft:sqlserver://127.0.0.1:8181;DtatbaseName=red","sa","sunwei");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test;");
while(rs.next()){
out.println(rs.getString("name"));
out.println(rs.getString("userid"));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
%>帮我看看错在哪了?
Connection conn = java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:8181;DtatbaseName=red","sa","sunwei");
显示:
org.apache.jasper.JasperException: Unable to compile class for JSPGenerated servlet error:
Syntax error on token ";", import expected after this tokenAn error occurred at line: 2 in the jsp file: /test.jsp
Generated servlet error:
java.sql cannot be resolved to a type
改为
ResultSet rs = stmt.executeQuery("select * from test");