java读取数据库
package success;
import java.io.IOException;
import java.net.MalformedURLException;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.HashSet;
import java.util.Set;
import java.sql.*;
import com.mysql.cj.jdbc.Driver;
public class hou {
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
String urlll = "jdbc:mysql://localhost:3306/test01?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
String user = "root";//MySQL用户名
String password = "1234567890";//MySQL登录密码,自己设置
String sql="SELECT * FROM test01.tt";
Connection conn = null;
conn=DriverManager.getConnection(urlll,user,password);
if(!conn.isClosed())
System.out.println("数据库连接成功!");
Statement Statement=conn.createStatement();
Statement.executeQuery(sql);
ResultSet rs=Statement.executeQuery(sql);
while(rs.next()) {
System.out.print(rs.getString("title"));
System.out.println(rs.getString("class"));
}
}
}

浙公网安备 33010602011771号