package ss;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class a {
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
insert window = new insert();
//调用Class.forName()方法加载驱动程序
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("成功加载MySQL驱动!");
String url="jdbc:mysql://localhost:3306/xj"; //JDBC的URL
Connection conn;
conn = DriverManager.getConnection(url,"root","siyuan521...");
String sql = "select * from student"; //要执行的SQL
Statement stmt = conn.createStatement(); //创建Statement对象
ResultSet rs = stmt.executeQuery(sql);//创建数据对象
System.out.println("姓名"+"\t"+"性别");
while (rs.next()){
System.out.print(rs.getString(1) + "\t");
System.out.print(rs.getString(2) + "\t");
System.out.println();
}
rs.close();
stmt.close();
conn.close();
//记得关闭连接
catch(Exception e)
{
e.printStackTrace();
}
}
});
}
}
java连接Mysql代码
最新推荐文章于 2023-06-02 16:56:10 发布