求异常解决:java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDr
package com.database;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class Servlet1
*/
@WebServlet("/Servlet1")
public class Servlet1 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public Servlet1() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
*/
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String user="sa";
String password="saa";
Connection con= DriverManager.getConnection(url,user,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from fruit");
response.setContentType("text/html;charset=gbk");
PrintWriter out=response.getWriter();
out.println("<html><head><title>购买商品</title>");
out.println("<body bgcolor=yellow><h1 align=center>商品显示</h1>");
out.println("<form action=\"Servlet2\" method=\"post\">");
out.println("<table border='1' align='center'>");
out.println("<tr><th>商品名</th><th>商品单价</th><th>数量</th></tr>");
int i=0;
int j=0;
Double count=0.0;
while(rs.next()){
out.println("<tr>");
out.println("<td>"+rs.getString("name")+"</td>");
out.println("<td>"+rs.getDouble("price")+"</td>");
out.println("<td><input type='text'></td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</form>");
out.println("</body></html>");
}
catch(Exception e)
{
PrintWriter out=response.getWriter();
out.println(e);
}
}
}
关于sqljdbc.rar的包已经导入
http://localhost:8080/Servlet/Servlet1输入后出现异常:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver