資源簡介
RoomManage 我的課程設計-客房管理系統 Java 部分代碼

代碼片段和文件信息
package?com.connOracle;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;
import?java.sql.Statement;
public?class?ChangeOracle?{
public?static?int?customer_change(String?snum?String?sname?int?roomnum
int?newroomnum)?{
Connection?connect?=?null;//?創建一個數據庫連接
try?{
Class.forName(“oracle.jdbc.driver.OracleDriver“);//?加載Oracle驅動程序
System.out.println(“開始嘗試連接數據庫!“);
String?url?=?“jdbc:oracle:“?+?“thin:@127.0.0.1:1521:orcl“;?//?127.0.0.1是本機地址,XE是精簡版Oracle的默認數據庫名
String?user?=?“system“;?//?用戶名系統默認的賬戶名
String?password?=?“orcl“;?//?你安裝時選設置的密碼
String?sql?=?“insert?into?a_07changeroom?values(????)“;
connect?=?DriverManager.getConnection(url?user?password);//?獲取連接
System.out.println(“連接成功!“);
Statement?statement?=?connect.createStatement();
PreparedStatement?ps?=?(PreparedStatement)?connect
.prepareStatement(sql);
ps.setString(1?snum);
ps.setString(2?sname);
ps.setInt(3?roomnum);
ps.setInt(4?newroomnum);
ps.executeUpdate();
ps.close();
statement.close();//?關閉結果集通道
connect.close();//?關閉數據連接
return?1;
}?catch?(ClassNotFoundException?e)?{
e.printStackTrace();
return?2;
}?catch?(SQLException?e)?{
e.printStackTrace();
return?3;
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????613??2016-12-27?11:04??RoomManage\.classpath
?????文件????????386??2016-12-24?14:58??RoomManage\.project
?????文件????????598??2016-12-24?14:58??RoomManage\.settings\org.eclipse.jdt.core.prefs
?????文件???????2145??2016-12-31?21:27??RoomManage\bin\com\connOracle\ChangeOracle.class
?????文件???????2254??2016-12-31?21:27??RoomManage\bin\com\connOracle\OrderOracle.class
?????文件???????5533??2016-12-31?21:27??RoomManage\bin\com\connOracle\QueryOracle.class
?????文件???????2002??2016-12-31?21:27??RoomManage\bin\com\connOracle\QuitOracle.class
?????文件????????889??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????778??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????1842??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????4008??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????875??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????756??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????764??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????3830??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????874??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????876??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????882??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????2132??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????771??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????4546??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????882??2016-12-31?21:27??RoomManage\bin\com\fr
?????文件????????771??2016-12-31?21:27??RoomManage\bin\com\fr
?????文件???????3821??2016-12-31?21:27??RoomManage\bin\com\fr
?????文件????????875??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????1574??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????764??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件???????3583??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????875??2016-12-31?21:33??RoomManage\bin\com\fr
?????文件????????929??2016-12-31?21:33??RoomManage\bin\com\fr
............此處省略77個文件信息
- 上一篇:網上商城的設計與實現
- 下一篇:json-jar包
評論
共有 條評論