我写的JAVA程序能顺利连接数据库~可是JSP程序就不行!(不涉及数据库的JSP可以运行!)我的JSP环境是TOMCAT的!是不是应该设置什么呀?我的环境变量是这样的:.;C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\tools.jar;C:\Tomcat 4.1\common\lib\servlet.jar;C:\Tomcat 4.1\common\lib\tools.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;大家帮我~解决给分!
<html>
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%request.setCharacterEncoding("gb2312");%><head>
<title>计数器小程序</title>
</head>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<body><%!
String driver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url ="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=MyDB";
String user = "sa";
String password = "";
%><%
try
{
Class.forName(driver);
}
catch (Exception e)
{
out.print("11111111111");
}
%>
</body>
</html>
另外最好设置Java_Home变量