数据库本周本月上月当天查询代码

//查询上月的数据记录
void OnLastMonth()
{
IDataReader reader = mydb.doQuery("select * from mydata where month( 时间) = month( now())-1"); //查询上个月数据查询可以
IDataReader reader1 = mydb.doQuery("select count(*) from mydata where month( 时间) = month( now())-1"); //查询上个月可以
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log ("满足条件的记录总数为  "+num.ToString());
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
Debug.Log ("数据值: "+str[i]);
}
}


mydb.closeSqlConnection ();

}

//查询上周的数据记录
void OnLastWeek()
{
IDataReader reader = mydb.doQuery("select * from mydata where week( 时间) = week( now())-1");//上周数据查询可以
IDataReader reader1 = mydb.doQuery("select count(*) from mydata where week( 时间) = week( now())-1");//查询上周可以
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log ("满足条件的记录总数为  "+num.ToString());
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
Debug.Log ("数据值: "+str[i]);
}
}


mydb.closeSqlConnection ();

}

//查询当天的数据记录
void OnThisDay()
{
IDataReader reader = mydb.doQuery("select * from mydata where date(时间) = curdate()"); //当天数据可以
IDataReader reader1 = mydb.doQuery("select count(*) from mydata where date(时间) = curdate()"); //当天数据可以
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log ("满足条件的记录总数为  "+num.ToString());
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
//Debug.Log ("数据值: "+str[i]);
}
}


mydb.closeSqlConnection ();

}

//查询本周的数据记录
void OnThisWeek()
{
IDataReader reader = mydb.doQuery("select * from mydata where week( 时间) = week( now())");
IDataReader reader1 = mydb.doQuery("select count(*) from mydata where week( 时间) = week( now())");
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log ("满足条件的记录总数为  "+num.ToString());
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
Debug.Log ("数据值: "+str[i]);
}
}


mydb.closeSqlConnection ();

}

//查询本月的数据记录
void OnThisMonth()
{
IDataReader reader = mydb.doQuery("select * from mydata where month( 时间) = month( now())");//当月数据可以
IDataReader reader1 = mydb.doQuery("select count(*) from mydata where month( 时间) = month( now())");//当月数据可以
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log ("满足条件的记录总数为  "+num.ToString());
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
Debug.Log ("数据值: "+str[i]);
}
}

mydb.closeSqlConnection ();

}



//实现按照时间段查询
void Onselect()
{
startTime = inputStart.text;
endTime = inputEnd.text;
Debug.Log ("开始时间"+startTime);
Debug.Log ("结束时间"+endTime);
IDataReader reader = mydb.doQuery("select *   from mydata where 时间 BETWEEN '"+startTime+" 00:00:00' and '"+endTime+" 23:59:59'");
IDataReader reader1 = mydb.doQuery("select count(*)   from mydata where 时间 BETWEEN '"+startTime+" 00:00:00' and '"+endTime+" 23:59:59'");
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log ("满足条件的记录总数为  "+num.ToString());
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
Debug.Log ("数据值: "+str[i]);
}
}

mydb.closeSqlConnection ();
}




//按照日期查询日记录数据
void OnDayQuery()
{
dayTime = dayinput.text;
IDataReader reader = mydb.doQuery(
"select *   from mydata where Year(时间) = " +
"Year(cast('"+dayTime+"'as datetime)) and month(时间) = " +
"month(cast('"+dayTime+"' as datetime)) and day(时间) = " +
"day(cast('"+dayTime+"' as datetime))");

IDataReader reader1 = mydb.doQuery(
"select count(*)   from mydata where Year(时间) = " +
"Year(cast('"+dayTime+"'as datetime)) and month(时间) = " +
"month(cast('"+dayTime+"' as datetime)) and day(时间) = " +
"day(cast('"+dayTime+"' as datetime))");
while(reader1.Read ())
{
num = int.Parse (reader1.GetString (0));
str = new string [num];
}

while(reader.Read())
{
Debug.Log (dayTime);
Debug.Log ("满足条件的记录总数为  "+reader1.GetString (0));
for(int i =0;i<num;i++)
{
str[i]= reader.GetString(2);
Debug.Log ("日数据记录值: "+str[i]);
}
}
mydb.closeSqlConnection ();
}



//按照日期查询日记录平均值
void OnDayMax()
{
dayTime = dayinput.text;
IDataReader reader = mydb.doQuery("select MAX(数据)   from mydata where Year(时间) = " +
"Year(cast('"+dayTime+"'as datetime)) and month(时间) = " +
"month(cast('"+dayTime+"' as datetime)) and day(时间) = " +
"day(cast('"+dayTime+"' as datetime))");


while(reader.Read())
{
Debug.Log (dayTime);
max = float.Parse (reader.GetString (0));
Debug.Log ("日数据记录最大值: "+max.ToString ());
}
mydb.closeSqlConnection ();

}

//按照日期查询日记录最小值
void OnDayMin()
{
dayTime = dayinput.text;
IDataReader reader = mydb.doQuery("select MIN(数据)   from mydata where Year(时间) = " +
"Year(cast('"+dayTime+"'as datetime)) and month(时间) = " +
"month(cast('"+dayTime+"' as datetime)) and day(时间) = " +
"day(cast('"+dayTime+"' as datetime))");


while(reader.Read())
{
Debug.Log (dayTime);
min = float.Parse (reader.GetString (0));
Debug.Log ("日数据记录最小值: "+min.ToString ());
}
mydb.closeSqlConnection ();
}

//按照日期查询日记录最大值
void OnDayAvg()
{
dayTime = dayinput.text;
IDataReader reader = mydb.doQuery("select AVG(数据)   from mydata where Year(时间) = " +
"Year(cast('"+dayTime+"'as datetime)) and month(时间) = " +
"month(cast('"+dayTime+"' as datetime)) and day(时间) = " +
"day(cast('"+dayTime+"' as datetime))");


while(reader.Read())
{
Debug.Log (dayTime);
avg = float.Parse (reader.GetString (0));
Debug.Log ("日数据记录平均值: "+avg.ToString ());
}
mydb.closeSqlConnection ();
}