java 电话号码归属地查询

说明：我用的是自己本地的一个电话号码类库（address.db）

1.在java中为了驱动address.db，需下载sqlite-jdbc-3.7.2.jar

2.java代码：

package com.afan.rock.SQLiteDb; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Dao { static{ try { Class.forName("org.sqlite.JDBC"); } catch (ClassNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } public static String getAddress(String number) { String address = ""; Connection connection = null; try { // create a database connection connection = DriverManager.getConnection("jdbc:sqlite:address.db"); Statement statement = connection.createStatement(); statement.setQueryTimeout(30); ResultSet rs = statement.executeQuery("select location from data2 " + "where id=(select outkey from data1 where id="+number.substring(0, 7)+")"); while (rs.next()) { address = rs.getString("location"); } return address; } catch (SQLException e) { System.err.println(e.getMessage()); } finally { try { if (connection != null) connection.close(); } catch (SQLException e) { System.err.println(e); } } return address; } }

3.写个测试类 调用getAddress(String number)方法，将电话号码作为参数传入就行了