資源簡介
模擬一個銀行ODS中間件系統(tǒng),實現(xiàn)來自ATM的客戶請求分發(fā)到遠程的其所屬銀行,交易完畢后將結(jié)果返回至ATM用戶端。

代碼片段和文件信息
package?DB;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
public?class?JDBC?{
public?static?final?String?DRIVER=“com.mysql.jdbc.Driver“;
public?static?final?String?URL=“jdbc:mysql://localhost:3306/atm“;
public?static?final?String?USER=“root“;
public?static?final?String?PWD=““;
private?Connection?con;
private?PreparedStatement?ps;
private?ResultSet?rs;
public?JDBC(){
try?{
Class.forName(DRIVER);
}?catch?(ClassNotFoundException?e)?{
e.printStackTrace();
}
}
public?Connection?getCon(){
try?{
con=DriverManager.getConnection(URL?USER?PWD);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?con;
}
public?void?closeAll(){
if(rs!=null){
try?{
rs.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
if(ps!=null)
try?{
ps.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
if(con!=null)
try?{
con.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
public?int?update(String?sqlobject...?pras){
int?resu=0;
con=getCon();
try?{
ps=con.prepareStatement(sql);
if(pras!=null){
for(int?i=0;i ps.setobject(i+1?pras[i]);
}
}
resu=ps.executeUpdate();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}finally{
closeAll();
}
return?resu;
}
public?ResultSet?query(String?sqlobject...?pras){
con=getCon();
try?{
ps=con.prepareStatement(sql);
if(pras!=null){
for(int?i=0;i ps.setobject(i+1?pras[i]);
}
}
rs=ps.executeQuery();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?rs;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????529??2017-06-08?10:07??15050022張家敏22\ATM\.classpath
?????文件????????282??2017-06-08?10:07??15050022張家敏22\ATM\.myme
?????文件???????1746??2017-06-08?10:07??15050022張家敏22\ATM\.project
?????文件????????500??2017-06-08?10:07??15050022張家敏22\ATM\.settings\.jsdtscope
?????文件????????364??2017-06-08?10:07??15050022張家敏22\ATM\.settings\org.eclipse.jdt.core.prefs
?????文件????????447??2017-06-08?10:07??15050022張家敏22\ATM\.settings\org.eclipse.wst.common.component
?????文件????????252??2017-06-08?10:07??15050022張家敏22\ATM\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2017-06-08?10:07??15050022張家敏22\ATM\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2017-06-08?10:07??15050022張家敏22\ATM\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????1992??2017-06-08?10:07??15050022張家敏22\ATM\src\DB\JDBC.java
?????文件????????722??2017-06-08?10:07??15050022張家敏22\ATM\src\entity\User.java
?????文件????????418??2017-06-08?10:07??15050022張家敏22\ATM\src\rmi\Helloclient.java
?????文件???????1387??2017-06-08?10:07??15050022張家敏22\ATM\src\rmi\HelloServer.java
?????文件????????492??2017-06-08?10:07??15050022張家敏22\ATM\src\rmi\IHello.java
?????文件????????970??2017-06-08?10:07??15050022張家敏22\ATM\src\rmi\IHelloImpl.java
?????文件???????1571??2017-06-08?10:07??15050022張家敏22\ATM\src\Server2\Add.java
?????文件???????2603??2017-06-08?10:07??15050022張家敏22\ATM\src\Server2\Enterpassword.java
?????文件???????1347??2017-06-08?10:07??15050022張家敏22\ATM\src\Server2\Hello.java
?????文件????????300??2017-06-08?10:07??15050022張家敏22\ATM\src\Server2\HelloInterface.java
?????文件???????1383??2017-06-08?10:07??15050022張家敏22\ATM\src\Server2\HelloServer.java
?????文件???????1811??2017-06-08?10:07??15050022張家敏22\ATM\src\Server2\Less.java
?????文件???????1953??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\add.jsp
?????文件???????2061??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\balance.jsp
?????文件???????1574??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\balancefail.jsp
?????文件???????1646??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\chose.jsp
?????文件???????2528??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\css\balance.css
?????文件???????2026??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\css\balancefail.css
?????文件???????2942??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\css\chose.css
?????文件???????1279??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\css\end.css
?????文件???????2095??2017-06-08?10:07??15050022張家敏22\ATM\WebRoot\css\enterpassword.css
............此處省略76個文件信息
- 上一篇:蝸輪蝸桿設計計算程序
- 下一篇:最新已備案未注冊域名掃描工具破解版
評論
共有 條評論