数据库本周本月上月当天查询代码
来源:互联网 发布:专业地图软件 编辑:程序博客网 时间:2024/06/04 22:07
//查询上月的数据记录
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 ();
}
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 ();
}
- 数据库本周本月上月当天查询代码
- mysql查询当天、本周、上周、本月、上月信息
- mysql查询当天、本周、本月、上月的数据
- 【数据库SQL】查询本周本月日期或者上月日期
- mysql 查询当天、昨天、本周、上周、本月、上月、今年、去年数据
- mysql 查询当天、昨天、本周、上周、本月、上月、今年、去年数据
- 求当天,昨天,本周,上周,本月,上月的函数
- sql时间查询上周 本周 上月 本月
- Sql 查询当天、本周、本月记录
- SQL 查询当天,本月,本周的记录
- SQL 查询当天,本月,本周的记录
- Sql 查询当天、本周、本月记录
- Sql 查询当天、本周、本月记录
- SQL 查询当天,本月,本周的记录
- Sql 查询当天、本周、本月记录
- Sql 查询当天、本周、本月记录
- Sql 查询当天、本周、本月记录
- SQL 查询当天,本月,本周的记录
- Qt:支持鼠标拖动来移动内容的窗口
- zTree【部分函数和属性介绍】
- 图像处理与计算机视觉基础,经典以及最近发展
- 编写程序,从键盘输入各位职工的工资数据,存入磁盘文件Salary.dat中,然后从该文件读出职工的工资数据,并计算输出每位职工的实发工资。实发工资的计算方法如下:实发工资=基本工资+加班工奖金-扣除
- Harris角点检测及实现
- 数据库本周本月上月当天查询代码
- Java 关于垃圾回收的一些编程建议
- ModelSim打开已建立过的工程
- easyUI datagrid中combobox默认选中问题
- Json概述以及python对json的相关操作
- php识别电脑还是手机访问网站
- 富文本编辑器
- ORA-01102: cannot mount database in EXCLUSIVE mode的解决办法
- 冒泡排序Bubble sort