eclipse 连接 mysql

create database test;

create table user (name, varchar(20), password varchar(20));

insert into user values (‘xiaotao‘, ‘123456‘);

package sql;
import java.lang.reflect.Executable;
import java.sql.*;

public class Connector {
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("Success loading Mysql Driver");
		}catch (Exception e) {
			System.out.println("Error loading Mysql Driver!");
			e.printStackTrace();
		}
		try {
			Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456");
			System.out.println("Success connect Mysql server!");
			Statement stmt = connect.createStatement();
			ResultSet rs = stmt.executeQuery("select *from user");
			while(rs.next()) {
				System.out.println(rs.getString("name"));
			}
			
			PreparedStatement stmt2 = connect.prepareStatement("insert into user value(?, ?)");
			stmt2.setString(1, "sunhongtao");
			stmt2.setString(2, "123");
			stmt2.executeUpdate();
		}
		catch (Exception e) {
			System.out.println("get data error!");
			e.printStackTrace();
		}
	}
}