Database to java application

 package vadodara;


import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;


public class Student {

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

// Loading & Registering DB Driver

Class.forName("com.mysql.cj.jdbc.Driver");

//Creating Connection

Connection conn = 

DriverManager.getConnection("jdbc:mysql://localhost:3306/parul", "root", "root");

Statement st = conn.createStatement();

ResultSet rs = st.executeQuery("select * from movies");

while(rs.next()) {

System.out.println(rs.getInt(1)+":"+rs.getString(2)+":"+rs.getString(3)+":"+rs.getString(4));

}

}


}


Comments

Popular posts from this blog

Software Engineering PPT

ERP Software Links

Include Tag JSP