java监控jdbcconnect,Java开发网jdbc的问题（Connection不能实例化，不能建立连接）...

Posted by:sumind206xy

Posted on:2006-08-24 10:46

最近做了个小项目&＃xff0c;在本pc上测试一切正常&＃xff0c;于是就传到服务器上&＃xff0c;谁知道一上服务器&＃xff0c;我那个连接数据库的javabean就抛出空指针异常&＃xff0c;最后发现是 stmt(stetament )的问题&＃xff0c;没办法&＃xff0c;只好写了个测试页面试试连接&＃xff0c;结果一执行到Connection con &＃61; DriverManager.getConnection(url, username,password);就抛出异常&＃xff0c;各位帮忙看下是什么原因&＃xff1f;是什么情况才会导致这个原因&＃xff1f;

testcon.jsp&＃xff1a;

String basePath &＃61; request.getScheme() &＃43; "://" &＃43; request.getServerName() &＃43; ":" &＃43;request.getServerPort()&＃43; path &＃43; "/";

%>

Statement stmt;

ResultSet rst;

String classforname &＃61; "com.microsoft.jdbc.sqlserver.SQLServerDriver";

String username &＃61; "sa";

String password &＃61; "sa";

String url &＃61; "jdbc:microsoft:sqlserver://192.168.1.27:1433;DatabaseName&＃61;project_news";

%>

Class.forName(classforname).newInstance();

out.print("111");

Connection con &＃61; DriverManager.getConnection(url, username,password);

out.print("222");

stmt &＃61; con.createStatement();

out.print("333");

rst &＃61; stmt.executeQuery("select * from project_baseinfo");

out.print("444");

} catch (Exception e) {

e.printStackTrace();

out.print("555");

}

%>

while (rst.next()) {

out.print("ok");

}

}catch (Exception e) {

out.print("666");

}

%>

This is my JSP page.

打印结果&＃xff1a;111 555 666 this is my JSP page