package jdbc;
import java.sql.*;
import com.mysql.cj.protocol.Resultset;
import com.mysql.cj.x.protobuf.MysqlxCrud.Collection;
public class jdbc2 {
public static void main(String[] args) throws Exception {
// TODO 自动生成的方法存根
String url = "jdbc:mysql://localhost:3306/mysql1";
String user = "root";
String password = "1234";
Connection collection = DriverManager.getConnection(url, user, password);
if (collection != null) {
System.out.println("collection seccess");
Statement statement = collection.createStatement();
ResultSet resultset = statement.executeQuery("select * from mytable1");
while(resultset.next()) {
String 工作 = resultset.getString(1);
String 姓名 = resultset.getString(2);
String 年龄 = resultset.getString(3);
System.out.println(工作+','+姓名+','+年龄);
}
resultset.close();
statement.close();
collection.close();
}
else
{
System.out.println("collection error");
}
}
}
JDBC-获取数据库数据(查询)
最新推荐文章于 2022-10-07 22:40:48 发布