Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Establishing SSL connection without server's identity verification is not recommended.
- According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be
- established by default if explicit option isn't set. For compliance with
- existing applications not using SSL the verifyServerCertificate property is
- set to 'false'. You need either to explicitly disable SSL by setting useSSL=false,
- or set useSSL=true and provide truststore for server certificate verification.
- import java.sql.*;
- public class JdbcCreateTable {
- public static void main(String args[])
- {
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- }
- catch(ClassNotFoundException e)
- {
- e.printStackTrace();
- }
- try{
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/INTtech","root","root");
- Statement st=con.createStatement();
- int i=st.executeUpdate("create table Author(AID int primary key,Aname varchar(20),AContact no int,ACountry string)");
- System.out.println("Table is created"+i);
- con.close();
- }
- catch(SQLException e)
- {
- e.printStackTrace();
- }
- }
- }
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/INTtech?useSSL=false","root","root");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement