java connect连接问题
以下代码中当执行conn = DriverManager.getConnection(connurl, user, password); 语句时总是不能正确执行。具体表现为在网页中显示 "No success connect database ",不知何缘故?如何解决。
import javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;
public class SqlConn extends HttpServlet
{
private String connurl;
private String user;
private String password;
private String sql;
public void init() throws ServletException
{
connurl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=pubs ";
user = "sa ";
password = "1234 ";
try
{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
}
catch(ClassNotFoundException ce)
{
throw new UnavailableException( "加载数据库驱动失败! ");
}
}
public void doGet(HttpServletRequest req,HttpServletResponse resp)
throws ServletException,IOException
{
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
PrintWriter out=resp.getWriter();
sql = "select * from testTable ";
try {
conn = DriverManager.getConnection(connurl, user, password); //获得连接
stmt = conn.createStatement(); //获得执行SQL语言的容器
rs = stmt.executeQuery(sql); //获得结果集
while (rs.next()) {
out.println(rs.getString(1));}
}
catch(SQLException e)
{
out.println( "No success connect database ");
}
}
}
[解决办法]
sql server需要打sp4补丁
[解决办法]
最大可能是sqlserver没打补丁,然后是驱动包匹配问题
[解决办法]
打补丁~