файл 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()); } } }