androidsqlsever

首先声明我是个菜鸟，如有错误请大神指正。
android——-severlet——–sqlsever
首先建立一个javaweb工程，连接数据库（千万不要加载错驱动和jar包）MyEclipse中的代码如下：

public static void close(ResultSet rs,Statement st,Connection conn){        try {            if(rs!=null)                rs.close();            if(st!=null)                st.close();            if(conn!=null)                conn.close();        } catch (SQLException e) {            e.printStackTrace();        }    }    public static Connection getConnection(){        try { // 加载驱动程序            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");            return  DriverManager.getConnection(                    "jdbc:sqlserver://localhost:1433;DatabaseName=contact",                    UserName, Password);            //System.out.println("成功");        } catch (ClassNotFoundException e) {            System.out.println("加载驱动出错");        } catch (SQLException e) {            System.out.println("连接失败");        } catch (Exception e) {            System.out.println(e.getMessage());        }        return null;    }   

数据库连接完毕之后，就是完成了javaweb—-sqlsever，至于一些增删改查的功能代码就不贴了。接下来完成android——javaweb这里面就要用到上课学到的severlet，代码如下：

public class CoreServlet extends HttpServlet {    protected void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        doGet(request, response);    }    public void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        request.setCharacterEncoding("utf-8");        response.setContentType("text/html;charset=utf-8");        String action = request.getParameter("action");        PrintWriter out = response.getWriter();        if ("send".equals(action)) {            String m = request.getParameter("msg");            InsertTable ii = new InsertTable();            ii.insert(m);//简单执行数据的插入            System.out.print("send success");        } else {            out.print("no send");        }        out.close();    }}

利用tomca他，访问本地服务器。eclipse里面的代码如下：
布局文件十分简单，就一个EditText和一个button：

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    android:orientation="vertical"    tools:context=".MainActivity" >    <EditText         android:id="@+id/id_phone1"        android:layout_width="match_parent"        android:layout_height="100dp"        />    <Button        android:id="@+id/id_button"        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:text="确定" /></LinearLayout>

点击button就能够把数据添加到sqlsever中；MainActivity中的代码如下：

public class MainActivity extends Activity {    private Button myButton;    private EditText myEditText;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);        myButton = (Button) findViewById(R.id.id_button);        myEditText = (EditText) findViewById(R.id.id_phone1);        myButton.setOnClickListener(new OnClickListener() {            @Override            public void onClick(View v) {                String ss = myEditText.getText().toString();                // TODO Auto-generated method stub                sumbit(ss);                System.out.println(ss);                Toast.makeText(MainActivity.this, ss, Toast.LENGTH_LONG).show();            }        });    }    private void sumbit(String msg) {        // FinalHttp本身就是新开的线程，不需要在new Thread中，否则会出错        FinalHttp fh = new FinalHttp();        fh.configTimeout(10000);        fh.get("http://192.168.199.225:8080/messageTest/CoreServlet?action=send&msg="                + msg, new AjaxCallBack<String>() {            @Override            public void onFailure(Throwable t, int errorNo, String strMsg) {                Toast.makeText(MainActivity.this, "fail", 0).show();            }            @Override            public void onSuccess(String t) {                Toast.makeText(MainActivity.this, t, 0).show();            }            @Override            public void onStart() {                Toast.makeText(MainActivity.this, "begin", 0).show();            }        });    }}

最后测试结果如下：