创建新项目
如图选择
输入项目名称,即可进入如下页面:
**
使用jdbc连接mysql
**
1.导入jar包
在web下创建新文件夹lib,并在lib里导入mysql-connector-java-xxx.jar
如图:
2.在project structure中的library里导入lib
3.在src中新建java文件,写运行代码如下:
import java.sql.*;
public class code {
public static String getMysql(){
String url = "jdbc:mysql://127.0.0.1:3306/JAVAEE?useSSL=false";
String driveName = "com.mysql.cj.jdbc.Driver";
String sqlstring = "SELECT * FROM first";
try {
//加载驱动
Class.forName(driveName);
//创建连接
Connection connection = DriverManager.getConnection(url,"root","123456");
//通过连接获取statement
Statement statement = connection.createStatement();
//sql语句
ResultSet resultSet = statement.executeQuery(sqlstring);
//获取执行结果
while(resultSet.next()){
System.out.println(resultSet.getLong(1));
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
return null;
}
public static void main(String[] args){
getMysql();
}
}
运行code.java
完成~