файл start_consol.bat

cls
echo ************** console mySQL start ******************
start "********* console mySQL start *********" __cmd.bat
:pause

 

файл _cmd.bat

echo !!!!!!!!!!!!
cd ..\bin
echo ***** d:\mysql\bin\mysql -u root -p -h 10.1.10.27
echo ***** d:\mysql\bin\mysql -u user39 -p -h 10.1.100.39
echo ***** d:\mysql\bin\mysql -u bsu -p -h 10.1.100.39
d:\mysql\bin\mysql -u bsu -p -h 10.1.100.39

 

 

 

 

SHOW DATABASES;

CREATE DATABASE mpes;

DROP USER 'user39'@localhost;
CREATE USER 'user39'@localhost IDENTIFIED BY 'user39';
CREATE USER 'user39'@'%' IDENTIFIED BY 'user39';
GRANT ALL PRIVILEGES ON mpes.* TO user39@localhost IDENTIFIED BY 'user39' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mpes.* TO user39@"%" IDENTIFIED BY 'user39' WITH GRANT OPTION;

 

use mpes;


CREATE DATABASE test;
use test;

DROP TABLE stud;

CREATE TABLE stud (
`id_example_table` int(11) NOT NULL AUTO_INCREMENT,
`text_field` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id_example_table`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


CREATE TABLE stud (
id int(10) NOT NULL AUTO_INCREMENT,
fio VARCHAR(20) NOT NULL,
name VARCHAR(20) NOT NULL,
name1 VARCHAR(20) DEFAULT NULL,
grup VARCHAR(20) DEFAULT NULL,
tel VARCHAR(20)DEFAULT NULL,
sex CHAR(1) DEFAULT NULL,
birth DATE DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB   AUTO_INCREMENT=1   DEFAULT CHARSET=utf8;

DESCRIBE stud;


INSERT INTO stud VALUES (1,'Васильцев','Олег','Олександрович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (2, 'Василяженко','Денис','Володимирович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (3, 'Григоренко','Дмитро','Олександрович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (4, 'Кубрак','Данііл','Олегович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (5, 'Кузьмін','Артем','Валерійович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (6, 'Мазуренко','Антон','Олегович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (7, 'Носко','Дмитро','Юрійович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (8, 'Пасько','Владислав','Миколайович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (9, 'Пономаренко','Антон','Валерійович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (10, 'Тітков','Данило','Максимович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (11, 'Хижук','Вадим','Віталійович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (12, 'Чальцев','Артур','Андрійович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (13, 'Шаповалов','Ігор','Іванович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");
INSERT INTO stud VALUES (14, 'Якименко','Юліан','Віталійович', '6.1228', '+380ppxxxxxxx', 'M', "2000-01-01");

select * from stud;
 

exit

 Содержимое папки D:\mysql\$bat\DBF_znu

03.04.2019 09:16 <DIR> .
03.04.2019 09:16 <DIR> ..
03.04.2019 09:16 <DIR> ddddd
29.03.2019 16:51 68 go.bat
06.05.2021 13:24 58 j.bat
06.05.2021 13:33 2 553 JdbcExample.class
06.05.2021 13:33 3 249 JdbcExample.java
25.01.2013 23:26 843 090 mysql-connector-java-5.1.23-bin.jar
27.03.2019 10:18 3 929 357 mysql-connector-java-5.1.23.zip

файл j.bat

"C:\Program Files\Java\jdk1.8.0_202\bin\javac" %1.java
 

файл go.bat

java -cp .;mysql-connector-java-5.1.23-bin.jar JdbcExample
pause

 

 

 

Файл JdbcExample.java

///// 
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
 
public class JdbcExample {
 
    public static void main(String[] args) {
       String cls = "com.mysql.jdbc.Driver";

       String url = "jdbc:mysql://10.1.100.39/mpes";  ////kit.znu.edu.ua/mpes";
       String un  = "user39";
       String  psw = "user39";

       System.out.println(" cls="+ cls);
        try {
            Class.forName(cls);
        } catch (ClassNotFoundException ex) {
            ///Logger.getLogger(JdbcExample.class.getName()).log(Level.SEVERE, null, ex);
            System.out.println("!!!! ClassNotFoundException driver not found......");
            System.out.println("!!!! "+ex);
            //System.out.println(JdbcExample.class.getName());
            System.exit(16);
        }
        Connection conn = null;
        System.out.println(" url="+ url); 
        try {
            conn =(Connection) DriverManager.getConnection(url,un, psw);
        } catch (SQLException ex) {
            ///Logger.getLogger(JdbcExample.class.getName()).log(Level.SEVERE, null, ex);
            System.out.println("!!!! Connection falue......");
            System.out.println("!!!! "+ex);
            System.exit(8);
        }
       String selectTableSQL = "SELECT * from stud";
       Statement stmnt;
       ResultSet rs;
       try {
            stmnt= (Statement) conn.createStatement();
            rs=stmnt.executeQuery(selectTableSQL);
         while (rs.next()) {
            //Integer id = rs.getInt("ID_EXAMPLE_TABLE");
            //String info = rs.getString("TEXT_FIELD");
            //System.out.print("id: " + id);
            //System.out.println(", info: " + info);
   /*       System.out.print( " " + rs.getInt("id") );
            System.out.print( " "+rs.getString("fio") );
            System.out.print( " "+rs.getString("name") );
            System.out.print( " "+rs.getString("name1") );
            System.out.print( " "+rs.getString("grup") );
            System.out.print( " "+rs.getString("tel") );
            System.out.print( " "+rs.getString("sex") );
            System.out.print( " "+rs.getString("birth") );
            System.out.println(" ");
    */

            System.out.printf( "%5d ", rs.getInt("id") );
            System.out.printf( "%-20s ", rs.getString("fio") );
            System.out.printf( "%-20s ", rs.getString("name") );
            System.out.printf( "%-20s ", rs.getString("name1") );
            System.out.printf( "%-10s ", rs.getString("grup") );
            System.out.printf( "%-14s  ", rs.getString("tel") );
            System.out.printf( "%-2s  ", rs.getString("sex") );
            System.out.printf( "%-10s ", rs.getString("birth") );
            System.out.printf("\n");
    
                                   





         }
        } catch (SQLException e) {
    System.out.println(e.getMessage());
}
    }
}

 

Назад   Содержание