005JAVA系列之数据库连接

package jianzun.net;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author jianzun
 *2021-09-24
 */
public class testmysql {

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		try {
			
			String url ="jdbc:mysql://localhost:3306/person";
			String user = "root";
			String psd ="zxc123456";
			
			Class.forName("com.mysql.jdbc.Driver");//注册驱动
			Connection conn = DriverManager.getConnection(url, user, psd);//加载驱动连接数据库
			Statement statement = conn.createStatement();
			statement.execute("insert into personinfo values('2009110247','kunpeng',26)");
			
			ResultSet resultSet = statement.executeQuery("select * from personinfo");
			
			resultSet.last();
			
			System.out.println("数据记录："+resultSet.getRow());//2条记录
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}