android联接sql2008

android连接sql2008
为了解决与梧桐数据的交互，查找很多资料，有说可以有说不可以的，众说纷纷，其实可以连接。用android接连sql2008展示可以连接的！之前用了几种方法尝试连接，最后用socket
main.cml

Activity01.java
package com.android.client;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.net.Socket;

import com.yarin.android.Examples_08_04.R;

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class Activity01 extends Activity
{
private final String DEBUG_TAG = "Activity01";

private TextView mTextView=null;
private EditText nameEdit=null;
private Button save=null;
private Button select=null;
private EditText addressEdit=null;
private EditText phoneEdit=null;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.main);

save = (Button)findViewById(R.id.save);
select=(Button)findViewById(R.id.select);
mTextView=(TextView)findViewById(R.id.TextView01);
nameEdit=(EditText)findViewById(R.id.name);
addressEdit=(EditText)findViewById(R.id.address);
phoneEdit=(EditText)findViewById(R.id.phone);



//登陆
save.setOnClickListener(new OnClickListener()
{
public void onClick(View v)
{
Socket socket = null;
String name=nameEdit.getText().toString();
String address=addressEdit.getText().toString();
String phone=phoneEdit.getText().toString();
String message = name + "\n"+address+"\n"+phone+"\n"; 

try 
{ 
//创建Socket
socket = new Socket("192.168.0.7",54321); 
//向服务器发送消息
PrintWriter out = new PrintWriter( new BufferedWriter( new OutputStreamWriter(socket.getOutputStream())),true); 
out.println(message); 

//接收来自服务器的消息
BufferedReader br = new BufferedReader(new InputStreamReader(socket.getInputStream())); 
String msg = br.readLine(); 

if ( msg != null )
{
mTextView.setText(msg);
}
else
{
mTextView.setText("数据错误!");
}
//关闭流
out.close();
br.close();
//关闭Socket
socket.close(); 
}
catch (Exception e) 
{
// TODO: handle exception
Log.e(DEBUG_TAG, e.toString());
}
}
});
select.setOnClickListener(new OnClickListener()
{
public void onClick(View v){}
});
} 
}
服务端：
主类：Server.java
驱动包：sqljdbc4.jar支持1.6以上import java.sql.*;public class ConSQL{        Statement stmt;         Connection con;        public void ConSQl(){                  String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";//SQL数据库引擎                  String connectDB="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Mydb";//数据源                  try                  {                   Class.forName(JDriver);//加载数据库引擎，返回给定字符串名的类                  }catch(ClassNotFoundException e)                  {                   e.printStackTrace();                                     System.out.println("加载数据库引擎失败");                   System.exit(0);                  }                       System.out.println("加载驱动成功");                                                    try                  {                   String user="sa";                   String password="hello2010";                   con=DriverManager.getConnection(connectDB,user,password);//连接数据库对象                   System.out.println("连接数据库成功");                                                        }catch(SQLException e){                          e.printStackTrace();                                                     System.exit(0);                  }        }        /****         * 查询*/        public void selete(){                        try {                                stmt=(Statement) con.createStatement();//创建SQL命令对象                      String sql="select * from order";//查询order表语句                    ResultSet rs=stmt.executeQuery(sql);//执行查询                    StringBuilder str=new StringBuilder();                    while(rs.next()){                     str.append(rs.getString(1)+"\n");                     }//                    mSetText(str.toString());                                    rs.close();                        stmt.close();                    con.close();                                     } catch (Exception e) {                         e.printStackTrace();                 }        }        /**         * 注入信息         * fhwd:发货网点，shwd:收货网点，ydh:运单号，kh：卡号，         * dshk:代收货款,fhname:发货人,fhphone:发货电话，shname:收货人，shphone:收货电话         * yf:运费；yhf:运货费，hwname：货物名称，bz：包装件，bs:保值，hdan:回单标记*/        public void insert(String fhwd,String shwd,String ydh,String kh,String dshk,String fhname,String fhphone,String shname,Number shphone                        ,String yf,String yhf,String hwname,String bz,String num,String bs,int hdan){                                String sql="INSERT INTO order VALUES(fhwd,shwd,ydh,kh,dshk,fhname,fhphone,shname,shphone,yf,yhf,hwname,bz,num,bs,hdan)";                try {                                        stmt.executeUpdate(sql);                } catch (SQLException e) {                        System.out.println("数据库注入失败！");                        e.printStackTrace();                }        }        public void insert(String name) {                // TODO Auto-generated method stub                                try {                        System.out.println("name:"+name);                        stmt.executeUpdate(name);                } catch (SQLException e) {                        System.out.println("数据库注入失败！");                        e.printStackTrace();                }                        }}