servlet層
package com.ls.servlet;
import com.ls.bean.result;
import com.ls.bean.sender;
import com.ls.bean.user;
import com.ls.service.ExpressService;
import com.ls.service.Impl.ExpressServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/express/*")
public class ExpressServlet extends BaseServlet {
private ExpressService es = new ExpressServiceImpl();
private result rs = new result();
public void sender(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sname = request.getParameter("sname");
String price = request.getParameter("price");
String phone = request.getParameter("phone");
sender send = new sender();
System.out.println(send);
send.setSname(sname);
send.setPrice(price);
send.setPhone(phone);
boolean b = es.send(send);
if (b){
rs.setFlag(true);
System.out.println("用戶資訊添加成功");
}else {
rs.setFlag(false);
System.out.println("用戶資訊添加失敗");
}
writeValue(rs,response);
}
}
dao層
package com.ls.dao.Impl;
import com.ls.bean.sender;
import com.ls.dao.ExpressDao;
import com.ls.util.DruidUtil;
import org.springframework.jdbc.core.JdbcTemplate;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class ExpressDaoImpl implements ExpressDao {
private JdbcTemplate tl = new JdbcTemplate(DruidUtil.getDataSource());
@Override
public boolean send(sender s) {
Connection conn = null;
PreparedStatement psmt = null;
String sql = "insert into sender values (null,?,?,?)";
try {
conn = DruidUtil.getConnection();
psmt = conn.prepareStatement(sql);
psmt.setString(1,s.getSname());
psmt.setString(2,s.getPrice());
psmt.setString(3,s.getPhone());
psmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
DruidUtil.close(conn,psmt);
}
return false;
}
}
uj5u.com熱心網友回復：
檢查一下變數型別與欄位型別是否一致uj5u.com熱心網友回復：
String sql = "insert into sender values (null,?,?,?)";insert into sender(sname,price,phone) values(?,?,?)
可以把id設成自增，試一下
uj5u.com熱心網友回復：
您跟蹤一下 sql傳送里面是否帶了值。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/33219.html
標籤：MySQL
上一篇：Access資料庫