andriod下通过SQL判断用户是否存在

Question

setJudgeUser();

Answer 1

报错信息是啥？ 楼主贴出报错的exception来呀

Answer 2

是 dbUtil.JudgeUserInfo(cTechNum.getText().toString(), cAnpassword.getText().toString(), "SL");  这句有问题；
下面是dbUtil的代码
package com.example.kanglesystem;import java.sql.Connection;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;public class DBUtil {
    private ArrayList<String> arrayList = new ArrayList<String>();  
    private ArrayList<String> brrayList = new ArrayList<String>();  
    private ArrayList<String> crrayList = new ArrayList<String>();  
    private HttpConnSoap Soap = new HttpConnSoap();  
    
    public static Connection getConnection() {  
        Connection con = null;  
        try {  
            //Class.forName("org.gjt.mm.mysql.Driver");   
            //con=DriverManager.getConnection("jdbc:sqlserver://192.168.0.106:3306/test?useUnicode=true&characterEncoding=UTF-8","root","initial");                
        } catch (Exception e) {  
            //e.printStackTrace();   
        }  
        return con;  
    }  
  
    /** 
     * 判断传人的用户信息是否存在 
     *  
     * @return 
     */  
    public void JudgeUserInfo(String TechNum, String Anpassword, String CmpCode) {  
  
        arrayList.clear();  
        brrayList.clear();  
          
        arrayList.add("TechNum");  
        arrayList.add("Anpassword"); 
        arrayList.add("CmpCode"); 
        brrayList.add(TechNum);  
        brrayList.add(Anpassword); 
        brrayList.add(CmpCode);
          
        Soap.GetWebServre("JudgeUserInfo", arrayList, brrayList).getClass();  
    }  
      
}

Answer 3

Android 是不可以通过JDBC直接调用远程数据库的。需要通过web服务器中转。

Answer 4

是的，我上面dbutil中调用了类Soap的，下面是Soap的代码；请大家帮忙检查下，谢谢
public class HttpConnSoap {
public ArrayList<String> GetWebServre(String methodName, ArrayList<String> Parameters, ArrayList<String> ParValues) {  
        ArrayList<String> Values = new ArrayList<String>();  
          
        //ServerUrl是指webservice的url   
       //10.0.2.2是让android模拟器访问本地（PC）服务器，不能写成127.0.0.1   
        //11125是指端口号，即挂载到IIS上的时候开启的端口   
        //Service1.asmx是指提供服务的页面   
        //String ServerUrl = "http://10.0.2.2:11125/Service1.asmx";  
        String ServerUrl = "http://10.10.0.21/Kanglesystem/KlService.asmx";  
          
        //String soapAction="http://tempuri.org/LongUserId1";   
        String soapAction = "http://tempuri.org/" + methodName;  
        //String data = "";   
        String soap = "<?xml version=\"1.0\" encoding=\"utf-8\"?>"  
                + "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">"  
                + "<soap:Body />";  
        String tps, vps, ts;  
        String mreakString = "";  
  
        mreakString = "<" + methodName + " xmlns=\"http://tempuri.org/\">";  
        for (int i = 0; i < Parameters.size(); i++) {  
            tps = Parameters.get(i).toString();  
            //设置该方法的参数为.net webService中的参数名称   
            vps = ParValues.get(i).toString();  
            ts = "<" + tps + ">" + vps + "</" + tps + ">";  
            mreakString = mreakString + ts;  
        }  
        mreakString = mreakString + "</" + methodName + ">";  
        /* 
        +"<HelloWorld xmlns=\"http://tempuri.org/\">" 
        +"<x>string11661</x>" 
        +"<SF1>string111</SF1>" 
        + "</HelloWorld>" 
        */  
        String soap2 = "</soap:Envelope>";  
        String requestData = soap + mreakString + soap2;  
        //System.out.println(requestData);   
  
        try {  
            URL url = new URL(ServerUrl);  
            HttpURLConnection con = (HttpURLConnection) url.openConnection();  
            byte[] bytes = requestData.getBytes("utf-8");  
            con.setDoInput(true);  
            con.setDoOutput(true);  
            con.setUseCaches(false);  
            con.setConnectTimeout(6000);// 设置超时时间   
            con.setRequestMethod("POST");  
            con.setRequestProperty("Content-Type", "text/xml;charset=utf-8");  
            con.setRequestProperty("SOAPAction", soapAction);  
            con.setRequestProperty("Content-Length", "" + bytes.length);  
            OutputStream outStream = con.getOutputStream();  
            outStream.write(bytes);  
            outStream.flush();  
            outStream.close();  
            InputStream inStream = con.getInputStream();  
  
            Values = inputStreamtovaluelist(inStream, methodName);    
            return Values;  
  
        } catch (Exception e) {  
            //System.out.print("2221");  
            return null;  
        } 
}
        
        public ArrayList<String> inputStreamtovaluelist(InputStream in, String MonthsName) throws IOException {  
            StringBuffer out = new StringBuffer();  
            String s1 = "";  
            byte[] b = new byte[4096];  
            ArrayList<String> Values = new ArrayList<String>();  
            Values.clear();  
      
            for (int n; (n = in.read(b)) != -1;) {  
                s1 = new String(b, 0, n);  
                out.append(s1);  
            }  
      
            System.out.println(out);  
            //String[] s13 = s1.split("><");  
            String[] s13 = out.toString().split("><");
            String ifString = MonthsName + "Result";  
            String TS = "";  
            String vs = "";  
      
            Boolean getValueBoolean = false;  
            for (int i = 0; i < s13.length; i++) {  
                TS = s13[i];  
                System.out.println(TS);  
                int j, k, l;  
                j = TS.indexOf(ifString);  
                k = TS.lastIndexOf(ifString);  
      
                if (j >= 0) {  
                    System.out.println(j);  
                    if (getValueBoolean == false) {  
                        getValueBoolean = true;  
                    } else {  
      
                    }  
      
                    if ((j >= 0) && (k > j)) {  
                        System.out.println("FFF" + TS.lastIndexOf("/" + ifString));  
                        //System.out.println(TS);   
                        l = ifString.length() + 1;  
                        vs = TS.substring(j + l, k - 2);  
                        //System.out.println("fff"+vs);   
                        Values.add(vs);  
                        System.out.println("退出" + vs);  
                        getValueBoolean = false;  
                        return Values;  
                    }  
      
                }  
                if (TS.lastIndexOf("/" + ifString) >= 0) {  
                    getValueBoolean = false;  
                    return Values;  
                }  
                if ((getValueBoolean) && (TS.lastIndexOf("/" + ifString) < 0) && (j < 0)) {  
                    k = TS.length();  
                    //System.out.println(TS);   
                    vs = TS.substring(7, k - 8);  
                    //System.out.println("f"+vs);   
                    Values.add(vs);  
                }        
            }  
      
            return Values;  
        }  }