資源簡介
項目用tomcat6.0 發布 用Eclipse開發 用mvc 框架設計 即jsp+servlet+javabean
1 登錄功能: 具有登錄驗證功能 當用戶名密碼正確時進入功能主界面 錯誤不能進入 并提示用戶名密碼不正確
2 主系統5大模塊功能類似:
拿主人系統來說:提供 主人查詢 主人注冊 主人更新 刪除 按條件查詢 全選 全部刪除等功能
主鍵id 注冊時自動累加生成 便于維護

代碼片段和文件信息
package?com.inspur.hostmsg.bean;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?com.inspur.hostmsg.po.Doctor;
import?com.inspur.hostmsg.po.Waiter;
public?class?DoDoctor?{
Connection?conn?=?null;
public?void?getConn()?{
try?{
Class.forName(“com.mysql.jdbc.Driver“);
}?catch?(ClassNotFoundException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
try?{
conn?=?DriverManager.getConnection(
“jdbc:mysql://localhost:3306/mysql?characterEncoding=GBK“
“root“?“123456“);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
public?ArrayList?query()?{
getConn();
PreparedStatement?ps;
ArrayList?al?=?new?ArrayList();
try?{
ps?=?conn.prepareStatement(“select?*?from?doctor“);
ResultSet?rs?=?ps.executeQuery();
while?(rs.next())?{
Doctor?d?=?new?Doctor();
d.setId(rs.getString(“id“));
d.setName(rs.getString(“name“));
d.setProfession(rs.getString(“profession“));
d.setSex(rs.getString(“sex“));
d.setTel(rs.getString(“tel“));
al.add(d);
}
rs.close();
ps.close();
conn.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?al;
}
public?int?registDoctor(Doctor?d)?{
int?jieguo?=?0;
getConn();
try?{
PreparedStatement?ps?=?conn
.prepareStatement(“insert?into?doctor?values(?????)??“);
ps.setString(1?d.getId());
ps.setString(2?d.getName());
ps.setString(3?d.getSex());
ps.setString(4?d.getProfession());
ps.setString(5?d.getTel());
jieguo?=?ps.executeUpdate();
ps.close();
conn.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?jieguo;
}
public?String?getMaxid()?{
String?s?=?“1“;
getConn();
PreparedStatement?ps;
try?{
ps?=?conn
.prepareStatement(“select?*?from?doctor?ORDER?by?id?desc“);
ResultSet?rs?=?ps.executeQuery();
if?(rs.next())
s?=?String.valueOf(rs.getInt(“id“)?+?1);
rs.close();
ps.close();
conn.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?s;
}
public?int?deleteDoctor(String?id)?{
int?result?=?0;
getConn();
try?{
PreparedStatement?ps?=?conn
.prepareStatement(“delete?from?doctor?where?id=?“);
ps.setString(1?id);
result?=?ps.executeUpdate();
ps.close();
conn.close();
this.updateId(id);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?result;
}
public?void?updateId(String?id){
this.getConn();
PreparedStatement?ps1;
try?{
ps1?=?conn.prepareStatement(“update?doctor?set?id?=???where?id?=??“);
for(int?
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????434??2008-11-21?13:07??寵物醫院管理系統+mvc+jsp+servlet+bean實現\項目功能說明.txt
?????文件???????1392??2008-11-19?18:44??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\.classpath
?????文件????????300??2008-11-20?15:46??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\.myme
?????文件????????262??2008-01-22?14:37??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\.mystrutsdata
?????文件???????1310??2008-01-22?14:37??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\.project
?????文件????????864??2008-04-18?08:12??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\oracle_db.sql
?????文件????????235??2008-01-22?17:21??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\readme.txt
?????文件???????2166??2008-11-16?09:24??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\HostMsgBean.java
?????文件???????1243??2008-11-16?10:29??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\LoginBean.java
?????文件???????6419??2008-11-18?20:02??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\QueryHost.java
?????文件???????6697??2008-11-21?12:48??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\DoPet.java
?????文件???????6084??2008-11-21?11:40??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\DoRecord.java
?????文件???????4479??2008-11-18?22:23??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\DoWaiter.java
?????文件???????5092??2008-11-18?18:46??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\bean\DoDoctor.java
?????文件????????775??2008-01-22?14:44??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\po\HostInfo.java
?????文件????????563??2008-11-16?11:21??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\po\PetHost.java
?????文件????????816??2008-11-20?16:23??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\po\Pet.java
?????文件???????1287??2008-11-19?19:57??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\po\Record.java
?????文件????????428??2008-11-18?12:49??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\po\Waiter.java
?????文件????????666??2008-11-18?15:43??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\po\Doctor.java
?????文件???????1836??2008-11-18?22:48??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\keysqueryhost.java
?????文件???????1270??2008-11-16?10:32??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\login.java
?????文件????????943??2008-11-16?11:23??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\queryhost.java
?????文件???????1683??2008-11-16?20:16??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\registhost.java
?????文件???????1016??2008-11-16?20:08??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\deletehost.java
?????文件???????1008??2008-11-16?21:33??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\updatehost.java
?????文件???????1578??2008-11-17?21:42??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\executeupdatehost.java
?????文件????????923??2008-11-16?22:50??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\querypet.java
?????文件???????1588??2008-11-17?10:51??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\registpet.java
?????文件???????1136??2008-11-17?16:06??寵物醫院管理系統+mvc+jsp+servlet+bean實現\petsystem\src\com\inspur\hostmsg\servlet\keysquerypet.java
............此處省略164個文件信息
評論
共有 條評論