我的SQLServer2000没有问题,用JAVA程序也能正常操作,可当我用JavaBean连接的时候却不行,每次到connection的时候就不继续运行了,下面是我的部分代码,只是为了验证用的,当Str = "wrong"这句放在(1)(见注释)之前时能返回right,放在(1)之后就返回wrong,可是这些语句都是从我的连接成功的JAVA代码里复制过来的,应该没问题的,各位大侠帮忙看看吧,这个对我太重要了,小弟分不多,帮我解决了我额外再送50分。
package test;
import java.sql.*;public class myTest
{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test";
String userName = "sa";
String userPwd = "123";
Connection dbConn;
String Str = "wrong";//用于验证返回值; public String getStr()
{
try{
dbConn = null;
Class.forName(driverName);
/*Str = "right";放在这里,就能正常返回*/
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);//就是这句(1)
Str = "right";//此处给str重新赋值;
}
catch (Exception e) {
e.printStackTrace();
}
return Str;//如果正确则返回right,否则返回wrong
}
}
——以下是我的jsp,只用来显示结果——
<jsp:useBean id = "myBean" scope = "application" class = "n.myTest" />
<%
out.println(myBean.getStr());
%>
package test;
import java.sql.*;public class myTest
{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test";
String userName = "sa";
String userPwd = "123";
Connection dbConn;
String Str = "wrong";//用于验证返回值; public String getStr()
{
try{
dbConn = null;
Class.forName(driverName);
/*Str = "right";放在这里,就能正常返回*/
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);//就是这句(1)
Str = "right";//此处给str重新赋值;
}
catch (Exception e) {
e.printStackTrace();
}
return Str;//如果正确则返回right,否则返回wrong
}
}
——以下是我的jsp,只用来显示结果——
<jsp:useBean id = "myBean" scope = "application" class = "n.myTest" />
<%
out.println(myBean.getStr());
%>
.......................dbURL, userName, userPwd确保这些都正确??还有将三个JDBC的包导入环境中了??
2006-12-02 11:51:01 StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain:
[org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
2006-12-02 11:51:08 StandardContext[/jsp-examples]ContextListener: contextInitialized()
2006-12-02 11:51:08 StandardContext[/jsp-examples]SessionListener: contextInitialized()
2006-12-02 11:51:08 StandardContext[/servlets-examples]ContextListener: contextInitialized()
2006-12-02 11:51:08 StandardContext[/servlets-examples]SessionListener: contextInitialized()
.......................dbURL, userName, userPwd确保这些都正确??还有将三个JDBC的包导入环境中了??
————————————————————————————————————
这些绝对没问题,我用JAVA程序已经连接成功了,只是放在BEAN里就不行。
myTest aa = new myTest();
out.println(myBean.getStr()); //试试
%>