📄 dayincome.java
字号:
package dayincome;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.ConnOracle;
public class Dayincome extends HttpServlet{
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
res.setContentType("text/html;charset=GBK");
req.setCharacterEncoding("GBK");
PrintWriter out = res.getWriter();
db.ConnOracle conn = new db.ConnOracle();
java.sql.Date d = new java.sql.Date(new java.util.Date().getTime());
//java.util.Date d = new java.util.Date();
//String s = d.toString();
//System.out.println(s);
String sql1 = "select day from table_dayincome where day = to_date('"+d+"','YYYY-MM-DD') and dept_id = 1002";
//System.out.println(sql1);
ResultSet rs1 = conn.query(sql1);
try{
//ResultSet rs2 ;
if(!rs1.next()){
String sql = "insert into table_dayincome values(to_date('"+d+"','YYYY-MM-DD'),1002,"+req.getParameter("dayincome")+",to_date('"+d+"','YYYY-MM-DD'))";
conn.update(sql);
//System.out.println(sql);
out.println("<html><head></head><body bgcolor='#0099FF'><h1 align='center'>提交成功!</h1><p><a href='operator.jsp'>返回</a></p><hr>");
out.println("<p><h2 align='center'>今日销售额为："+req.getParameter("dayincome")+"元<h2></p>");
out.println("</body></html>");
}else{
out.println("<html><head></head><body bgcolor='#0099FF'><h1 align='center'>今日销售额已提交！</h1><p><a href='operator.jsp'>返回</a></p><hr>");
out.println("<p><h2 align='center'>当天收入只能提交一次！</h2></p></body></html>");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException{
doGet(req,res);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -