資源簡介
javaweb下的人才招聘網站,設計簡約,適合畢業設計使用!
代碼片段和文件信息
package?com.bwm.db;
import?java.sql.*;
public?class?Conn?{
????private?static?Connection?con;
????private?Statement?stmt;
????private?ResultSet?rs;
????private?static?final?String?drivername?=
????????“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
????private?static?final?String?url?=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=talentTable;user=sa;password=sa;“;
????
????//創建連接對象
????public?static?synchronized?Connection?getCon()?throws?Exception?{
????????try?{
????????????Class.forName(drivername);//反射機制
????????????con?=?DriverManager.getConnection(url);
????????????return?con;
????????}?catch?(SQLException?e)?{
????????????System.err.println(e.getMessage());
????????????throw?e;
????????}
????}
????
????
????public?Statement?getStmtread()?{
????????try?{
????????????con?=?getCon();//獲取數據庫連接
???????????//statement:?數據庫結果集的數據表,通過執行查詢數據庫的語句生成
????????????stmt?=?con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE//設置為可滾動的,CONCUR_READ_ONLY常量指示不可以更新的?ResultSet?對象的并發模式
???????????????????????????????????????ResultSet.CONCUR_READ_ONLY);
????????????return?stmt;
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????return?null;
????}
????//獲取結果集
????public?ResultSet?getRs(String?sql)?{
????????try?{
????????????stmt?=?getStmtread();
????????????rs?=?stmt.executeQuery(sql);//執行查詢數據庫的語句
????????????return?rs;
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????return?null;
????}
????public?Statement?getStmt()?{
????????try?{
????????????con?=?getCon();
????????????stmt?=?con.createStatement();//Statement?對象執行不帶參數的?SQL?語句
????????????return?stmt;
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????return?null;
????}
????public?synchronized?void?close()?{
????????try?{
????????????if?(rs?!=?null)?{
????????????????rs.close();
????????????????rs?=?null;
????????????}
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????try?{
????????????if?(stmt?!=?null)?{
????????????????stmt.close();
????????????????stmt?=?null;
????????????}
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????try?{
????????????if?(con?!=?null)?{
????????????????con.close();
????????????????con?=?null;
????????????}
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1175??2010-05-24?18:09??TradZhaopinProject\.classpath
?????文件????????346??2010-05-26?19:18??TradZhaopinProject\.myme
?????文件???????1242??2010-05-24?18:34??TradZhaopinProject\.project
?????文件???????1040??2010-05-24?18:35??TradZhaopinProject\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件???????2841??2010-05-18?23:53??TradZhaopinProject\src\com\bwm\db\Conn.java
?????文件???????2492??2010-05-10?21:04??TradZhaopinProject\src\com\bwm\db\Data.java
?????文件???????1144??2010-04-15?00:41??TradZhaopinProject\src\com\bwm\page\Show.java
?????文件???????1281??2010-05-10?21:04??TradZhaopinProject\src\com\bwm\string\Str.java
?????文件????????656??2010-05-10?21:04??TradZhaopinProject\src\com\bwm\time\Time.java
?????文件???????1471??2010-04-15?00:41??TradZhaopinProject\src\job\Cjob.java
?????文件???????1474??2010-04-15?00:41??TradZhaopinProject\src\job\Company.java
?????文件???????1471??2010-04-15?00:41??TradZhaopinProject\src\job\Sjob.java
?????文件???????2016??2010-04-15?00:41??TradZhaopinProject\src\job\Student.java
?????文件???????6074??2010-05-19?13:25??TradZhaopinProject\WebRoot\3761653_141325057886_1.jpg
?????文件????????702??2010-05-28?18:40??TradZhaopinProject\WebRoot\admin\admin.jsp
?????文件???????2090??2010-05-28?18:42??TradZhaopinProject\WebRoot\admin\afli
?????文件???????1950??2010-05-28?18:41??TradZhaopinProject\WebRoot\admin\cjob.jsp
?????文件???????1887??2010-05-28?16:36??TradZhaopinProject\WebRoot\admin\company.jsp
?????文件????????450??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dcjob.jsp
?????文件????????453??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dcompany.jsp
?????文件????????445??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dfli
?????文件????????450??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dsjob.jsp
?????文件????????453??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dstudent.jsp
?????文件???????2199??2010-05-28?18:42??TradZhaopinProject\WebRoot\admin\fli
?????文件????????164??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\include.jsp
?????文件???????1223??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\index\index.htm
?????文件???????2366??2010-05-28?19:51??TradZhaopinProject\WebRoot\admin\index.htm
?????文件????????565??2010-05-28?18:00??TradZhaopinProject\WebRoot\admin\login.htm
?????文件????????811??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\login.jsp
?????文件????????773??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\mfli
............此處省略367個文件信息
- 上一篇:Scratch3足球小子
- 下一篇:組態王7.5授權
評論
共有 條評論