错误提示:javax.servlet.ServletException: No suitable driver
\Microsoft SQL Server 2000 Driver for JDBC\lib 文件夹里的三个jar包
放到lib文件夹下了。
这个是怎么回事啊。package school.action;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;import school.form.LoginForm;public class LoginAction extends Action {
static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=COMPUTER-XIA"; static String dbuser = "huang"; static String dbpwd = "huang"; public void DBTest() throws Exception {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
} public static Connection getConnection() throws Exception {
return DriverManager.getConnection(dbUrl,dbuser,dbpwd);
} public void closeConnection(Connection con) {
} public void closePrepStmt(PreparedStatement prepStmt) {
}/////////////////////////////////////////////////////////////////
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
throws Exception
{
Connection conn = null;
conn=getConnection();
Statement state=conn.createStatement();
String sql = "select * from user where name=?";
ResultSet rs=state.executeQuery(sql);
/////////////
String test = ((LoginForm)form).getName();
request.setAttribute("name", test);
System.out.print( rs);
if(rs.getInt("jibie")==1)
{
return mapping.findForward("success");
}else
{
return mapping.findForward("success1");
}
}
}
\Microsoft SQL Server 2000 Driver for JDBC\lib 文件夹里的三个jar包
放到lib文件夹下了。
这个是怎么回事啊。package school.action;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;import school.form.LoginForm;public class LoginAction extends Action {
static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=COMPUTER-XIA"; static String dbuser = "huang"; static String dbpwd = "huang"; public void DBTest() throws Exception {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
} public static Connection getConnection() throws Exception {
return DriverManager.getConnection(dbUrl,dbuser,dbpwd);
} public void closeConnection(Connection con) {
} public void closePrepStmt(PreparedStatement prepStmt) {
}/////////////////////////////////////////////////////////////////
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
throws Exception
{
Connection conn = null;
conn=getConnection();
Statement state=conn.createStatement();
String sql = "select * from user where name=?";
ResultSet rs=state.executeQuery(sql);
/////////////
String test = ((LoginForm)form).getName();
request.setAttribute("name", test);
System.out.print( rs);
if(rs.getInt("jibie")==1)
{
return mapping.findForward("success");
}else
{
return mapping.findForward("success1");
}
}
}
你把包放到common/lib下面就可以了。你可以试试。
要不谁提供一个例子给我。谢谢了。