????? ???? ?? ???? ???? ?????? '?????'?? ???. ?????? ???? ???? ??? ?? ????? ???. ?? ??? ?????? ?? ???? ?? ? ?????.

?? ? ?????? ?? ?? ?? JAVA MASTERY - ?? ?? | 78 ?? ??? | 15?? ????

??? ??: ??? ????, ??, ?? ???(??? ??, ?? ?? ?)? ?? ??? ?? ?

???? ??? ?????:

• ???? ?? ????? ?? ??? ??
• ?? ???? ??, ??, ???, ?? ? ?? ??? ??? ???? ????.
• ?? ?? ??? ??.
• ?? ? ?? ??? ???? ??? ? ?????.
• ???? ????
• ??? ??? ? ?? ??? ?????.

?????? ? ??????

Java ????? ??? ???, ????? ???? ?? ??? ??? ?? ??? ?????.

????? ??

??????? ? ?? ??? ????.

• ?? ?????
• ?? ? ?? ?????
• ?? ??? ?????

1. ?? ?????: ?? ??????? ?? ??? ??? ?? ??? ?????. Datawarehouse? ?? ????? ??? ???? ?? ???? ???? ??? ??? ?? ??? ???? ??? ?? ??? ?? ??? ?????. ?? ????? ??? ???? ?? ?? ??? ??? ??? ? ??? ???.

2. ?? ? ?? ?????: ?? ? ?? ??????? ?? ????? ??? ??? ?? ???? ?????. ??? ??? ?? ??, ??, ???? ??? ?? ? ?? ?????? ????.

3. ?? ??? ?????: ?? ??? ?????? ??? ???? ?? ?????. ?? ?? ?? ???? ??? ??????? ???? ?? ? ????.

Java?? ?????? ??? ??????

Java ?????? ??? ???? ???? ?????. ???? ?? ???? ??? ?????.

??:

class Metadata{
public static void main(String args[]){
try{
//load required database class
//creating database metadata class
DatabaseMetaData metaData=con.getMetaData();
//display the metadata of the table content
System.out.println(metaData.getDriverName());
System.out.println(metaData.getDriverVersion());
System.out.println(metaData.getUserName());
System.out.println(metaData.getDatabaseProductName());
System.out.println(metaData.getDatabaseProductVersion());
con.close();
}catch(Exception e){ System.out.println(e);}
}
}

??: ??? ???? ?? MySQL ??????? mysql-connector jar? ?????.

Java?? ?????? ???? ?

??? Java? ????? ????.

? #1 – ?? ?? ?????

???:

import java.sql.*;//importing sql package
public class A {//Creating class
//main method for run the application
public static void main(String args[]) {
try {
//loading my sql driver
Class.forName("com.mysql.jdbc.Driver");
//get the connection by providing database, user name and password
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
//select the all from employee table
PreparedStatement preparedStatement = connection.prepareStatement("select * from employee");
//executing the query
ResultSet resultSet = preparedStatement.executeQuery();
//Create result meta data for get the meta data of table
ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
//Displaying meta data of employee table
System.out.println("Total Number of columns: " + resultSetMetaData.getColumnCount());
System.out.println("1st Column name : " + resultSetMetaData.getColumnName(1));
System.out.println("2nd Column name : " + resultSetMetaData.getColumnName(2));
System.out.println("3rd Column name : " + resultSetMetaData.getColumnName(3));
System.out.println("Column Type Name of 1st column: " + resultSetMetaData.getColumnTypeName(1));
System.out.println("Column Type Name of 2nd column: " + resultSetMetaData.getColumnTypeName(2));
System.out.println("Column Type Name of 3rd column: " + resultSetMetaData.getColumnTypeName(3));
connection.close();
} catch (Exception e) {
System.out.println(e);
}
}
}

??:

? #2 – ?????? ?????

??:

import java.sql.*;//importing sql package
public class A {//Creating class
//main method for run the application
public static void main(String args[]) {
try {
//loading my sql driver
Class.forName("com.mysql.jdbc.Driver");
//get the connection by providing database, user name and password
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
//select the all from employee table
PreparedStatement preparedStatement = connection.prepareStatement("select * from employee");
//executing the query
preparedStatement.executeQuery();
//Create databse result set meta data for get the meta data of databse of mysql
DatabaseMetaData databaseMetaData=connection.getMetaData();
//Displaying meta data of mysql table
System.out.println("MYSQL Driver Name: "+databaseMetaData.getDriverName());
System.out.println("MYSQL Driver Version: "+databaseMetaData.getDriverVersion());
System.out.println("MYSQL UserName: "+databaseMetaData.getUserName());
System.out.println("MYSQL Database Product Name:"+databaseMetaData.getDatabaseProductName());
System.out.println("MYSQL Database Product Version: "+databaseMetaData.getDatabaseProductVersion());
connection.close();
} catch (Exception e) {
System.out.println(e);
}
}
}

??:

?? #3 – ??? ?? ??? ?? ?????? ?????

??:

import java.sql.*;//importing sql package
public class A {// Creating class
// main method for run the application
public static void main(String args[]) {
try {
// loading my sql driver
Class.forName("com.mysql.jdbc.Driver");
// get the connection by providing database, user name and password
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
// Create databse result set meta data for get the meta data of
// databse of mysql
DatabaseMetaData dbmd = connection.getMetaData();
String table[] = { "VIEW" };
ResultSet resultSet = dbmd.getTables(null, null, null, table);
// iterating number table names from database of mysql
while (resultSet.next()) {
System.out.println("Table name is: "+resultSet.getString(3));
}
connection.close();
} catch (Exception e) {
System.out.println(e);
}
}
}

??:

??

Java? ?????? ???? ?? ???? ?? ?? ?????. ?? ?? ??? ?? ??, ?? ??? ??, ?? ??? ?? ??, ?????? ??? ??, ?? ??????? ???? ?????? ? ?? ?????.

? ??? Java? ?????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!