JDBC TEST

package jdbctest;
import java.sql.*;
public class JDBCTEST {
    public static void main(String[] args)throws SQLException {
                Connection myConn = null;
Statement myStmt = null;
ResultSet myRs = null;
                try {
// 1. Get a connection to database
myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/College", "root" , "niit");

System.out.println("Database connection successful!\n");

// 2. Create a statement
myStmt = myConn.createStatement();

// 3. Execute SQL query
myRs = myStmt.executeQuery("select * from student");

// 4. Process the result set
while (myRs.next()) {
System.out.println(myRs.getString("id") + ", " + myRs.getString("name"));
}
}
                catch(Exception e)
                {}

    }
   
}