Java数据库

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);
	}

	
}