資源簡介
適用于學生作為畢業設計參考案例,總之,很好很好很好
代碼片段和文件信息
package?com.student.Dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?com.student.model.classManageModel;
import?com.student.util.StringUtil;
public?class?classManageDao?{
public?int?classAdd(Connection?conclassManageModel?cManageModel)throws?Exception{
String?sql?=?“insert?into?t_classmanage?values(null???)“;
PreparedStatement?pstmt?=?con.prepareStatement(sql);
pstmt.setString(1?cManageModel.getClassName());
pstmt.setString(2cManageModel.getDescription());
pstmt.setInt(3?cManageModel.getGradeId());
return?pstmt.executeUpdate();
}
public?ResultSet?classList(Connection?conclassManageModel?cManageModel)throws?Exception{
StringBuffer?sb?=?new?StringBuffer(“select?*?from?t_classmanage“);
if(StringUtil.isNotEmpty(cManageModel.getClassName())){
sb.append(“?and?className?like?‘%“+cManageModel.getClassName()+“%‘“);
}
PreparedStatement?pstmt?=?con.prepareStatement(sb.toString().replaceFirst(“and“?“where“));
return?pstmt.executeQuery();
}
public?ResultSet?classManage(Connection?conclassManageModel?cManageModel)throws?Exception{
StringBuffer?sb?=?new?StringBuffer(“select?*?from?t_classmanage“);
if(StringUtil.isNotEmpty(cManageModel.getClassName())){
sb.append(“?and?className?like?‘%“+cManageModel.getClassName()+“%‘“);
}
if(StringUtil.isNotEmpty(cManageModel.getDescription())){
sb.append(“?and?Desc?like?‘%“+cManageModel.getDescription()+“%‘“);
}
if(cManageModel.getGradeId()!=-1){
sb.append(“?and?gradeId?like?‘%“+cManageModel.getGradeId()+“%‘“);
}
PreparedStatement?pstmt?=?con.prepareStatement(sb.toString().replaceFirst(“and“?“where“));
return?pstmt.executeQuery();
}
public?int?classUpdate(Connection?conclassManageModel?cManageModel)throws?Exception{
String?sql?=?“update?t_classmanage?set?className=?description=??where?id=?“;
PreparedStatement?pstmt?=?con.prepareStatement(sql);
pstmt.setString(1?cManageModel.getClassName());
pstmt.setString(2?cManageModel.getDescription());
pstmt.setInt(3?cManageModel.getId());
System.out.println(cManageModel.getClassName()+“.....“);
System.out.println(cManageModel.getDescription()+“.....“);
System.out.println(cManageModel.getId()+“.....“);
return?pstmt.executeUpdate();
}
public?int?classDelete(Connection?conint?id)throws?Exception{
String?sql?=?“delete?from?t_classmanage?where?id=?“;
PreparedStatement?pstmt?=?con.prepareStatement(sql);
pstmt.setInt(1?id);
return?pstmt.executeUpdate();
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-10-21?12:41??學生管理系統\
?????目錄???????????0??2014-10-21?12:23??學生管理系統\image\
?????文件???????21896??2014-10-21?09:32??學生管理系統\image\user登陸成功.png
?????文件???????57545??2014-10-21?09:51??學生管理系統\image\信息添加.png
?????文件???????43759??2014-10-21?09:50??學生管理系統\image\學生信息管理.png
?????文件???????14448??2014-10-21?09:47??學生管理系統\image\年級信息管理.png
?????文件????????9993??2014-10-21?12:20??學生管理系統\image\數據庫.png
?????文件???????14273??2014-10-21?09:48??學生管理系統\image\班級信息管理.png
?????目錄???????????0??2014-10-21?12:41??學生管理系統\StudentManage\
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\
?????文件?????????504??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\.classpath
?????文件?????????389??2014-09-28?16:54??學生管理系統\StudentManage\StudentManage\.project
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\.settings\
?????文件?????????629??2014-09-28?16:54??學生管理系統\StudentManage\StudentManage\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\bin\
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\bin\com\
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\bin\com\student\
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\bin\com\student\Dao\
?????文件????????3339??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\Dao\classManageDao.class
?????文件????????2545??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\Dao\gradeManageDao.class
?????文件????????1556??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\Dao\ManageDao.class
?????文件????????3481??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\Dao\studentAddModel.class
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\bin\com\student\model\
?????文件????????1779??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\model\classManageModel.class
?????文件????????1460??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\model\gradeModel.class
?????文件????????1092??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\model\ManageModel.class
?????文件????????2624??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\model\studentAdd.class
?????目錄???????????0??2014-10-21?12:22??學生管理系統\StudentManage\StudentManage\bin\com\student\util\
?????文件????????1035??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\util\DateUtil.class
?????文件????????1735??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\util\dbUtil.class
?????文件?????????631??2014-10-21?09:21??學生管理系統\StudentManage\StudentManage\bin\com\student\util\StringUtil.class
............此處省略130個文件信息
評論
共有 條評論