//String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String connUrl = "jdbc:sqlserver://localhost;DatabaseName=LMSDB;integratedSecurity=true;";
//String user="sa";
//String password="";
//Class.forName(driverClass).newInstance();
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn= DriverManager.getConnection(connUrl);
Statement stmt=conn.createStatement(); String sql="select * from Report.Category";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
first:<%=rs.getString(1)%>
second:<%=rs.getString(2)%>
<%}
rs.close();
stmt.close();
conn.close();各位看看是怎么回事,谢谢!
String connUrl = "jdbc:sqlserver://localhost;DatabaseName=LMSDB;integratedSecurity=true;";
//String user="sa";
//String password="";
//Class.forName(driverClass).newInstance();
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn= DriverManager.getConnection(connUrl);
Statement stmt=conn.createStatement(); String sql="select * from Report.Category";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
first:<%=rs.getString(1)%>
second:<%=rs.getString(2)%>
<%}
rs.close();
stmt.close();
conn.close();各位看看是怎么回事,谢谢!
15:
16: //Class.forName(driverClass).newInstance();
17: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
18: Connection conn= DriverManager.getConnection(connUrl);
19: Statement stmt=conn.createStatement();
20:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:407)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
18: Connection conn= DriverManager.getConnection(connUrl);
就这两行里有错,你试下哪行错了就知道了
String connUrl = "jdbc:sqlserver://localhost:1433;DatabaseName=LMSDB;integratedSecurity=true;";
还有要保证导入sqlserver的jar包啊
这里有篇文章,你看看,也许会有帮助。
http://www.szdydz.com/html/biancheng/20100622/88977.html