文章标题

最新推荐文章于 2020-12-11 06:06:12 发布

原创最新推荐文章于 2020-12-11 06:06:12 发布 · 182 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

作业专区

Java 编程题

package demo;

public class Java4 {
    public static void main(String[] args) {   
        answer();  
    }  
   public static void answer(){  
       float distance=100;float h=0;float s=0;  
       for(int i=1;i<=10;i++){  
           s+=distance+distance/2;  
           distance=distance/2;  
       }  
       s=s-distance;  
       h=distance;  
       System.out.println("第10次落地时，经过："+s+"m");  
       System.out.println("第10次反弹： "+h+"m");  
   }  
}

MySQL 编程题

/*
Navicat MySQL Data Transfer

Source Server         : java96
Source Server Version : 50556
Source Host           : localhost:3306
Source Database       : 10.31

Target Server Type    : MYSQL
Target Server Version : 50556
File Encoding         : 65001

Date: 2017-10-31 23:25:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_student_score
-- ----------------------------
DROP TABLE IF EXISTS `t_student_score`;
CREATE TABLE `t_student_score` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `
studentname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `course` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  ` score` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of t_student_score
-- ----------------------------
INSERT INTO `t_student_score` VALUES ('1', '张三', '语文', '81');
INSERT INTO `t_student_score` VALUES ('2', '张三  ', '    数学', '75');
INSERT INTO `t_student_score` VALUES ('3', '李四', '  语文', '76');
INSERT INTO `t_student_score` VALUES ('4', '李四', '数学', '90');
INSERT INTO `t_student_score` VALUES ('5', '王五', '语文', '81');
INSERT INTO `t_student_score` VALUES ('6', '王五', '数学', '100');
INSERT INTO `t_student_score` VALUES ('7', '王五', '英语', '90');
--  用一条 SQL 语句，查询出每门课都大于 80 分的学生姓名
 SELECT * FROM t_student_score
 WHERE id IN
 (SELECT id FROM t_student_score
  WHERE 'studentname' = 'score'>='80')