sumind206xy
发贴: 4
积分: 0
|
于 2006-08-24 10:46
最近做了个小项目,在本pc上测试一切正常,于是就传到服务器上,谁知道一上服务器,我那个连接数据库的javabean就抛出空指针异常,最后发现是 stmt(stetament )的问题,没办法,只好写了个测试页面试试连接,结果一执行到Connection con = DriverManager.getConnection(url, username,password);就抛出异常,各位帮忙看下是什么原因?是什么情况才会导致这个原因?
testcon.jsp:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312"%> <%String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" +request.getServerPort()+ path + "/"; %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>">
<title>My JSP 'MyJsp.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0">
<!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <%! Statement stmt;
ResultSet rst;
String classforname = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String username = "sa";
String password = "sa";
String url = "jdbc:microsoft:sqlserver://192.168.1.27:1433;DatabaseName=project_news";
%> <%try { Class.forName(classforname).newInstance(); out.print("111"); Connection con = DriverManager.getConnection(url, username,password); out.print("222"); stmt = con.createStatement(); out.print("333"); rst = stmt.executeQuery("select * from project_baseinfo"); out.print("444"); } catch (Exception e) { e.printStackTrace(); out.print("555"); } %> <%try { while (rst.next()) { out.print("ok"); } }catch (Exception e) { out.print("666"); } %>
<body> This is my JSP page. <br> </body> </html>
打印结果:111 555 666 this is my JSP page
|