文章标题

来源:互联网 发布:float在c语言中的意思 编辑:程序博客网 时间:2024/06/03 21:58

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 TransferSource Server         : java96Source Server Version : 50556Source Host           : localhost:3306Source Database       : 10.31Target Server Type    : MYSQLTarget Server Version : 50556File Encoding         : 65001Date: 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')
原创粉丝点击