android 通过jdbc连接sql server 2008实现 增，删 改 查功能

昨天写了一篇帖子  帐号忘记了  所以今天在重新给大家写。我是利用android 通过jdbc连接sql server 2008实现 实现 增，删 改 查功能，事先得有一个驱动报 我用的是1.2.7.jar

我用模拟机 测试成功。真机上面还没测试。

好了 不说了  漂代码。

package com.androidmysqltest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

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 com.androidmysqltest1.R;

public class Androidsql extends Activity
{
 private Button m_Button ;
 private Connection m_con= null; 
    @Override
    public void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        m_Button = (Button)findViewById(R.id.button1);                 
        m_Button.setOnClickListener(new OnClickListener()
        {
   
   @Override
   public void onClick(View arg0)
   {    
     try {
      
      //insert("name","pwd","super");   //上传调用
      delete(8);                        //删除调用
      //update("ca","ca",1);            //修改调用
     } catch (Exception e)
     {
      // TODO Auto-generated catch block
      e.printStackTrace();
     } 
   }
  }) ;  
    }
    //添加
    public void insert(String a,String b,String c) throws Exception
   {   
         String sql = "INSERT INTO tb_User(UserName,UserPwd,UserRight) VALUES(?,?,?)" ;   
         PreparedStatement pstmt = null ;  
         Class.forName("net.sourceforge.jtds.jdbc.Driver");    //加载MYSQL JDBC驱动程序  
         Log.d("加载驱动", "成功");     
          m_con =(Connection) DriverManager.getConnection("jdbc:jtds:sqlserver://"+ "175.102.4.147" + ":1433/" + "数据名" ,"用户名", "密码");  
         try {   
             pstmt = m_con.prepareStatement(sql) ;   
             pstmt.setString(1,a);   
             pstmt.setString(2,b);   
             pstmt.setString(3,c);   
             pstmt.executeUpdate();   
             pstmt.close() ;   
         } catch (Exception e)
         {   
             // System.out.println(e) ;   
             throw new Exception("操作中出现错误！！！") ;   
         } finally
         {   
             m_con.close() ;   
         }   
     } 
   // 删除操作   
     public void delete(int id) throws Exception {   
         String sql = "DELETE FROM tb_InStore WHERE ISID=?" ;          
         PreparedStatement pstmt = null ;  
         Class.forName("net.sourceforge.jtds.jdbc.Driver");    //加载MYSQL JDBC驱动程序  
         Log.d("加载驱动", "成功");     
         m_con =(Connection) DriverManager.getConnection("jdbc:jtds:sqlserver://"+ "175.102.4.147" + ":1433/" + "数据名" ,"用户名", "密码");  
         try {   
             pstmt = m_con.prepareStatement(sql) ;   
             pstmt.setInt(1,id) ;   
             pstmt.executeUpdate() ;   
             pstmt.close() ;   
         } catch (Exception e) {   
             throw new Exception("操作中出现错误！！！") ;   
         } finally {   
          m_con.close() ;   
         }   
     }   
    //修改
     public void update(String a,String b,int d) throws Exception {   
         String sql = "UPDATE tb_User SET UserName=?,UserPwd=? WHERE UserID=?" ;   
         PreparedStatement pstmt = null ;     
         Class.forName("net.sourceforge.jtds.jdbc.Driver");    //加载MYSQL JDBC驱动程序  
         Log.d("加载驱动", "成功");     
         m_con =(Connection) DriverManager.getConnection("jdbc:jtds:sqlserver://"+ "175.102.4.147" + ":1433/" + "数据名" ,"用户名", "密码");  
         try {   
             pstmt = m_con.prepareStatement(sql) ;   
             pstmt.setString(1,a) ;   
             pstmt.setString(2,b) ;                 
             pstmt.setInt(3,d) ;   
             pstmt.executeUpdate();   
             pstmt.close() ;   
         } catch (Exception e) {   
             throw new Exception("操作中出现错误！！！") ;   
         } finally {   
          m_con.close() ;   
         }   
     }
 }
 

//布局文件

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >

    <Button
        android:id="@+id/button1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="执行" />

</LinearLayout>

在权限文件里面不要忘记加上这句<uses-permission android:name="android.permission.INTERNET"></uses-permission>