Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433/***?user=sa&password=sa");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433/***?user=sa&password=sa");
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*; /**
* The simplest possible servlet.
*
* @author Haix Hsu
*/public class Hello extends HttpServlet
{
private final String DRIVER_NAME = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private final String DATABASE_URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";
private final String USER_NAME = "sa";
private final String USER_PASSWORD = "";
Connection dbConn; public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException, ServletException
{
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter(); out.println("<html>");
out.println("<head>"); String title = "你好,世界"; out.println("<title>" + title + "</title>");
out.println("</head>");
out.println("<body bgcolor=\"white\">");
out.println("<h1>" + title + "</h1>"); String strSQL = "SELECT CustomerID,CompanyName,ContactName FROM Customers"; try
{
Class.forName(DRIVER_NAME);
dbConn = DriverManager.getConnection(DATABASE_URL, USER_NAME, USER_PASSWORD);
Statement st = dbConn.createStatement();
ResultSet rs = st.executeQuery(strSQL);
while (rs.next())
{
out.print("<p>");
out.print(rs.getString("CustomerID"));
out.print(rs.getString("CompanyName"));
out.println(rs.getString("ContactName"));
out.println("</p>");
}
rs.close();
st.close();
dbConn.close(); }
catch(Exception e)
{
out.println("<p>e.getMessage:" + e.getMessage().toString() + "</p>");
out.println("<p>" + e.getLocalizedMessage().toString() +"</p>");
out.println("<p>e.getStackTrace:" + e.getStackTrace().toString() + "</p>");
} out.println("</body>");
out.println("</html>");
}
}
[email protected]需要装sqlserver2000 sp4
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=***;user=sa;password=");
可能是你驱动部分中sqlserver和jdbc的位置写反了