关于连接Access数据库的问题——在线等！

[rainworm]

我用的是tomcat5.0，，，xp的操作系统，jbuild8.0
程序的主要功能是从数据库提取数据，然后放在rs里，现在问题是程序执行到
String sql = "select * from userinfo where name = " + name;
后就不在执行了，我在程序里用“aa”“bb”“cc”进行测试，结果只能打出
aa和bb，cc显示不出来，谁能帮我看看，谢谢了！！！
源程序如下：
package idmanage;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import idmanage.*;

public class queryid extends HttpServlet{
static final private String CONTENT_TYPE = "text/html; charset=GBK";
Connection conn=null;
ResultSet rs = null;
Statement statement = null;
public void init() throws ServletException {
}


public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
PrintWriter out=response.getWriter();
String name = request.getParameter("name").trim();
try {
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Test";
out.println("aa");
conn = java.sql.DriverManager.getConnection (url,"aaa","111");
statement=conn.createStatement();
out.println("bb");
String sql = "select * from userinfo where name = " + name;
rs=statement.executeQuery(sql);
out.println("cc");
if (rs.getString(1) == null) {
response.sendRedirect("error.jsp?id=1");
}
request.setAttribute("aa", rs.getString(1));
request.setAttribute("bb", rs.getString(2));
request.setAttribute("cc", rs.getString(3));
request.setAttribute("dd", rs.getString(4));
request.setAttribute("ee", rs.getString(5));
request.setAttribute("ff", rs.getString(6));
request.setAttribute("gg", rs.getString(7));
request.setAttribute("hh", rs.getString(8));
rs.close();
statement.close();
RequestDispatcher dispatcher = getServletContext().getRequestDispatcher("/queryid.jsp");
dispatcher.forward(request, response);
}
catch (Exception ex) { // 捕捉异常
ex.printStackTrace();
}
}
public void destroy() {
}
}

[haimingway]

cc显示不出来，肯定就是在之前发生异常罗

[rainworm]

String sql = "select * from userinfo where name = " + name;
rs=statement.executeQuery(sql);

我这语句没错啊，，，，郁闷啊！！！！！！！！

[xunyiren]

改成这样试一下:)
String sql = "select * from userinfo where name = '" + name+"'";

[bibiye]

conn = java.sql.DriverManager.getConnection (url,"aaa","111");
statement=conn.createStatement();

先测试一下这两句
应该是连接出的问题

[Frank_Xu]

直接連接ACCESS數據庫

將***.mdb直接放在站點的根目錄下

java.sql.Connection con=null;
java.sql.Statement stmt=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String szPath=application.getRealPath("/");
String DbUrl = "jdbc:odbc:DRIVER={MICROSOFT ACCESS DRIVER (*.mdb)};DSN='';DBQ=" + szPath + "xxx.mdb";
//System.out.println(DbUrl);
String user = "";
String password = "";
con=DriverManager.getConnection(DbUrl,user,password);
stmt = con.createStatement();
}

catch(SQLException e)
{
System.out.println("SQLException"+e.getMessage());
}

[haimingway]

如果产生了异常，把异常信息贴出来嘛

[pengfeitian]

gz

[Leemaasn]

報什麽異常呢？