Java查询数据库

package Login1;

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;
import javax.swing.JTextField;



public class Login1 {
	JFrame jFrame;
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new Login1().init();
	}
	public void init()
	{
		jFrame=new JFrame();
		jFrame.setBounds(100, 100, 1000, 1000);
		jFrame.setLayout(null);
		
		JTextField userName=new JTextField();
		userName.setBounds(100, 100, 150,50);
		jFrame.add(userName);
		
		JTextField password=new JTextField();
		password.setBounds(300, 100,150, 50);
		jFrame.add(password);
		
		JButton jButton=new JButton("登录");
		jButton.setBounds(0, 300, 50, 50);
		
		jButton.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				//1.驱动实例化
				String className="com.mysql.jdbc.Driver";
				try {
					Class.forName(className);
				} catch (ClassNotFoundException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				//2.创建数据库连接
				String url="jdbc:mysql://localhost:3306/user?useSSL=false&serverTimezone=UTC";
				String userString="root";
				String passwordString="root1";
				try {
					Connection connection=DriverManager.getConnection(url, userString, passwordString);
					//3.构建查询器
					Statement statement=connection.createStatement();
					//4.1创建SQL语句
					String sql="select * from login where ";
					sql+="userName= '"+userName.getText()+"' AND password='"+password.getText()+"'";
					
					//4.2执行SQL语句
					ResultSet resultSet=statement.executeQuery(sql);
					if(resultSet.next())
						System.out.println("登录成功");
					else {
						System.out.println("登录失败");
						}
					//5.关闭数据库
					resultSet.close();
					statement.close();
					connection.close();
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		
		
		jFrame.add(jButton);

		
		jFrame.setVisible(true);
	}
}