sql 从一个表中复制数据到另外一个表中

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 {
	/**
	 * 
	 * @param conn
	 * @param username
	 * @param pass
	 * @return
	 * @throws ClassNotFoundException
	 */

	public static Connection con = null;

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

		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";
		Statement st = null;
		
			try {
				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();
			}
			finally
			{
				try {
					if (con != null || st != null) {
						con.close();
						st.close();
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}


	public static void main(String[] args) {

		execCopy();

	}

}