手机号码归属地查询代码

最新推荐文章于 2024-08-09 07:32:36 发布

不骏则退

最新推荐文章于 2024-08-09 07:32:36 发布

阅读量6.4k

点赞数 1

分类专栏： JAVA日常联练习文章标签： io

本文链接：https://blog.csdn.net/junjialuo/article/details/51794442

版权

本文介绍了如何通过编程实现手机号码的归属地查询，涵盖了IO操作和数据处理的关键步骤，帮助开发者理解并实现相关功能。

摘要由CSDN通过智能技术生成

package com.rupeng.test;

import java.io.Closeable;
import java.io.IOException;

public class IOUtils
{
	public static void closeQuietly(Closeable closeable)
	{
		if(closeable!=null)
		{
			try
			{
				closeable.close();
			} catch (IOException e)
			{
				//
			}
		}
	}
}

<pre name="code" class="java">package com.rupeng.test;

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

public class JdbcUtils
{
	private final static String dbdriver = ConfigReader.dbdriver;
	private final static String dburl = ConfigReader.dburl;
	private final static String dbusername = ConfigReader.dbusername;
	private final static String dbpassword = ConfigReader.dbpassword;
	static
	{
		try
		{
			Class.forName(dbdriver);
		} catch (ClassNotFoundException e)
		{
			throw new ExceptionInInitializerError(e);
		}
	}

	public static Connection createConnection() throws SQLException
	{
		return DriverManager.getConnection(dburl, dbusername, dbpassword);
	}

	public static void close(Connection conn)
	{
		if (conn != null)
		{
			try
			{
				conn.close();
			} catch (SQLException e)
			{

			}
		}
	}

	public static void close(Statement stmt)
	{
		if (stmt != null)
		{
			try
			{
				stmt.close();
			} catch (SQLException e)
			{

			}
		}
	}

	public static void close(ResultSet rs)
	{
		if (rs != null)
		{
			try
			{
				rs.close();
			} catch (SQLException e)
			{

			}
		}
	}

	public static int executeUpdate(String sql, Object... parameters)
			throws SQLException
	{
		Connection conn = null;
		try
		{
			conn = createConnection();
			return executeUpdate(c