mysql jdbc 连接数据库

//加载驱动

Class.forName("com.mysql.jdbc.Driver");

//连接数据库

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/taotao", "root", "123456");

//获取statement对象

Statement sql = conn.createStatement();

//执行sql

ResultSet rs = sql.executeQuery("select * from tb_item;");

//获取结果

while(rs.next()){
System.out.println(rs.getString(1));
}