Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package ru.nyan.laba5;
- import java.util.*;
- import java.sql.*;
- public class Laba5 {
- private static final String url="jdbc:mysql://localhost:3306/Nyan";//для создания подключения с базой данных
- private static final String user="root";
- private static final String password="27021998";
- private static Connection con;
- private static Statement stmt;
- private static ResultSet rs;
- private static String select1="SELECT * FROM laba5";
- private static String select2="SELECT * FROM laba5_1";
- private static ArrayList<Integer> a1=new ArrayList<>();
- private static ArrayList<Integer> a2=new ArrayList<>();
- private static ArrayList<Integer> res=new ArrayList<>();
- public static ArrayList<Integer> merge(ArrayList<Integer> array1, ArrayList<Integer> array2) {
- ArrayList<Integer>res1 = new ArrayList<Integer>(array1.size()+array2.size());
- int aIndex = 0;
- int bIndex = 0;
- int i = 0;
- while (i < res1.size()) {
- res1.add(i, array1.get(aIndex) < array2.get(bIndex) ? array1.get(aIndex++) : array2.get(bIndex++));
- if (aIndex == array1.size()){
- System.arraycopy(array2, bIndex, res1, ++i,array2.size() - bIndex);
- break;
- }
- if (bIndex == array2.size()) {
- System.arraycopy(array1, aIndex, res1, ++i, array1.size() - aIndex);
- break;
- }
- i++;
- }
- return res1;
- }
- public static void main(String[] args){
- try{
- con=DriverManager.getConnection(url,user,password);//создаётся подключение
- stmt=con.createStatement();
- rs=stmt.executeQuery(select1);
- while(rs.next()){
- a1.add(rs.getInt(1));
- }
- rs=stmt.executeQuery(select2);
- while(rs.next()){
- a2.add(rs.getInt(1));
- }
- res.addAll(a1);
- res.addAll(a2);
- Collections.sort(res);
- res.addAll(merge(a1,a2));
- System.out.print("Первый массив:"+a1+"\nВторой массив:"+a2+"\nРезультат:"+res);
- }
- catch(SQLException sqlEx){
- sqlEx.printStackTrace();//закрываем подключение с базой данных
- }finally{
- try{con.close();}catch(SQLException se){
- try{stmt.close();}catch(SQLException sr){
- try{rs.close();}catch(SQLException sy){
- }
- }
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement