我想在控制台打印我的结果集。。。。(急)

Question

System.out.print("province\tcity\ttotal\n");
while(rs.next()) {
System.out.println(rs.getString(1)+rs.getString(2)+rs.getInt(3));
}

Answer 1

前面的不写了？？倒
import java.sql.*;public class MySqlTestJdbc
{
static{
try
{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("注册成功");
}
catch (Exception e)
{
e.printStackTrace();
}
}
public static void main (String[] args)throws Exception{
 try
 {
  Connection conn1 = DriverManager.getConnection("jdbc:mysql://localhost/zlp","zlp","");
System.out.println("连接成功");
//conn1.close();
        Statement stmt = conn1.createStatement();
        //stmt.execute("insert into employees values('003','legend','Office2')");
System.out.println("插入成功！");
        ResultSet rs1 = stmt.executeQuery("select * from employees");
        while(rs1.next()){
            String id = rs1.getString(1);
            String name = rs1.getString(2);
            String department = rs1.getString(3);
            System.out.println(id + " " + name + " " + department);
        }
        conn1.close();
        
 }
 catch (Exception ee)
 {
ee.printStackTrace();
 }
}
}
以前上课写的例子看看吧