1. First prepare the MySQL and Eclipse environment. After the environment is set up, download the JDBC driver package from the Eclipse official website. The download address is http://dev.mysql.com/downloads/connector/j/ 2. Take out mysql-connector-java-5.1.31-bin.jar from the downloaded file, put it in the project, and import the path Method: Right-click the project name->Build Path->Configure Build Path, select Add External JAR... Find the location of mysql-connector-java-5.1.31-bin.jar, and then load the driver package into the project. 3. Write an example to test it package testmysql; import java.sql.*; public class Test { public static void main(String[] args) { String driver = "com.mysql.jdbc.Driver"; String URL = "jdbc:mysql://localhost:3306/student"; Connection con = null; try { Class.forName(driver); } catch(java.lang.ClassNotFoundException e) { System.out.println("Connect Successfully."); System.out.println("Cant't load Driver"); } try { con=DriverManager.getConnection(URL,"root","root"); System.out.println("Connect Successfully."); } catch(Exception e) { System.out.println("Connect fail:" + e.getMessage()); } } } After connecting to the database, you can query the database table according to the content in the table. First, there must be content in the table. After entering some information into the table, you can use SQL language to query import java.sql.*; public class Main { public static void main(String[] args) { String driver = "com.mysql.jdbc.Driver"; String URL = "jdbc:mysql://localhost:3306/xiaolu"; Connection con = null; ResultSet rs = null; Statement st = null; String sql = "select * from student"; try { Class.forName(driver); } catch(java.lang.ClassNotFoundException e) { // System.out.println("Connect Successfully."); System.out.println("Cant't load Driver"); } try { con=DriverManager.getConnection(URL,"root","root"); st=con.createStatement(); rs=st.executeQuery(sql); if(rs!=null) { ResultSetMetaData rsmd = rs.getMetaData(); int countcols = rsmd.getColumnCount(); for(int i=1;i<=countcols;i++) { if(i>1) System.out.print(";"); System.out.print(rsmd.getColumnName(i)+" "); } System.out.println(""); while(rs.next()) { System.out.print(rs.getString("sno")+" "); System.out.print(rs.getString("sname")+" "); System.out.print(rs.getString("ssex")+" "); System.out.print(rs.getString("sage")+" "); System.out.println(rs.getString("sdept")+" "); } } //System.out.println("Connect Successfully."); System.out.println("ok"); rs.close(); st.close(); con.close(); } catch(Exception e) { System.out.println("Connect fail:" + e.getMessage()); } } } This is the end of the article about JDBC connection to MySQL 5.7. For more information, please check other related articles on 123WORDPRESS.COM. You may also be interested in:
|
<<: SMS verification code login function based on antd pro (process analysis)
>>: Three Ways to Lock and Unlock User Accounts in Linux
This article shares with you two methods of setti...
vmware workstations starts the virtual machine er...
1. Download the ElasticSearch 6.4.1 installation ...
structure body, head, html, title text abbr, acro...
This article mainly introduces the Mysql backup m...
View container logs First, use docker run -it --r...
For several reasons (including curiosity), I star...
Think big and small, then redirect. Sometimes Lin...
Preface This is an investigation caused by the ex...
Table of contents The beginning of the story Inst...
Web front-end optimization best practices: conten...
In our recent project, we need to use Google robo...
For websites with an architecture like LNMP, they...
There is no data directory, my-default.ini and my...
Table of contents 1. CDN introduction 1.1 react (...