<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=咸宁学院学生信息管理系统";
String user ="lijian";//这里替换成你自已的数据库用户名
String password = "123";//这里替换成你自已的数据库用户密码
String sqlStr = "select * from 人员表";
out.print(sqlStr); try{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
out.print( "类实例化成功!" );
Connection con = DriverManager.getConnection(RL,user,password);
out.print( "创建连接对像成功!" ); Statement st = con.createStatement();
out.print( "创建Statement成功!" ); ResultSet rs = st.executeQuery( sqlStr );
out.print( "操作数据表成功!" );
out.print( "---how i love you--!\n" );
out.print("<table border=1>");
while(rs.next())
{
out.print("<tr>");
for(int i=1;i<=3;i++)
out.print("<td>"+rs.getString(i) + "</td>");
out.print("</tr>");
}
out.print("</table>");
out.print("query seccess!");
}
catch(Exception err){}
%>
</body>
</html>
--%>运行结果:
select * from 人员表
运行平台:netbeans 5.0
<%@ page import="java.sql.*"%>
<html>
<body>
<%
String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=咸宁学院学生信息管理系统";
String user ="lijian";//这里替换成你自已的数据库用户名
String password = "123";//这里替换成你自已的数据库用户密码
String sqlStr = "select * from 人员表";
out.print(sqlStr); try{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
out.print( "类实例化成功!" );
Connection con = DriverManager.getConnection(RL,user,password);
out.print( "创建连接对像成功!" ); Statement st = con.createStatement();
out.print( "创建Statement成功!" ); ResultSet rs = st.executeQuery( sqlStr );
out.print( "操作数据表成功!" );
out.print( "---how i love you--!\n" );
out.print("<table border=1>");
while(rs.next())
{
out.print("<tr>");
for(int i=1;i<=3;i++)
out.print("<td>"+rs.getString(i) + "</td>");
out.print("</tr>");
}
out.print("</table>");
out.print("query seccess!");
}
catch(Exception err){}
%>
</body>
</html>
--%>运行结果:
select * from 人员表
运行平台:netbeans 5.0
如果有些不是的话,就很有可能不能正常的顺利的执行!
都没有通过
找不到jdbc驱动,
拷贝3个jar文件到WEB-INF/libcatch(Exception err){}中把错误打印出来就看到具体的错误了
数据表库里有三个以上字段吗?
如果只有三个字段到 第三次 out.print("<td>"+rs.getString(i) + "</td>");
的时候会出错。
具体什么异常,可能会是 nullPointException吧
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.index_jsp._jspService(index_jsp.java:82)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
root cause java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:150)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:71)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.index_jsp._jspService(index_jsp.java:48)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.开发平台:
netbeans 5.0