我用的是XP,SQL装的是2000个人版,但不知为什么用JSP开发的程序访问不了数据库,是不是XP系统不支持JDBC和ODBC驱动程序访问SQL?我的访问数据库代码如下:请高手帮帮忙呀!我是初学者
<%!
public String codeToString(String str)
{
//处理中文字符串的函数
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%><%
String name=codeToString(request.getParameter("txtName"));
String sex=codeToString(request.getParameter("Sex"));
String job=codeToString(request.getParameter("Job"));
String address=codeToString(request.getParameter("Address"));
String phone=codeToString(request.getParameter("Phone"));
Class.forName("jdbc.driver_class_name");
Connection con = DriverManager.("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSPEmployess","sa","");
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into BaseInfo(Name,Sex,Job,Address,Phone)values('"+name+"','"+sex+"','"+job+"','"+address+"','"+phone+"')");
out.println("成功");
con.close();//response.sendRedirect("AddSucess.jsp");
stmt.close();
%>
<%!
public String codeToString(String str)
{
//处理中文字符串的函数
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%><%
String name=codeToString(request.getParameter("txtName"));
String sex=codeToString(request.getParameter("Sex"));
String job=codeToString(request.getParameter("Job"));
String address=codeToString(request.getParameter("Address"));
String phone=codeToString(request.getParameter("Phone"));
Class.forName("jdbc.driver_class_name");
Connection con = DriverManager.("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSPEmployess","sa","");
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into BaseInfo(Name,Sex,Job,Address,Phone)values('"+name+"','"+sex+"','"+job+"','"+address+"','"+phone+"')");
out.println("成功");
con.close();//response.sendRedirect("AddSucess.jsp");
stmt.close();
%>
检查你的SQL有没有打补丁,检查的方法是在查询分析器中运行:
select @@version
如果出来的版本号是8.00.760以下,则表明你未安装sp3或以上的补丁,要装上才能正常使用端口
http://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2ksp3.exe http://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2kasp3.exe
2、下载SQL Server 2000 Driver for JDBC Service Pack 3 http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/setup.exe