表的结构
CREATE TABLE `xiaoshoudan` (
`xiaoshoudanhao` varchar(255) NOT NULL,
`date` date default NULL,
`kehu_ID` int(11) default NULL,
`user_ID` int(11) default NULL,
`num` int(11) NOT NULL default '1',
`totalPrice` float default NULL,
PRIMARY KEY (`xiaoshoudanhao`),
KEY `FK77BCFE97148826CC` (`kehu_ID`),
KEY `FK77BCFE973D43702C` (`user_ID`),
CONSTRAINT `FK77BCFE97148826CC` FOREIGN KEY (`kehu_ID`) REFERENCES `kehu` (`ID`),
CONSTRAINT `FK77BCFE973D43702C` FOREIGN KEY (`user_ID`) REFERENCES `user` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
从数据库查询一个时间段的记录代码
//按时间段查询public ResultSet getByShiJianDuan(String dateFirst,String dateLast){conn=new GetConn().getConn();
String sql="select xiaoshoudan.*, xiaoshoudan_shangping.* from xiaoshoudan,xiaoshoudan_shangping where " +
"XiaoShouDan_xiaoshoudanhao=xiaoshoudanhao and date between SELECT DATE_SUB('"+dateFirst+"', INTERVAL 1 DAY) and SELECT DATE_SUB('"+dateLast+"', INTERVAL 1 DAY) ";
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}dateFirst dateLast 是一个日期型的字符串,比如“2008-02-13”这种形式的,要怎么改上面的sql语句才能得到正确的结果
希望知道的人帮我解决一下
CREATE TABLE `xiaoshoudan` (
`xiaoshoudanhao` varchar(255) NOT NULL,
`date` date default NULL,
`kehu_ID` int(11) default NULL,
`user_ID` int(11) default NULL,
`num` int(11) NOT NULL default '1',
`totalPrice` float default NULL,
PRIMARY KEY (`xiaoshoudanhao`),
KEY `FK77BCFE97148826CC` (`kehu_ID`),
KEY `FK77BCFE973D43702C` (`user_ID`),
CONSTRAINT `FK77BCFE97148826CC` FOREIGN KEY (`kehu_ID`) REFERENCES `kehu` (`ID`),
CONSTRAINT `FK77BCFE973D43702C` FOREIGN KEY (`user_ID`) REFERENCES `user` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
从数据库查询一个时间段的记录代码
//按时间段查询public ResultSet getByShiJianDuan(String dateFirst,String dateLast){conn=new GetConn().getConn();
String sql="select xiaoshoudan.*, xiaoshoudan_shangping.* from xiaoshoudan,xiaoshoudan_shangping where " +
"XiaoShouDan_xiaoshoudanhao=xiaoshoudanhao and date between SELECT DATE_SUB('"+dateFirst+"', INTERVAL 1 DAY) and SELECT DATE_SUB('"+dateLast+"', INTERVAL 1 DAY) ";
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}dateFirst dateLast 是一个日期型的字符串,比如“2008-02-13”这种形式的,要怎么改上面的sql语句才能得到正确的结果
希望知道的人帮我解决一下
解决方案 »
- mysql 索引优先级规则
- 电脑开机后,连接数据库发生错误,但关机之前还好好地????
- 2G多的表,我想新增一个字段,可是很慢,执行不了.请问怎么办?
- 求在XP下怎样做Postgresql的数据备份?紧急求助。。
- MySQL中update操作的影响行数row_count问题
- mysql启动的问题,没人知道吗
- MYSQL5.6启动错误Can't start server: Bind on TCP/IP port: No such file or directory
- cst格式的时间如何转换为普通的yyyy-MM-dd格式的时间啊
- mysql为何报syntax error
- mysql中关于check约束撤销的问题
- 求解:关于全索引扫描和全表扫描的疑问
- mysql复习时乱码再现!
String sql="select xiaoshoudan.*, xiaoshoudan_shangping.* from xiaoshoudan,xiaoshoudan_shangping where " +
"XiaoShouDan_xiaoshoudanhao=xiaoshoudanhao and date between DATE_SUB('"+dateFirst+"', INTERVAL 1 DAY) and DATE_SUB('"+dateLast+"', INTERVAL 1 DAY) ";