Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Array;
- import java.sql.Connection;
- import java.util.ArrayList;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class Laba1 {
- private static final String url="jdbc:mysql://localhost:3306/shebet";//для создания подключения с базой данных
- private static final String user="root";
- private static final String password="27021998";
- private static Connection con;
- private static Statement stmt;
- private static ResultSet rs;
- public static void main(String[] args){
- String zapros_1="SELECT * FROM worker";
- String zapros_2="SELECT Firstname FROM worker WHERE Money <=?";
- String zapros_3="SELECT Firstname FROM worker WHERE Year >=10";
- ArrayList <Integer> money=new ArrayList <Integer>();
- int mid=0;
- try{
- con=DriverManager.getConnection(url,user,password);//создаётся подключение
- PreparedStatement st=con.prepareStatement(zapros_2);
- stmt=con.createStatement();
- rs=stmt.executeQuery(zapros_1);
- System.out.println("Индекс "+"Фамилия "+"Квалификация "+"Срок работы "+"Зарплата");
- while(rs.next()){
- int id=rs.getInt(1);
- String First=rs.getString(2);
- String kval=rs.getString(3);
- int year=rs.getInt(4);
- int mon=rs.getInt(5);
- money.add(rs.getInt(5));
- System.out.println(id+" "+First+" "+kval+" "+year+" "+mon);
- }
- rs.close();
- int[] a1=new int[money.size()];
- for(int i=0;i<a1.length;i++){
- a1[i]=money.get(i);
- mid=mid+a1[i];
- }
- mid=mid/a1.length;
- String mi=String.valueOf(mid);
- System.out.println();
- //System.out.print(zapros_2);
- st.setString(1, mi);
- st.executeUpdate();
- st.close();
- //stmt=con.createStatement();
- rs=stmt.executeQuery(zapros_2);
- while(rs.next()){
- String name=rs.getString(1);
- System.out.println(name);
- }
- }
- 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