Java Database [JDBC] Connection Programming Code*

Java Database Connection:

1. Oracle database:

String driver="oracle.jdbc.driver.OracleDriver";

String username = "tiger";

String password = "1234";

String oracleURL = "jdbc:oracle:thin:@localhost:1521:school_db";//database name school_db,port number=1521

try{

Class.forName(driver);

Connection c=DriverManager.getConnection(oracleURL,username,password);

return c;

}

catch(Exception e)

{

System.out.println("error in connection"+e);

return null;

}

2. Mysql database:

String driver="com.mysql.jdbc.Driver";

String username = "tiger";

String password = "1234";

String oracleURL = "jdbc:mysql://localhost:3306:school_db";//database name school_db,

port number by default

=3306

try{

Class.forName(driver);

Connection c=DriverManager.getConnection(oracleURL,username,password);

return c;

}

catch(Exception e)

{

System.out.println("error in connection"+e);

return null;

}

3. Mariadb database:

String driver="org.mariadb.jdbc.Driver";

String username = "root";

String password = "1234";

String oracleURL = "jdbc:mysql://localhost:3306/school_db";

//database name school_db,port number by default=3306

try{

Class.forName(driver);

Connection c=DriverManager.getConnection(oracleURL,username,password);

return c;

}

catch(Exception e)

{

System.out.println("error in connection"+e);

return null;

}

NOte- To connect java application with the [oracle,mysql,mariadb]database,[oracle,mysql,mariadb] connector.jar file is required to be loaded.

How to Copy Paste file in java [Java Code]

copy Paste file in java code:

import java.io.*;//Package

class copyfile{

public static void main(String...str) throws IOException

{

int c;

FileInputStream fr=new FileInputStream("demo.pdf");//input file name

BufferedInputStream br=new BufferedInputStream(fr);

FileOutputStream fw=new FileOutputStream("testfile.pdf");//output file name

while((c=br.read())!=-1)

{

fw.write(c);

}

fr.close();

fw.close();

}

}

How to create java executable jar file like software [Executable Jar File]

Create java executable jar file:

1.open cmd.exe (command prompt) for creating jar file

jar cvfm MyJarName.jar manifest.txt *.class

2. All the class file with main class in the same folder with 

manifest.txt file

File name=manifest.txt 

Main-Class: main_class_name 

NOte- if class file have package then [package_name.main_class_name]

Main-Class: com.democlass