java读取文本文件到mysql数据库【示例1】

3、java读取该文本文件：源码如下

    package com.insigma.zd.group4.liuchao.jdbc;



import java.io.BufferedReader;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;



public class ReadConfigureFile {



	/**

	 * @param args

	 */

	

	public static void main(String[] args) {

		// TODO Auto-generated method stub

		

		String driver = "com.mysql.jdbc.Driver";

		String url = "jdbc:mysql://localhost:3306/school";

		String username = "root";

		String password = "1234";

		Connection conn = null;

		Statement stmt = null;

		

		File file = new File("D:\\share\\手机号码归属地\\安徽联通.txt");

		StringBuffer sql = null;

		BufferedReader reader = null;

		String line = null;

		String[] str = null;

		String beginNumber = null;

		String endNumber = null;

		String city = null;

		try {

			Class.forName(driver);

			conn = DriverManager.getConnection(url, username, password);

			reader = new BufferedReader(new FileReader(file));

			stmt = conn.createStatement();

			while((line = reader.readLine())!= null){

				sql = new StringBuffer();

				str = line.split("-");

				beginNumber = str[0];

				endNumber = str[1];

				city = str[2];

				sql.append("insert into phonenumber(beginNumber,endNumber,city) values('");

				sql.append(beginNumber+"','");

				sql.append(endNumber+"','");

				sql.append(city+"')");

				stmt.executeUpdate(sql.toString());

			}

		} catch (FileNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (ClassNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}finally{

			if(reader != null){

				try {

					reader.close();

				} catch (IOException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				}

			}

		}

	}



}