1.首先创建个Java project
2.建立java与mysql的连接,注意java版本与mysql要对应
3.选中相应版本
4.然后就会出现一个Referenced Libraries
5.之后在src创建你要写的代码~
比如class类中的
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.ResultSet;
public class Base {
/**
* @param args
*/
public static void main(String[] args) throws ClassNotFoundException,SQLException{
// TODO Auto-generated method stub
test();
}
static void test()throws ClassNotFoundException,SQLException{
Class.forName("com.mysql.cj.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/mysql";
String user="root";
String password="123456";
Connection conn=DriverManager.getConnection(url,user,password);
Statement st=conn.createStatement();
String sql ="select*from user";
ResultSet rs =st.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3));
}
rs.close();
st.close();
conn.close();
}
}