基于javaweb+JSP+Servlet医院挂号预约管理系统(管理员、用户)
开发工具:eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
String arrId[] = str.split(","); // 将字符串分割成数组,得到所有复选框的value,即管理员id
for (int i = 0; i < arrId.length; i++) {
System.out.println(arrId[i]);
b = adminService.delete(Integer.valueOf(arrId[i]));
}
} else {
if (adminId != null) {
b = adminService.delete(Integer.valueOf(adminId));
} else {
// 都为空的时候
JOptionPane.showMessageDialog(null, "您还没有选择删除的人");// 跳出去
showList(request, response);
return;
}
}
rs=stmt.executeQuery(sql);
Doctor doc=null;
while(rs.next()){
doc=new Doctor();
doc.setDocId(rs.getInt(1));
doc.setDocName(rs.getString(2));
doc.setDocImg(rs.getString(3));
doc.setMoney(rs.getInt(4));
doc.setDocTime(rs.getDate(5));
doc.setSumCount(rs.getInt(6));
doc.setLessCount(rs.getInt(7));
doc.setDocStatus(rs.getString(8));
doc.setOffId(rs.getInt(9));
int rowsCount=0;
try {
conn=DBConnection.getConnection();
stmt=conn.createStatement();
String sql="";
if(name==null){
sql="select count(*) from register ";
}else{
sql="select count(*) from register where '"+name+"' in (select to_char(order_time,'dd') from dual)";
//sql="select count(*) from register where reg_name like '%"+name+"%' ";
}
rs=stmt.executeQuery(sql);
if(rs.next()){
rowsCount=rs.getInt(1);
}
} catch (SQLException e) {
text-decoration: none;
}
.button {
font-family: "宋体";
font-size: 14px;
height: 37px;
}
html {
overflow-x: auto;
overflow-y: auto;
border: 0;
}

