資源簡介
求職網(wǎng)整個網(wǎng)站基于jsp連接數(shù)據(jù)庫開發(fā),實現(xiàn)登陸,修改資料,注冊用戶以及發(fā)布信息和查詢和撤銷發(fā)布信息等功能

代碼片段和文件信息
package?com.bwm.db;
import?java.sql.*;
/**
?*class?explain:Database?connection
?*set?up?name: crazyadept
?*set?up?time: 11/22/2004
?*/
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://127.0.0.1:1433;DatabaseName=db_Job;user=sa;password=;“;
????/**
?????*method?explain:???Get?Connection?Database
?????*modify?time: 12/20/2004
?????*/
????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;
????????}
????}
????/**
?????*output?parameter: in?order?select?in?SQL
?????*modify?time: 12/20/2004
?????*/
????public?Statement?getStmtread()?{
????????try?{
????????????con?=?getCon();
????????????stmt?=?con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE
???????????????????????????????????????ResultSet.CONCUR_READ_ONLY);
????????????return?stmt;
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????return?null;
????}
????/**
?????*output?parameter:?Data
?????*input?parameter:??SQL?select?sentence
?????*modify?time:??????11/29/2004
?????*/
????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;
????}
????/**
?????*output?parameter:?not?in?order?select?in?str?SQL
?????*modify?time:??????11/29/2004
?????*/
????public?Statement?getStmt()?{
????????try?{
????????????con?=?getCon();
????????????stmt?=?con.createStatement();
????????????return?stmt;
????????}?catch?(Exception?e)?{
????????????System.err.println(e.getMessage());
????????????e.printStackTrace();
????????}
????????return?null;
????}
????/**
?????*method?explain:???Close?Database?Connection
?????*modify?time:??????11/29/2004
?????*/
????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();
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????5228??2005-02-04?11:26??Job\index.jsp
?????文件???????1517??2005-02-04?10:39??Job\login.jsp
?????文件???????4966??2005-02-04?11:10??Job\view.jsp
?????文件????????179??2005-03-01?11:39??Job\WEB-INF\web.xm
?????文件?????????91??2004-12-30?14:04??Job\WEB-INF\src\org\apache\jsp\jsp.jbx
?????文件???????1469??2005-02-04?08:35??Job\WEB-INF\src\job\Cjob.java
?????文件????????476??2005-01-03?15:12??Job\WEB-INF\src\job\Cjob.jbx
?????文件???????1635??2005-01-07?18:47??Job\WEB-INF\src\job\Company.java
?????文件????????473??2004-12-30?15:46??Job\WEB-INF\src\job\Company.jbx
?????文件????????473??2004-12-29?10:33??Job\WEB-INF\src\job\Company.jbx~
?????文件???????1654??2005-01-07?18:47??Job\WEB-INF\src\job\Sjob.java
?????文件????????476??2004-12-30?15:59??Job\WEB-INF\src\job\sjob.jbx
?????文件???????2179??2005-01-07?18:47??Job\WEB-INF\src\job\Student.java
?????文件????????647??2004-12-29?08:14??Job\WEB-INF\src\job\Student.jbx
?????文件????????655??2004-12-28?15:15??Job\WEB-INF\src\job\Student.jbx~
?????文件????????983??2004-12-20?19:29??Job\WEB-INF\src\com\bwm\time\Count.class
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\time\Count.java.LCK
?????文件???????1801??2004-12-20?19:29??Job\WEB-INF\src\com\bwm\time\Time.class
?????文件????????774??2005-01-24?18:45??Job\WEB-INF\src\com\bwm\time\Time.java
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\time\Time.java.LCK
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\string\Sql.java.LCK
?????文件???????1284??2005-01-24?17:31??Job\WEB-INF\src\com\bwm\string\Str.java
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\string\Str.java.LCK
?????文件????????689??2004-12-20?19:29??Job\WEB-INF\src\com\bwm\page\Show.class
?????文件???????1480??2005-01-24?15:19??Job\WEB-INF\src\com\bwm\page\Show.java
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\page\Show.java.LCK
?????文件???????3180??2005-01-25?13:22??Job\WEB-INF\src\com\bwm\db\Conn.java
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\db\Conn.java.LCK
?????文件???????2789??2005-01-27?20:49??Job\WEB-INF\src\com\bwm\db\Data.java
????..A..H.????????10??2004-12-21?13:12??Job\WEB-INF\src\com\bwm\db\Data.java.LCK
............此處省略112個文件信息
評論
共有 條評論