package a;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Select1 {
 public static void main(String[] args) throws Exception{
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/School","root","root");
  Statement stat = conn.createStatement();
  String sql =
"SELECT STUNO,STUNAME FROM T_STUDENT WHERE STUSEX='man'";
  ResultSet rs = stat.executeQuery(sql);
  while(rs.next()){
   String stuno = rs.getString("STUNO");
   String stuname = rs.getString("STUNAME");
   System.out.println(stuno + "  " + stuname);
  }
  stat.close();
  conn.close();
 }
}