java--select*

if(...){
}
for(...){
}
for(xx:XX){
}
------
List,Set,Map
List xxx = new ArrayList();
-----------
import java.util.Date
Date xxxx = new Date();
SimpleDateFormat xxx = new SimpleDateFormat("yyyy-MM-dd");
xxx.format(xxxx);
----------------
JDBC:
Class.forname("....");
Connection conn = DriverManager.getConnection(url);
PreparedStatement pst = conn.prepareStatement(sql);
pst.setString(1,"");
pst.setString(2,"");
pst.execute();
ResultSet rs = pst.executeQuery();
while(rs.next()){
rs.getString("sno");
}

rs.close();
pst.close();
conn.close();

转载于:https://www.cnblogs.com/sheying/p/7010629.html