WiFi设备MAC地址的获取-----服务器端

很简单，就是一个接收安卓端的信息，然后转存到数据库中

ServerForGetMethod：

package com.gm.servlet;


import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.Map;

import android.os.Handler;

public class SendDateToServer {
	private static String url="http://10.18.55.240:8080/ServerForGetMethod/servlet/ServerForGetMethod";
	public static final int SEND_SUCCESS=0x123;
	public static final int SEND_FAIL=0x124;
	private Handler handler;
	public SendDateToServer(Handler handler){
		this.handler=handler;
	}
	
	public void SendDataToServer(String macaddress){
		final Map<String,String>map=new HashMap<String,String>();
		map.put("macaddress", macaddress);
		new Thread(new Runnable(){
			
			public void run(){
				try{
					if(sendGetRequest(map,url,"utf-8")){
						handler.sendEmptyMessage(SEND_SUCCESS);
					}else{
						handler.sendEmptyMessage(SEND_FAIL);
					}
				}catch(Exception e){
					e.printStackTrace();
				}
			}
		}).start();
	}
	
	private boolean sendGetRequest(Map<String,String> param,String url,String encoding) throws Exception{
		
		StringBuffer sb=new StringBuffer(url);
		if(!url.equals("")&!param.isEmpty()){
			sb.append("?");
			for(Map.Entry<String, String>entry:param.entrySet()){
				sb.append(entry.getKey()+"=");
				sb.append(URLEncoder.encode(entry.getValue(),encoding));
				sb.append("&");
			}
			sb.deleteCharAt(sb.length()-1);
		}
		HttpURLConnection conn=(HttpURLConnection) new URL(sb.toString()).openConnection();
		conn.setConnectTimeout(5000);
		conn.setRequestMethod("GET");
		if(conn.getResponseCode()==200){
			return true;
		}
		return false;
	}

}

数据库链接：

package com.gm.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DB {
	public static Connection getConn(){
		Connection conn=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs", "root","121411");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	public static Statement createStmt(Connection conn){
		Statement stmt=null;
		try {
			stmt=conn.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return stmt;
	}
	public static ResultSet executeQuery(Statement stmt,String sql){
		ResultSet rs=null;
		try {
			rs=stmt.executeQuery(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return rs;
	}
	
	public static void close(Connection conn){
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			conn=null;
		}
	}
	public static void close(Statement stmt){
		if(stmt!=null){
			try {
				stmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			stmt=null;
		}
	}
	
	public static void close(ResultSet rs){
		if(rs!=null){
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			rs=null;
		}
	}

}