廢話不多說了，直接給大家貼關(guān)鍵代碼了，具體代碼如下所示：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
package com.sp.test;import java.sql.*;import java.util.*;public class Text_lianxi extends Thread {public void run() {try {yunxing();Thread.sleep(10000);} catch (InterruptedException e) {// TODO 自動生成的 catch 塊e.printStackTrace();}}//輸入函數(shù)public String[] shuru() {System.out.println("請按順序依次輸入考生的詳細(xì)信息：\n考試等級，身份證號，準(zhǔn)考證號，考生姓名，考試地點(diǎn)，考試成績");Scanner sc = new Scanner(System.in);String[] str = new String[6];for (int i = 0; i < str.length; i++) {str[i] = sc.nextLine();}System.out.println("信息輸入完畢");sc.close();return str;}//查詢函數(shù)public String chaxun() {System.out.println("請選擇查詢方式：\n a:身份證號 b:準(zhǔn)考證號");Scanner sc = new Scanner(System.in);String s = sc.nextLine().toLowerCase();String str = "";if (s.equals("a")) {System.out.println("請輸入查詢號碼：");String st = sc.nextLine();if (st.length() == 18) {str = "select * from examstudent where idcard = " + st;} else {System.out.println("身份證位數(shù)輸入有誤");}} else if (s.equals("b")) {System.out.println("請輸入查詢號碼：");String st = sc.nextLine();if (st.length() == 15) {str = "select * from examstudent where examcard = " + st;} else {System.out.println("準(zhǔn)考證位數(shù)輸入有誤");}} else {System.out.println("你輸入的查詢方式有誤，請重新進(jìn)入程序");}sc.close();return str;}//刪除函數(shù)public String shanchu() {Scanner sc = new Scanner(System.in);System.out.println("請輸入考生的準(zhǔn)考證號：");String str = sc.nextLine();if (str.length() != 15) {System.out.println("準(zhǔn)考證號輸入有誤，請重新輸入");}sc.close();return str;}//運(yùn)行public void yunxing() {synchronized ("") {try {Connection conn = null;// 鏈接數(shù)據(jù)庫Class.forName("oracle.jdbc.driver.OracleDriver");String strURL = "jdbc:oracle:thin:@localhost:1521:SP";conn = DriverManager.getConnection(strURL, "test", "123");System.out.println(Thread.currentThread().getName()+"數(shù)據(jù)庫連接成功");Statement st = conn.createStatement();// 選擇功能Scanner sc = new Scanner(System.in);System.out.println("請選擇功能：\n 1：輸入信息 2：查詢信息 3：刪除信息");int num = sc.nextInt();if (num == 1) {// 輸入信息String[] str = shuru();if (str[1].length() != 18 && str[2].length() != 15) {System.out.println("號碼位數(shù)有誤（身份證號18位，準(zhǔn)考證號15位），請重新進(jìn)入系統(tǒng)輸入");} else {st.execute("insert into examstudent values(fiowid.nextval,to_number(" + str[0] + "),'" + str[1]+ "','" + str[2] + "','" + str[3] + "','" + str[4] + "'," + "to_number(" + str[5]+ "))");System.out.println("信息錄入成功");}} else if (num == 2) {// 查詢String str1 = chaxun();ResultSet r = st.executeQuery(str1);// 輸出查詢結(jié)果if (r.next()) {System.out.println("考試等級：" + r.getString(2) + "\n身份證號:" + r.getString(3) + "\n準(zhǔn)考證號："+ r.getString(4) + "\n考生姓名：" + r.getString(5) + "\n考試地區(qū)：" + r.getString(6) + "\n考試成績:"+ r.getString(7));} else {System.out.println("查無此人，請重新進(jìn)入系統(tǒng)");}r.close();} else if (num == 3) {// 刪除String str2 = shanchu();int a = st.executeUpdate("delete examstudent where examcard = " + str2);if (a > 0) {System.out.println("刪除成功");} else {System.out.println("查無此人，請重新進(jìn)入程序");}} else {System.out.println("抱歉，暫未開放此功能");}sc.close();st.close();} catch (Exception e) {e.printStackTrace();}}}public static void main(String[] args) {Text_lianxi lx1 = new Text_lianxi();// Text_lianxi lx2 = new Text_lianxi();// Text_lianxi lx3 = new Text_lianxi();lx1.setName("窗口1");lx1.start();// lx2.setName("窗口2");// lx2.start();// lx3.setName("窗口3");// lx3.start();}} |
開始運(yùn)行：
信息輸入： 身份證號查詢：
準(zhǔn)考證號查詢： 信息刪除：
輸入錯誤信息：
以上所述是小編給大家介紹的Java連接操作Oracle數(shù)據(jù)庫代碼詳解的全部敘述，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復(fù)大家的。在此也非常感謝大家對服務(wù)器之家網(wǎng)站的支持！
