1.HTML添加信息页面
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加</title>
<style>
#div1{
width:1000px;
height:400px;
background-color:pink;
box-sizing:border-box;
padding-left:300px;
margin:0 auto;
}
<script src="../js/jquery-2.1.1.js"></script>
<script>
//初始化科室下拉列表
function initDept(){
var select = $("#keshi");
$.ajax({
url:"/hospital/GetAllDeptsServlet",
type:"get",
dataType:"json",
success:function(ary){
//for循环结束后会把所有的科室名字通过text()显示在下拉列表上，
//同时给每一个option元素绑定对应的val()值
for(var i=0; i<ary.length; i++){
var option = $("<option class=op></option>");
//把获取到的科室的编号通过val()赋值到对应的下拉元素上
option.val(ary[i].deptno);
//把获取到的科室名字通过text()文本显示在下拉列表上
option.text(ary[i].dname);
//把每一个下拉列表元素拼接到父元素上。【注意：select不是表单标签】
select.append(option);
}
}
});
}
//声明一个全局时间变量，在页面加载完毕后存放通过jQuery获取到的时间
//并把获取到的时间赋值到时间文本框中
var dates = "";
function add(){
var pname=$("#name").val();
var keshi=$("#keshi").val();
var leixing=$("#leixing").val();
var zhengzhuang = $("#state").val();
$.ajax({
url:"/hospital/AddCasesList?name="+pname+"&keshi="+keshi+"&leixing="+leixing+"&state="+zhengzhuang+"&time="+dates,
type:"post",
dataType:"text",
success:function(result){
if(result=="true"){
alert("添加成功");
}else{
alert("添加失败");
}
}
});
}
$(function(){
initDept();
var myDate = new Date;
var year = myDate.getFullYear();
var month = myDate.getMonth()+1;
var day = myDate.getDate();
dates= year+"-"+month+"-"+day;
$("#time").val(dates);
});
</script>
</head>
<body>
<div id="div1">
<form id="add" action="">
<p>姓名：<input type="text" name="name" id="name"/>
科室：<select id="keshi"></select></p>
<p>
类型：<select id="leixing"><option>门诊</option><option>专家</option></select>
症状：<input type="text" name="state" id="state"/>
日期：<input type="text" name="time" id="time"/>
</p>
<p> <input type="button" value="添加" onclick="add()"/></p>
</form>
</div>
<div id="di2" title="双击关闭" onclick="show(this)"></div>
</body>
</html>
2.Dao
public int addCasesList(Cases cases) {
String sql = "insert into cases(cdept,cname,cstate,ckind,ctime) values(?,?,?,?,?)";
List<Object> para = new ArrayList<Object>();
para.add(cases.getCdept());
para.add(cases.getCname());
para.add(cases.getCstate());
para.add(cases.getCkind());
para.add(cases.getCtime());
int result = hDbUtil.executeOper(sql, para);
return result;
}
3.Service
public boolean addCasesList(Cases cases) {
int a = cDao.addCasesList(cases);
if (a==1) {
return true;
}else {
return false;
}
}
4.Servlet
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//获取前台数据
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String keshi = request.getParameter("keshi");
String leixing = request.getParameter("leixing");
String state = request.getParameter("state");
String time = request.getParameter("time");
Cases cases = new Cases();
cases.setCdept(keshi);
cases.setCname(name);
cases.setCkind(leixing);
cases.setCstate(state);
cases.setCtime(time);
CasesService cs = new CasesService();
boolean result = cs.addCasesList(cases);
PrintWriter writer = response.getWriter();
writer.print(result);
}
