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
Post a Comment