91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1.18MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-08-29
  • 語言: 其他
  • 標簽: Java??學生管理??

資源簡介

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

資源截圖

代碼片段和文件信息

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.xml

?????文件?????????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\meta-INF\MANIFEST.MF

?????文件???????2989??2015-10-31?15:22??studentweb\WebContent\student\add.html

?????文件???????1662??2015-10-31?14:15??studentweb\WebContent\student\detail.html

............此處省略49個文件信息

評論

共有 條評論