51,395
社区成员




package com.dao;
import java.util.Map;
public interface OrderDao {
public int addOrder(Map<String, String> map);
}
package com.dao.impl;
import java.util.Map;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.stereotype.Repository;
import com.dao.OrderDao;
@Repository("orderDao")
public class OrderDaoImpl extends JdbcDaoSupport implements OrderDao {
public int addOrder(Map<String, String> map) {
String sql = "insert into demo(phone,product_name,createtime) values(?,?,?)";
String phone = map.get("phone");
String product_name = map.get("product_name");
String ctime = map.get("createtime");
Object[] arges = { phone, product_name, ctime };
return getJdbcTemplate().update(sql, arges);
}
}
package com.service;
import java.util.Map;
public interface OrderService {
public int addOrder(Map<String, String> map);
}
package com.service.impl;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.dao.OrderDao;
import com.service.OrderService;
@Service
public class OrderServiceImpl implements OrderService {
@Autowired
private OrderDao orderDao;
public OrderDao getOrderDao() {
return orderDao;
}
public void setOrderDao(OrderDao orderDao) {
this.orderDao = orderDao;
}
public int addOrder(Map<String, String> map) {
return orderDao.addOrder(map);
}
}
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.ServletInputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONObject;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import com.service.OrderService;
@Controller
@RequestMapping(value = "/order")
public class OrderServlet {
private final static Logger log = Logger.getLogger(OrderServlet.class);
@Autowired
private OrderService orderService;
public OrderService getOrderService() {
return orderService;
}
public void setOrderService(OrderService orderService) {
this.orderService = orderService;
}
@RequestMapping(value = "/synOrder.do", method = { RequestMethod.POST,
RequestMethod.GET }, produces = "application/json;charset=UTF-8")
public String synOrder(HttpServletRequest request,
HttpServletResponse response) throws IOException {
PrintWriter out = response.getWriter();
String responseJson = null;
ServletInputStream in = request.getInputStream();
String str = readLine(in);
// 判断入参是否有数据
JSONObject oj = JSONObject.fromObject(str);
JSONObject json = oj.getJSONObject("json");
String phone = json.get("phone").toString();
String product_name = json.get("product_name").toString();
String createtime = json.get("createtime").toString();
// 判断各个参数是否有值
if (phone == null || product_name == null || createtime == null) {
responseJson = "{result:1,message:必填值不能为空}";
} else {
Map<String, String> result_map = new HashMap<String, String>();
result_map.put("phone", phone);
result_map.put("product_name", product_name);
result_map.put("createtime", createtime);
log.info("接口入参: ");
log.info("params: " + result_map);
// 添加
int result = orderService.addOrder(result_map);
if (result > 0) {
responseJson = "{result:0,message:成功}";
} else {
responseJson = "{result:1, message:必填值不能为空}";
}
}
response.setContentType("text/html;charset=utf-8");
out.println(responseJson);
out.flush();
out.close();
return responseJson;
}
private static String readLine(ServletInputStream in) throws IOException {
byte[] buf = new byte[8 * 1024];
StringBuffer sbuf = new StringBuffer();
int result;
do {
result = in.readLine(buf, 0, buf.length); // does +=
if (result != -1) {
sbuf.append(new String(buf, 0, result, "UTF-8"));
}
} while (result == buf.length); // loop only if the buffer was filled
if (sbuf.length() == 0) {
return null; // nothing read, must be at the end of stream
}
int len = sbuf.length();
if (sbuf.charAt(len - 2) == '\r') {
sbuf.setLength(len - 2); // cut \r\n
} else {
sbuf.setLength(len); // cut \n
}
return sbuf.toString();
}
}
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<!-- 配置数据源 -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=UTF-8"></property>
<property name="username" value=XXXX" />
<property name="password" value="XXXX" />
</bean>
<bean id="jdbctemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<context:component-scan base-package="com">
<context:include-filter type="regex"
expression="com.service.*" />
<context:include-filter type="regex"
expression="com.dao.*" />
<context:include-filter type="regex"
expression="com.servlet.*" />
</context:component-scan>
<mvc:annotation-driven/>
</beans>