Sunday, 10 March 2019

Database Connection Code

New-> Java Project-> Java Class


DatabseConnectionSample.java:


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class DatabseConnectionSample {


public static void main(String[] args) throws Exception {


Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","system");
Statement st=con.createStatement();
st.executeQuery("CREATE TABLE AVANTHI(NAME VARCHAR2(10),EMAIL VARCHAR2(20))");
}

}

No comments:

Post a Comment