如何通过JBDC到Android应用程序连接到SQL Server

问题描述:

我曾尝试使用我的JTDS Android应用程序连接到SQL Server
但就是给登录错误。如果任何人能告诉我它的解决方案...
plzz家伙很迫切........

i have tried to connect my android app to sql server using jtds but is give login error. if any one could tell me it's solution... plzz guys it's urgent........

我有使用jtds1.2.7-JAR在我的libs文件夹

i have use jtds1.2.7-jar in my libs folder

我的code是.......

my code is .......

public class MainAct extends Activity{
EditText e;
Button bt;
ListView lv;
Connection connect;
SimpleAdapter sm;

public void declere(){
    e=(EditText)findViewById(R.id.et1);
    bt=(Button)findViewById(R.id.bt1);
    lv=(ListView)findViewById(R.id.list);
}

public void initilize(){
    declere();
    e.setText("SELECT TOP 10 * FROM FORM1");
    connect=CONN("sa","cbo@morc","KULDEEP","122.160.255.218:1433");
}
@SuppressLint("NewApi")
 private Connection CONN(String user,String pass,String db,String server){
     StrictMode.ThreadPolicy policy=new StrictMode.ThreadPolicy.Builder().permitAll().build();
     StrictMode.setThreadPolicy(policy);
     Connection conn=null;
     String connUrl=null;
     try{
     Class.forName("net.sourceforge.jtds.jdbc.Driver");
     connUrl="jdbc:jtds:sqlserver://" + server + ";" + "databaseName=" + db + ";user=" + user + ";passward=" + pass + ";";
     conn=DriverManager.getConnection(connUrl);
     }catch(SQLException se){
         Log.e("ERROR", se.getMessage());
     }catch(ClassNotFoundException cl){
         Log.e("ERROR", cl.getMessage());
     }catch(Exception e){
         Log.e("ERROR", e.getMessage());
     }

     return conn;

    }

   public void querySQL(String COMMANDSQL){
       ResultSet rs;
       try{
       Statement statement=connect.createStatement();
       rs=statement.executeQuery(COMMANDSQL);
       List<Map<String,String>>data=null;
       data=new ArrayList<Map<String,String>>();

       while(rs.next()){
           Map<String,String>datanum=new HashMap<String,String>();
           datanum.put("a", rs.getString("NAME"));
           datanum.put("b", rs.getString("CITY"));
           data.add(datanum);
       }
       String [] from={"a","b"};
       int [] to={R.id.tv1,R.id.tv2};

       sm=new SimpleAdapter(this, data, R.layout.second, from, to);
       lv.setAdapter(sm);
       }catch(Exception e){
          Log.e("ERROR", e.getMessage()); 
       }

   }
public void onCreate(Bundle b){
    super.onCreate(b);
    setContentView(R.layout.main);
    initilize();

    bt.setOnClickListener(new OnClickListener() {

        @Override
        public void onClick(View v) {
            // TODO Auto-generated method stub
            querySQL(e.getText().toString());


        }
    });
}

}

检查 passward 参数在连接URL。它应该是密码

Check your passward param in the connection URL. Should it be password?