Connection conn =DriverManager.getConnection("jdbc:sql://localhost:1433","sa","123456")
Statement stmt=conn.createStatement();ResultSet rs=stmt.executeQuery("SELECT * FROM master")while (rs.next())
{
String name=rs.getString ("name");
System.out.println("Name:"+name);
}
请问: 1.Statement stmt=conn.createStatement();的作用是什么?
2.while (rs.next())什么意思?
Statement stmt=conn.createStatement();ResultSet rs=stmt.executeQuery("SELECT * FROM master")while (rs.next())
{
String name=rs.getString ("name");
System.out.println("Name:"+name);
}
请问: 1.Statement stmt=conn.createStatement();的作用是什么?
2.while (rs.next())什么意思?
2.简单地理解就是当rs里存在下一条记录,作用是从数据库中得到多行数据,循环遍历出来貌似这个问题应该到java版去问
创建连接
2.while (rs.next())什么意思?
如果读到下一条数据,开始读数据