package JB.stu;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
public class Stu {
JFrame jFrame;
public static void main(String[] args) {
// TODO Auto-generated method stub
new Stu().init();
}
public void init()
{
jFrame=new JFrame();
jFrame.setBounds(100,100, 500, 500);
jFrame.setLayout(null);
JButton jButton=new JButton("数据库连接");
jButton.setBounds(100, 100, 100, 100);
jButton.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
String className="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/student?useSSL=false&serverTimezone=UTC";
String user="root";
String password="root1";
//1.驱动实例化
try {
Class.forName(className);
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//2.创建数据库连接
try {
Connection con=DriverManager.getConnection(url, user, password);
//如果这里报错,就是添加的包输错,在上面找到jdbc.connect包删除,statement也是同样
//3.构建查询器
Statement statement=con.createStatement();
//4.1创建SQL语句
String sql="select * from stu";
//4.2执行SQL语句
ResultSet resultSet=statement.executeQuery(sql);
//这里的sql是查询语句,result中存储的仍然是一个表;
while(resultSet.next())
{
String SexString=resultSet.getString("Sex");//这里getString中的是要查询的属性
String nameString=resultSet.getString("name");
System.out.println("name:"+nameString+" Sex:"+SexString);
}
//5关闭数据库
resultSet.close();
statement.close();
con.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
jFrame.add(jButton);
jFrame.setVisible(true);
}
}