一、java连接mysql数据库操作
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
</dependencies>
package Day.JDBC1;
import java.sql.*;
public class test1 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://127.0.0.1:3306/school";
String user="root";
String password="123456";
Connection con=DriverManager.getConnection(url,user,password);
Statement stat=con.createStatement();
String sql="select * from student";
ResultSet rs=stat.executeQuery(sql);
while(rs.next()){
String a=rs.getString(2);
System.out.println(a);
}
rs.close();
stat.close();
con.close();
}
}