91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1001KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-08-28
  • 語言: Java
  • 標簽: oracle??java??ojdbc??jar包??

資源簡介

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\frame\ChangeframeAI$1.class

?????文件????????778??2016-12-31?21:33??RoomManage\bin\com\frame\ChangeframeAI$2.class

?????文件???????1842??2016-12-31?21:33??RoomManage\bin\com\frame\ChangeframeAI$3.class

?????文件???????4008??2016-12-31?21:33??RoomManage\bin\com\frame\ChangeframeAI.class

?????文件????????875??2016-12-31?21:33??RoomManage\bin\com\frame\LoadframeAl$1.class

?????文件????????756??2016-12-31?21:33??RoomManage\bin\com\frame\LoadframeAl$2.class

?????文件????????764??2016-12-31?21:33??RoomManage\bin\com\frame\LoadframeAl$3.class

?????文件???????3830??2016-12-31?21:33??RoomManage\bin\com\frame\LoadframeAl.class

?????文件????????874??2016-12-31?21:33??RoomManage\bin\com\frame\NewPanel.class

?????文件????????876??2016-12-31?21:33??RoomManage\bin\com\frame\NewPanel2.class

?????文件????????882??2016-12-31?21:33??RoomManage\bin\com\frame\OrderframeAI$1.class

?????文件???????2132??2016-12-31?21:33??RoomManage\bin\com\frame\OrderframeAI$2.class

?????文件????????771??2016-12-31?21:33??RoomManage\bin\com\frame\OrderframeAI$3.class

?????文件???????4546??2016-12-31?21:33??RoomManage\bin\com\frame\OrderframeAI.class

?????文件????????882??2016-12-31?21:27??RoomManage\bin\com\frame\QueryframeAI$1.class

?????文件????????771??2016-12-31?21:27??RoomManage\bin\com\frame\QueryframeAI$2.class

?????文件???????3821??2016-12-31?21:27??RoomManage\bin\com\frame\QueryframeAI.class

?????文件????????875??2016-12-31?21:33??RoomManage\bin\com\frame\QuitframeAI$1.class

?????文件???????1574??2016-12-31?21:33??RoomManage\bin\com\frame\QuitframeAI$2.class

?????文件????????764??2016-12-31?21:33??RoomManage\bin\com\frame\QuitframeAI$3.class

?????文件???????3583??2016-12-31?21:33??RoomManage\bin\com\frame\QuitframeAI.class

?????文件????????875??2016-12-31?21:33??RoomManage\bin\com\frame\UserframeAI$1.class

?????文件????????929??2016-12-31?21:33??RoomManage\bin\com\frame\UserframeAI$10.class

............此處省略77個文件信息

評論

共有 條評論