JDBC连接数据库（将库一中某表的数据复制到库二中）

为什么80%的码农都做不了架构师？>>>   

java代码如下：

package com.rsr.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class allStaffTest {

	public static void main(String[] args) {
		
		String driver="com.mysql.jdbc.Driver";//驱动路径
		String url="jdbc:mysql://192.168.1.128:3306/rsrmsg";//数据库地址
		String user="root";//访问数据库的用户名
		String password="rsr_dev";//用户密码        
		
		
		try {
			//1、加载驱动
			Class.forName(driver);
			//2、链接数据库
			Connection con = DriverManager.getConnection(url, user, password);
			List<String> list = new ArrayList<String>();
			if(!con.isClosed()){//判断数据库是否链接成功
				System.out.println("已成功链接数据库！");
				//3、创建Statement对象
				Statement st = con.createStatement();
				//4、执行sql语句
				String sql="SELECT a.id as aId,a.name as aName,b.hukou_type as aHukou,b.fund_all_c as aFundc,b.fund_all_p as aFundp from base b LEFT JOIN area a on a.id = b.area_id where fund_all_c is not null";//查询user表的所有信息
				ResultSet rs = st.executeQuery(sql);//查询之后返回结果集
				//5、打印出结果
				while(rs.next()){
//					List<String> allList = new ArrayList<String>();
					String all = "";
					all += rs.getString("aId")+",";
					all += rs.getString("aName")+",";
					all += rs.getString("aHukou")+",";
					String fundc = rs.getString("aFundc");
					String a = fundc.substring(0, fundc.length()-1);
					String b = a.split(",")[a.split(",").length-1];
					all += b+",";
					String fundp = rs.getString("aFundp");
					String c = fundc.substring(0, fundp.length()-1);
					String d = c.split(",")[c.split(",").length-1];
					all += d+",";
					list.add(all);
				}
				
				
				rs.close();//关闭资源
			}
            
            con.close();//关闭数据库
            for(int i=0;i<list.size();i++){
            	System.out.println(list.get(i));
            }
            
            //gaiku
            String renshibaourl="jdbc:mysql://192.168.1.128:3306/renshiren";//数据库地址
    		String renshibaouser="root";//访问数据库的用户名
    		String renshibaopassword="rsr_dev";//用户密码   
    		//1、加载驱动
			Class.forName(driver);
			
			
			Connection renshibaocon = DriverManager.getConnection(renshibaourl, renshibaouser, renshibaopassword);
			if(!renshibaocon.isClosed()){//判断数据库是否链接成功
				System.out.println("------------------------------------------------------已成功链接数据库人事保！");
				
				for(int m=0;m<list.size();m++){
					String one = list.get(m);
					String[] two = one.split(",");
					String areaname = two[1];
					String hukouType = two[2];
					String fundC = two[3];
					String fundP = two[4];
					System.out.println(areaname+".."+hukouType+".."+fundC+".."+fundP+"..");
					//3、创建Statement对象
					Statement renshibaost = renshibaocon.createStatement();
					
					//4、执行sql语句
					String sqls="SELECT * FROM area where name = '"+areaname+"' and pid is not null";
					ResultSet rsbrs = renshibaost.executeQuery(sqls);//查询之后返回结果集
					//5、打印出结果
					String id = "";
					while(rsbrs.next()){
						id = rsbrs.getString("id");
						System.out.println(areaname+rsbrs.getString("id"));
					}
					rsbrs.close();//关闭资源
					System.out.println(id);
					
					Statement renshibaost2 = renshibaocon.createStatement();
					String sql2="update base set fund_c = '"+fundC+"',fund_p = '"+fundP+"' where area_id = "+id+" AND hukou_type = "+hukouType;
					int result = renshibaost2.executeUpdate(sql2);//查询之后返回结果集
					if(result>0){
		                System.out.println("操作成功");
		            }else{
		                System.out.println("操作失败");
		            }
				}
				
			}
            
			renshibaocon.close();//关闭数据库
            
            
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
		
		
	}

}

 

转载于:https://my.oschina.net/miwang/blog/1358838