Android客户端，与服务器通信，一个服务器关于连接SQL的问题。

Big_big_Gu 2012-03-17 01:14:55

服务器端，我弄了个servelet,doGet方法实现如下：
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

request.setCharacterEncoding("gb2312");
String user = request.getParameter("user");
String password = request.getParameter("password");
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();

//if (JavaSQL.Search(user, password)) { if (user.equals("gmm")&&password.equals("123")) {
out.println("Y");
} else {
out.println("N");
}
out.flush();
out.close();

}

这样的话可以实现对客户端信息的返回，但是如果用红字标识的那段代码，并注释下面那段，Android模拟器显示无法连接服务器，蛋疼了。这是为神马呢。哪位英雄解释下...
JavaSQL.search()方法实现如下：
public class JavaSQL {
private static String driver="sun.jdbc.odbc.JdbcOdbcDriver";
private static String url = "jdbc:odbc:gmm";
//private static String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//private static String url="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=gmm";
private static String user_1="";
private static String password_1="";
String author, bookname, press, publicationdate;
public static boolean Search(String user,String password) {
Connection conn = null;
boolean searchflag=false;
try {
Class.forName(driver);

try {
conn = (Connection) DriverManager.getConnection(url, user_1, password_1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("数据库连接成功！");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
try {
Statement stmt = conn.createStatement();
// 创建SQL命令对象

ResultSet rs = stmt
.executeQuery("SELECT * FROM 用户表 where 帐号 = '"+user+"' and 密码='"+password+"'");// 查询BookInfo表

if (rs.next()) {
searchflag = true;

}
stmt.close();// 关闭命令对象连接
conn.close();// 关闭数据库连接
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return searchflag;
}

这个数据库查找我调试过了没有什么问题的。。。用的是SQL2000

...全文