資源簡介
一個很全面的學生管理系統登錄注冊增刪改查,全部跟數據庫關聯

代碼片段和文件信息
package?gem.student.dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;
import?gem.student.entity.Student;
import?gem.student.util.DBConnection;
//方法:訪問數據庫中的數據,讀、寫
public?class?StudentDao?{
//?要寫哪些方法,設計,實現
//?保存學生數據的方法
//?OR-MappingO:Student對象,
public?void?save(Student?student)?{
//?try-catch-finally
Connection?conn?=?null;
PreparedStatement?prep?=?null;
try?{
//?1、聯接
conn?=?DBConnection.getDBConnection();
//?2、SQL
String?sql?=?“insert?into?student(namesnopasswordsexpolitybirthdaybrief)“
+?“values(???????)“;
//?3
prep?=?conn.prepareStatement(sql);
//?4:設置參數值,setXxx(1值)?getXxx(““)
prep.setString(1?student.getName());
prep.setString(2?student.getSno());
prep.setString(3?student.getPwd());
prep.setInt(4?student.getSex());
prep.setInt(5?student.getPolity());
//?student.getBirthday()的日期類型是java.util.Date
//?setDate中的方法的第二個參數要求的日期類型是java.sql.Date
prep.setDate(6?new?java.sql.Date(student.getBirthday().getTime()));
prep.setString(7?student.getBrief());
//?5、執行
prep.executeUpdate();
}?catch?(ClassNotFoundException?|?SQLException?e)?{
//?處理異常:轉換為你的應用程序的異常再拋出
//?異常信息寫到日志文件中
//?編譯期異常,運行期異常
throw?new?RuntimeException(e);
}
//?6、close
finally?{
try?{
if?(prep?!=?null)
prep.close();
if?(conn?!=?null)
conn.close();
}?catch?(SQLException?e)?{
throw?new?RuntimeException(e);
}
}
}
//?id不變修改方法
public?void?update(Student?student)?{
}
//?刪除調用delete(new?int[]{34363839});
public?void?delete(String[]?ids)?{
Connection?conn?=?null;
PreparedStatement?prep?=?null;
try?{
//?1
conn?=?DBConnection.getDBConnection();
//?2
String?sql?=?“delete??from?student?where?id=?“;
//?3
prep?=?conn.prepareStatement(sql);
//?4
for(String?id:ids)?{
prep.setInt(1?Integer.parseInt(id));
prep.executeUpdate();
}
//?5
//?7
}?catch?(Exception?e)?{
throw?new?RuntimeException(e);
}?finally?{
try?{
if(prep!=null)?{
prep.close();
}
if(conn?!=?null)?{
conn.close();
}
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
throw?new?RuntimeException(e);
}
}
}
//?根據學號來獲得學生對象如果學號不存在,返回null
public?Student?getStudentBySno(String?sno)?{
Connection?conn?=?null;
PreparedStatement?prep?=?null;
ResultSet?rs?=?null;
Student?s?=?null;
try?{
//?1
conn?=?DBConnection.getDBConnection();
//?2
String?sql?=?“select?*?from?student?where?sno=?“;
//?3
prep?=?conn.prepareStatement(sql);
//?4
prep.setString(1?sno);
//?5
rs?=?prep.executeQuery();//?從數據庫取到一條記錄
//?6:處理查詢結果
//?將這條記錄中的數據?==?》?s對象中
if?(
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1069??2015-11-05?10:26??studentweb\.classpath
?????文件???????1043??2015-10-31?13:59??studentweb\.project
?????文件????????503??2015-10-31?13:59??studentweb\.settings\.jsdtscope
?????文件????????364??2015-10-31?13:59??studentweb\.settings\org.eclipse.jdt.core.prefs
?????文件????????482??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.common.component
?????文件????????345??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????7748??2015-11-09?10:48??studentweb\build\classes\gem\student\dao\StudentDao.class
?????文件???????2050??2015-11-09?09:29??studentweb\build\classes\gem\student\dao\test\StudentDaoTest.class
?????文件???????2710??2015-11-05?10:27??studentweb\build\classes\gem\student\entity\Student.class
?????文件???????2193??2015-11-09?11:42??studentweb\build\classes\gem\student\service\StudentService.class
?????文件???????1205??2015-11-05?10:27??studentweb\build\classes\gem\student\util\DBConnection.class
?????文件???????2963??2015-11-05?10:27??studentweb\build\classes\gem\student\web\AddStudentServlet.class
?????文件???????9038??2015-11-09?10:48??studentweb\src\gem\student\dao\StudentDao.java
?????文件????????857??2015-11-09?09:29??studentweb\src\gem\student\dao\test\StudentDaoTest.java
?????文件???????1826??2015-10-21?11:07??studentweb\src\gem\student\entity\Student.java
?????文件???????1632??2015-11-09?11:42??studentweb\src\gem\student\service\StudentService.java
?????文件????????709??2015-10-21?11:10??studentweb\src\gem\student\util\DBConnection.java
?????文件???????2533??2015-11-02?09:12??studentweb\src\gem\student\web\AddStudentServlet.java
?????文件?????????60??2015-10-31?14:15??studentweb\WebContent\common\date\arrow_down.gif
?????文件?????????61??2015-10-31?14:15??studentweb\WebContent\common\date\arrow_up.gif
?????文件???????4206??2015-10-31?14:15??studentweb\WebContent\common\date\date.js
?????文件???????5867??2015-10-31?14:15??studentweb\WebContent\common\date\selectDate.jsp
?????文件???????8192??2015-10-31?14:15??studentweb\WebContent\common\date\Thumbs.db
?????文件???????2223??2015-10-31?14:15??studentweb\WebContent\common\validatecode\generate.jsp
?????文件???????2861??2015-10-31?14:15??studentweb\WebContent\css\demo.css
?????文件?????????39??2015-10-31?13:59??studentweb\WebContent\me
?????文件???????2989??2015-10-31?15:22??studentweb\WebContent\student\add.html
?????文件???????1662??2015-10-31?14:15??studentweb\WebContent\student\detail.html
............此處省略49個文件信息
- 上一篇:fr
amework7使用dome - 下一篇:好友眼鏡行業版破解
評論
共有 條評論