数据库中表的复制

package com.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
 *从一个表中复制数据到另外一个表中
 * @author jinchun
 *
 */
public class Test_mysql {

	public static Connection getConn(String conn, String username, String pass)
			throws ClassNotFoundException {

		Connection con = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(conn, username, pass);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;

	}

	public static void execCopy() {
		String urlcon = "jdbc:mysql://localhost:3306/test";
		String name = "root";
		String password = "root";
		try {
			Statement st = getConn(urlcon, name, password).createStatement();
			System.out.println("连接成功");
			st.execute("insert into chun select * from jin");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		
		 execCopy();

	}

}