我用jdbc连接的数据库,代码如下:Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String url="jdbc:jtds:sqlserver://192.168.10.148:1433/bbs;USER=sa;PASSWORD="; Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String sql="select * from bbstitle";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%> 可是运行总是出错:
The server encountered an internal error () that prevented it from fulfilling this request.
错误指示在Connection conn= DriverManager.getConnection(url);
我的classpath环境变量设置为:
.;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\lib\dt.jar;%TOMCAT_HOME%\common\lib\servlet-api.jar;%JAVA_HOME%\lib\msbase.jar;%JAVA_HOME%\lib\mssqlserver.jar;%JAVA_HOME%\lib\msutil.jar;%TOMCAT_HOME%\common\lib\jtds-1.1.jar;
path设置为:
%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
java_home:
C:\j2sdk1.4.2_04
TOMCAT_HOME:
D:\Program Files\Apache Software Foundation\Tomcat 5.5谁能帮我呀
String url="jdbc:jtds:sqlserver://192.168.10.148:1433/bbs;USER=sa;PASSWORD="; Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String sql="select * from bbstitle";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%> 可是运行总是出错:
The server encountered an internal error () that prevented it from fulfilling this request.
错误指示在Connection conn= DriverManager.getConnection(url);
我的classpath环境变量设置为:
.;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\lib\dt.jar;%TOMCAT_HOME%\common\lib\servlet-api.jar;%JAVA_HOME%\lib\msbase.jar;%JAVA_HOME%\lib\mssqlserver.jar;%JAVA_HOME%\lib\msutil.jar;%TOMCAT_HOME%\common\lib\jtds-1.1.jar;
path设置为:
%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
java_home:
C:\j2sdk1.4.2_04
TOMCAT_HOME:
D:\Program Files\Apache Software Foundation\Tomcat 5.5谁能帮我呀
这样试试还有确认一下你的数据库两个字段的数据类型是什么型的
int型的应该用rs.getInt(),字符型的才用rs.getString()
也不对
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=;DatabaseName=mydb");