Packagecom.simope.test;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importcom.mysql.jdbc.Connection;Importcom.mysql.jdbc.Statement; Public classConntomysql { Public Static FinalString url = "jdbc:mysql://localhost/my_db"; Public Static FinalString userName = "root"; Public Static FinalString password = "root"; Public Static voidMain (string[] args) {Connection conn=NULL; Statement stmt=NULL; ResultSet RS=NULL; Try{class.forname ("Com.mysql.jdbc.Driver"); Conn=(Connection) drivermanager.getconnection (URL, userName, password); stmt=(Statement) conn.createstatement (); String SQL= "SELECT * FROM Sys_user"; RS=stmt.executequery (SQL); while(Rs.next ()) {System.out.println ("By column subscript:" + rs.getint (1)); System.out.println ("By Column name:" + rs.getint ("UserID"))); } } Catch(Exception e) {System.out.println ("First:" +e); } finally { Try{rs.close (); Stmt.close (); Conn.close (); } Catch(SQLException e) {System.out.println ("Second:" +e); } } }}
Jar Package used: Mysql-connector-java-5.1.5-bin.jar
MySQL Connection JDBC Query code