京东2019校招数据开发工程师笔试题

CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `created_time` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_com1` (`name`,`age`,`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表'

union X{
    int x
    char y[4] 
}

#include <iostream>
using namespace std

class D{
    int d
public: 
    D(int x=1):d(x){
    }  ~D(){
        cout<<"D"
    }
}

int main(){ 
    D d[]={_____________}
    D* p=new D[2]
    delete[]p
    return 0 
}

#include <iostream>
using namespace std
_______________________
void One(float one)
{ cout<<"1"<<endl    }
void Two(float two)
{ cout<<"2"<<endl }
void Three(float three)
{ cout<<"3"<<endl }
int main() 
{  float i=1,j=2,k=3
   function = One
   function(i)
   function= Two
   function(j)
   function = Three
   function(k)}

#include<iostream> 
using namespace std
class complex {
public:
    int real
    int imag
    complex(int r=0,int i=0) {
        real=r
        imag=i
    }
_________________________________
}
complex add(complex &a,complex & b) {
    int r=a.real+b.real
    int i=a.imag+b.imag
    return complex(r,i)}  

int  main( ) {
    complex x(1,2),y(3,4),z
    z=add(x,y)    
    cout<<z.real<<"+"<<z.imag<<"i"<<endl
}  

#include<iostream> 
#include<fstream> 
#include<string> 
using namespace std 
int main()  {
    ofstream File1("text.txt")  
    string d("20160314") 
    string y=d.substr(0,4) 
    int k=d.find("2")
    int i=d.find("3") 
    string m=d.substr(k+2,i-k) 
    string dd=d.substr(i+1,2) 
    string n=dd+m+y 
    File1<<n<<endl 
    File1.close() 
}                                            

#include <iostream> 
using namespace std 
template <class T>
void S(T &x, T &y)
{ T temp
   temp = x
   x = y
   y = temp}
template <class T>
void SS(T A[], int n)
{ int min    
  int i, j
  for (i=0 i<n-1 i++) 
  { min=i    
    for (j=_____ j<n j++) 
     if (A[j]<A[min]) min=j
    S(A[i], A[min])
  }   }

#include <iostream>
using namespace std
class shape 
{public:  
        virtual int area()=0
}  
class rectangle:public shape 
{public: 
        int a, b  
        void setLength (int x, int y) {a=xb=y} 
        int area() {return a*b} 
}

int main()   
{
    char c, s[20]
    strcpy(s, "Hello,World")
    printf("s[]=%6.9s\n", s)
    return 0
}

struct Student {
    int num
    char name[7]   
    short age
    char sex
} student1
int sz = sizeof(student1)

int main() {
 vector<int> vInt(1)
 cout << vInt[1]
 cout << vInt.at(1)
 return 0
}

int main() {
 vector<int> vInt
 for (int i=0 i<5 ++i)
 {
  vInt.push_back(i)
  cout << vInt.capacity() << " "
 }
 vector<int> vTmp(vInt)
 cout << vTmp.capacity() << "\n"
 return 0
}

int main() {
 int a(1), b(3), c(2)
 
 while (a < b < c)
 {
  ++a
  --b
  --c
 }
 cout << a << " " << b << " " << c << "\n"
 return 0
}

import re
m = re.search('[0-9]','a1b2c3d4')
print(m.group(0))

import datetime
t1 = datetime.datetime(2017,10,10,21,40)
t2 = datetime.datetime(2017,10,8,23,40)
tt1 = datetime.timedelta(seconds = 1200)
tt2 = datetime.timedelta(weeks = 3)
print(t1 - t2)

#!/bin/bash
aa='Hello World !'