时间:2021-07-01 10:21:17 帮助过:6人阅读
有关人员信息数据库操作的类主要代码:
- <span style="color: #008080"> 1</span> <span style="color: #0000ff">package</span><span style="color: #000000"> PersonSystem;
- </span><span style="color: #008080"> 2</span>
- <span style="color: #008080"> 3</span> <span style="color: #008000">//</span><span style="color: #008000">import java.util.*;</span>
- <span style="color: #008080"> 4</span> <span style="color: #0000ff">import</span> java.sql.*<span style="color: #000000">;
- </span><span style="color: #008080"> 5</span> <span style="color: #0000ff">import</span> javax.swing.*<span style="color: #000000">;
- </span><span style="color: #008080"> 6</span> <span style="color: #008000">/**</span>
- <span style="color: #008080"> 7</span> <span style="color: #008000"> *
- </span><span style="color: #008080"> 8</span> <span style="color: #008000"> * 有关人员信息数据库操作的类
- </span><span style="color: #008080"> 9</span> <span style="color: #008000"> *
- </span><span style="color: #008080"> 10</span> <span style="color: #008000">*/</span>
- <span style="color: #008080"> 11</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> PersonBean
- </span><span style="color: #008080"> 12</span> <span style="color: #000000">{
- </span><span style="color: #008080"> 13</span> <span style="color: #000000"> String sql;
- </span><span style="color: #008080"> 14</span> ResultSet rs = <span style="color: #0000ff">null</span><span style="color: #000000">;
- </span><span style="color: #008080"> 15</span>
- <span style="color: #008080"> 16</span> String field1; <span style="color: #008000">//</span><span style="color: #008000">PersonID</span>
- <span style="color: #008080"> 17</span> String field2; <span style="color: #008000">//</span><span style="color: #008000">Name</span>
- <span style="color: #008080"> 18</span> String field3; <span style="color: #008000">//</span><span style="color: #008000">Sex</span>
- <span style="color: #008080"> 19</span> String field4; <span style="color: #008000">//</span><span style="color: #008000">Birth</span>
- <span style="color: #008080"> 20</span> String field5; <span style="color: #008000">//</span><span style="color: #008000">Nat</span>
- <span style="color: #008080"> 21</span> String field6; <span style="color: #008000">//</span><span style="color: #008000">Address</span>
- <span style="color: #008080"> 22</span> String field7; <span style="color: #008000">//</span><span style="color: #008000">DeptID</span>
- <span style="color: #008080"> 23</span> String field8; <span style="color: #008000">//</span><span style="color: #008000">Salary</span>
- <span style="color: #008080"> 24</span> String field9; <span style="color: #008000">//</span><span style="color: #008000">Assess</span>
- <span style="color: #008080"> 25</span> String field10; <span style="color: #008000">//</span><span style="color: #008000">Other</span>
- <span style="color: #008080"> 26</span>
- <span style="color: #008080"> 27</span> String colName; <span style="color: #008000">//</span><span style="color: #008000">列名</span>
- <span style="color: #008080"> 28</span> String colValue; <span style="color: #008000">//</span><span style="color: #008000">列值</span>
- <span style="color: #008080"> 29</span> String colValue2; <span style="color: #008000">//</span><span style="color: #008000">列值</span>
- <span style="color: #008080"> 30</span>
- <span style="color: #008080"> 31</span> <span style="color: #008000">/**</span>
- <span style="color: #008080"> 32</span> <span style="color: #008000"> * 添加信息
- </span><span style="color: #008080"> 33</span> <span style="color: #008000">*/</span>
- <span style="color: #008080"> 34</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> add(String f1,String f2,String f3,String f4,String f5,
- </span><span style="color: #008080"> 35</span> <span style="color: #000000"> String f6,String f7,String f8,String f9,String f10)
- </span><span style="color: #008080"> 36</span> <span style="color: #000000"> {
- </span><span style="color: #008080"> 37</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080"> 38</span>
- <span style="color: #008080"> 39</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080"> 40</span> <span style="color: #0000ff">this</span>.field2 =<span style="color: #000000"> f2;
- </span><span style="color: #008080"> 41</span> <span style="color: #0000ff">this</span>.field3 =<span style="color: #000000"> f3;
- </span><span style="color: #008080"> 42</span> <span style="color: #0000ff">this</span>.field4 =<span style="color: #000000"> f4;
- </span><span style="color: #008080"> 43</span> <span style="color: #0000ff">this</span>.field5 =<span style="color: #000000"> f5;
- </span><span style="color: #008080"> 44</span> <span style="color: #0000ff">this</span>.field6 =<span style="color: #000000"> f6;
- </span><span style="color: #008080"> 45</span> <span style="color: #0000ff">this</span>.field7 =<span style="color: #000000"> f7;
- </span><span style="color: #008080"> 46</span> <span style="color: #0000ff">this</span>.field8 =<span style="color: #000000"> f8;
- </span><span style="color: #008080"> 47</span> <span style="color: #0000ff">this</span>.field9 =<span style="color: #000000"> f9;
- </span><span style="color: #008080"> 48</span> <span style="color: #0000ff">this</span>.field10 =<span style="color: #000000"> f10;
- </span><span style="color: #008080"> 49</span>
- <span style="color: #008080"> 50</span> <span style="color: #0000ff">if</span>(field2 == <span style="color: #0000ff">null</span>||field2.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 51</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入员工姓名","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 52</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 53</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 54</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field3 == <span style="color: #0000ff">null</span>||field3.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 55</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入性别","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 56</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 57</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 58</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field4 == <span style="color: #0000ff">null</span>||field4.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 59</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入出生年月","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 60</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 61</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 62</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field5 == <span style="color: #0000ff">null</span>||field5.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 63</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入民族","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 64</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 65</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 66</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field6 == <span style="color: #0000ff">null</span>||field6.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 67</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入地址","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 68</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 69</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 70</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field7 == <span style="color: #0000ff">null</span>||field7.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 71</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入部门","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 72</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 73</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 74</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field8 == <span style="color: #0000ff">null</span>||field8.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080"> 75</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入薪酬","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 76</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080"> 77</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 78</span> <span style="color: #0000ff">else</span><span style="color: #000000">{
- </span><span style="color: #008080"> 79</span> sql = "insert into Person(PersonID,Name,Sex,Birth,Nat,Address,DeptID,Salary,Assess,Other)"
- <span style="color: #008080"> 80</span> +"values(‘"+field1+"‘,‘"+field2+"‘,‘"+field3+"‘,‘"+field4+"‘,‘"+field5+"‘,"
- <span style="color: #008080"> 81</span> + "‘"+field6+"‘,‘"+field7+"‘,‘"+field8+"‘,‘"+field9+"‘,‘"+field10+"‘)"<span style="color: #000000">;
- </span><span style="color: #008080"> 82</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080"> 83</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080"> 84</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080"> 85</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "成功添加一条记录!"<span style="color: #000000">);
- </span><span style="color: #008080"> 86</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 87</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080"> 88</span> <span style="color: #000000"> System.out.println(e);
- </span><span style="color: #008080"> 89</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "保存失败","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080"> 90</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 91</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080"> 92</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080"> 93</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080"> 94</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 95</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 96</span> <span style="color: #000000"> }
- </span><span style="color: #008080"> 97</span>
- <span style="color: #008080"> 98</span> <span style="color: #008000">/**</span>
- <span style="color: #008080"> 99</span> <span style="color: #008000"> * 修改信息
- </span><span style="color: #008080">100</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">101</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> modify(String f1,String f2,String f3,String f4,String f5,
- </span><span style="color: #008080">102</span> <span style="color: #000000"> String f6,String f7,String f8,String f9,String f10)
- </span><span style="color: #008080">103</span> <span style="color: #000000"> {
- </span><span style="color: #008080">104</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">105</span>
- <span style="color: #008080">106</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080">107</span> <span style="color: #0000ff">this</span>.field2 =<span style="color: #000000"> f2;
- </span><span style="color: #008080">108</span> <span style="color: #0000ff">this</span>.field3 =<span style="color: #000000"> f3;
- </span><span style="color: #008080">109</span> <span style="color: #0000ff">this</span>.field4 =<span style="color: #000000"> f4;
- </span><span style="color: #008080">110</span> <span style="color: #0000ff">this</span>.field5 =<span style="color: #000000"> f5;
- </span><span style="color: #008080">111</span> <span style="color: #0000ff">this</span>.field6 =<span style="color: #000000"> f6;
- </span><span style="color: #008080">112</span> <span style="color: #0000ff">this</span>.field7 =<span style="color: #000000"> f7;
- </span><span style="color: #008080">113</span> <span style="color: #0000ff">this</span>.field8 =<span style="color: #000000"> f8;
- </span><span style="color: #008080">114</span> <span style="color: #0000ff">this</span>.field9 =<span style="color: #000000"> f9;
- </span><span style="color: #008080">115</span> <span style="color: #0000ff">this</span>.field10 =<span style="color: #000000"> f10;
- </span><span style="color: #008080">116</span>
- <span style="color: #008080">117</span> <span style="color: #0000ff">if</span>(field2 == <span style="color: #0000ff">null</span>||field2.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">118</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入员工姓名","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">119</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">120</span> <span style="color: #000000"> }
- </span><span style="color: #008080">121</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field3 == <span style="color: #0000ff">null</span>||field3.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">122</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入性别","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">123</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">124</span> <span style="color: #000000"> }
- </span><span style="color: #008080">125</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field4 == <span style="color: #0000ff">null</span>||field4.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">126</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入出生年月","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">127</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">128</span> <span style="color: #000000"> }
- </span><span style="color: #008080">129</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field5 == <span style="color: #0000ff">null</span>||field5.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">130</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入民族","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">131</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">132</span> <span style="color: #000000"> }
- </span><span style="color: #008080">133</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field6 == <span style="color: #0000ff">null</span>||field6.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">134</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入地址","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">135</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">136</span> <span style="color: #000000"> }
- </span><span style="color: #008080">137</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field7 == <span style="color: #0000ff">null</span>||field7.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">138</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入部门","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">139</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">140</span> <span style="color: #000000"> }
- </span><span style="color: #008080">141</span> <span style="color: #0000ff">else</span> <span style="color: #0000ff">if</span>(field8 == <span style="color: #0000ff">null</span>||field8.equals(""<span style="color: #000000">)){
- </span><span style="color: #008080">142</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "请输入薪酬","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">143</span> <span style="color: #0000ff">return</span><span style="color: #000000">;
- </span><span style="color: #008080">144</span> <span style="color: #000000"> }
- </span><span style="color: #008080">145</span> <span style="color: #0000ff">else</span><span style="color: #000000">{
- </span><span style="color: #008080">146</span> sql = "update Person set Name= ‘"+field2+"‘,"+"Sex=‘"+field3+"‘,‘"+"Birth=‘"+field4+"‘,‘"
- <span style="color: #008080">147</span> +"Nat=‘"+field5+"‘,‘"+"Address=‘"+field6+"‘,‘"+"‘"+"DeptID=‘"+field7+"‘,‘"+"Salary=‘"+field8+"‘,‘"
- <span style="color: #008080">148</span> +"Assess=‘"+field9+"‘,‘"+"Other=‘"+field10+"‘,‘"+"where PersonID=‘"+field1+""<span style="color: #000000">;
- </span><span style="color: #008080">149</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">150</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">151</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080">152</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "成功修改一条新的记录!"<span style="color: #000000">);
- </span><span style="color: #008080">153</span> <span style="color: #000000"> }
- </span><span style="color: #008080">154</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">155</span> <span style="color: #000000"> System.out.println(e);
- </span><span style="color: #008080">156</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "更新失败","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">157</span> <span style="color: #000000"> }
- </span><span style="color: #008080">158</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">159</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">160</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">161</span> <span style="color: #000000"> }
- </span><span style="color: #008080">162</span> <span style="color: #000000"> }
- </span><span style="color: #008080">163</span> <span style="color: #000000"> }
- </span><span style="color: #008080">164</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">165</span> <span style="color: #008000"> * 删除信息
- </span><span style="color: #008080">166</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">167</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> delete(String f1)
- </span><span style="color: #008080">168</span> <span style="color: #000000"> {
- </span><span style="color: #008080">169</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">170</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080">171</span>
- <span style="color: #008080">172</span> sql = "delect from Person where PersonID ="+field1+""<span style="color: #000000">;
- </span><span style="color: #008080">173</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">174</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">175</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080">176</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "成功删除一条记录!"<span style="color: #000000">);
- </span><span style="color: #008080">177</span> <span style="color: #000000"> }
- </span><span style="color: #008080">178</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">179</span> <span style="color: #000000"> System.out.println(e);
- </span><span style="color: #008080">180</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "删除失败","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">181</span> <span style="color: #000000"> }
- </span><span style="color: #008080">182</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">183</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">184</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">185</span> <span style="color: #000000"> }
- </span><span style="color: #008080">186</span> <span style="color: #000000"> }
- </span><span style="color: #008080">187</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">188</span> <span style="color: #008000"> * 根据编号查询信息
- </span><span style="color: #008080">189</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">190</span> <span style="color: #0000ff">public</span><span style="color: #000000"> String[] search(String f1)
- </span><span style="color: #008080">191</span> <span style="color: #000000"> {
- </span><span style="color: #008080">192</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">193</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080">194</span> String[] s = <span style="color: #0000ff">new</span> String[10<span style="color: #000000">];
- </span><span style="color: #008080">195</span> sql = "select * from Person where PersonID = "+field1+""<span style="color: #000000">;
- </span><span style="color: #008080">196</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">197</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">198</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080">199</span> <span style="color: #0000ff">if</span><span style="color: #000000">(rs.next()){
- </span><span style="color: #008080">200</span> s[0] = rs.getString("PersonID"<span style="color: #000000">);
- </span><span style="color: #008080">201</span> s[1] = rs.getString("Name"<span style="color: #000000">);
- </span><span style="color: #008080">202</span> s[2] = rs.getString("Sex"<span style="color: #000000">);
- </span><span style="color: #008080">203</span> s[3] = rs.getString("Birth"<span style="color: #000000">);
- </span><span style="color: #008080">204</span> s[4] = rs.getString("Nat"<span style="color: #000000">);
- </span><span style="color: #008080">205</span> s[5] = rs.getString("Address"<span style="color: #000000">);
- </span><span style="color: #008080">206</span> s[6] = rs.getString("DeptID"<span style="color: #000000">);
- </span><span style="color: #008080">207</span> s[7] = rs.getString("Salary"<span style="color: #000000">);
- </span><span style="color: #008080">208</span> s[8] = rs.getString("Assess"<span style="color: #000000">);
- </span><span style="color: #008080">209</span> s[9] = rs.getString("Other"<span style="color: #000000">);
- </span><span style="color: #008080">210</span> <span style="color: #000000"> }
- </span><span style="color: #008080">211</span> <span style="color: #0000ff">else</span>
- <span style="color: #008080">212</span> s = <span style="color: #0000ff">null</span><span style="color: #000000">;
- </span><span style="color: #008080">213</span> <span style="color: #000000"> }
- </span><span style="color: #008080">214</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">215</span> <span style="color: #000000"> }
- </span><span style="color: #008080">216</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">217</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">218</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">219</span> <span style="color: #000000"> }
- </span><span style="color: #008080">220</span> <span style="color: #0000ff">return</span><span style="color: #000000"> s;
- </span><span style="color: #008080">221</span> <span style="color: #000000"> }
- </span><span style="color: #008080">222</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">223</span> <span style="color: #008000"> * 人员记录综合查询(查询所有记录)
- </span><span style="color: #008080">224</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">225</span> <span style="color: #0000ff">public</span><span style="color: #000000"> String[][] searchAllForNode()
- </span><span style="color: #008080">226</span> <span style="color: #000000"> {
- </span><span style="color: #008080">227</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">228</span> String[][] sn = <span style="color: #0000ff">null</span><span style="color: #000000">;
- </span><span style="color: #008080">229</span> <span style="color: #0000ff">int</span> row = 0<span style="color: #000000">;
- </span><span style="color: #008080">230</span> <span style="color: #0000ff">int</span> i = 0<span style="color: #000000">;
- </span><span style="color: #008080">231</span> sql = "select PersonID,Name,Sex,Dept.DeptID as DeptID,B_Dept,S_Dept,Salary,Assess "
- <span style="color: #008080">232</span> + "from Dept,Person where Dept.DeptID = Person.DeptID order by PersonID"<span style="color: #000000">;
- </span><span style="color: #008080">233</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">234</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">235</span> rs =<span style="color: #000000"> DB.executeQuery(sql);
- </span><span style="color: #008080">236</span> <span style="color: #0000ff">if</span><span style="color: #000000">(rs.last()){
- </span><span style="color: #008080">237</span> row =<span style="color: #000000"> rs.getRow();
- </span><span style="color: #008080">238</span> <span style="color: #000000"> }
- </span><span style="color: #008080">239</span> <span style="color: #0000ff">if</span>(row==0<span style="color: #000000">){
- </span><span style="color: #008080">240</span> sn = <span style="color: #0000ff">new</span> String[1][6<span style="color: #000000">];
- </span><span style="color: #008080">241</span> sn[0][0] = " "<span style="color: #000000">;
- </span><span style="color: #008080">242</span> sn[0][1] = " "<span style="color: #000000">;
- </span><span style="color: #008080">243</span> sn[0][2] = " "<span style="color: #000000">;
- </span><span style="color: #008080">244</span> sn[0][3] = " "<span style="color: #000000">;
- </span><span style="color: #008080">245</span> sn[0][4] = " "<span style="color: #000000">;
- </span><span style="color: #008080">246</span> sn[0][5] = " "<span style="color: #000000">;
- </span><span style="color: #008080">247</span> <span style="color: #000000"> }
- </span><span style="color: #008080">248</span> <span style="color: #0000ff">else</span><span style="color: #000000">{
- </span><span style="color: #008080">249</span> sn = <span style="color: #0000ff">new</span> String[row][6<span style="color: #000000">];
- </span><span style="color: #008080">250</span> <span style="color: #000000"> rs.first();
- </span><span style="color: #008080">251</span> <span style="color: #000000"> rs.previous();
- </span><span style="color: #008080">252</span> <span style="color: #0000ff">while</span><span style="color: #000000">(rs.next()){
- </span><span style="color: #008080">253</span> sn[i][0] = rs.getString("PersonID"<span style="color: #000000">);
- </span><span style="color: #008080">254</span> sn[i][1] = rs.getString("Name"<span style="color: #000000">);
- </span><span style="color: #008080">255</span> sn[i][2] = rs.getString("Sex"<span style="color: #000000">);
- </span><span style="color: #008080">256</span> sn[i][3] = rs.getString("B_Dept")+"-"+rs.getString("S_Dept"<span style="color: #000000">);
- </span><span style="color: #008080">257</span> sn[i][4] = rs.getString("Salary"<span style="color: #000000">);
- </span><span style="color: #008080">258</span> sn[i][5] = rs.getString("Assess"<span style="color: #000000">);
- </span><span style="color: #008080">259</span> i++<span style="color: #000000">;
- </span><span style="color: #008080">260</span> <span style="color: #000000"> }
- </span><span style="color: #008080">261</span> <span style="color: #000000"> }
- </span><span style="color: #008080">262</span> <span style="color: #000000"> }
- </span><span style="color: #008080">263</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">264</span>
- <span style="color: #008080">265</span> <span style="color: #000000"> }
- </span><span style="color: #008080">266</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">267</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">268</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">269</span> <span style="color: #000000"> }
- </span><span style="color: #008080">270</span> <span style="color: #0000ff">return</span><span style="color: #000000"> sn;
- </span><span style="color: #008080">271</span> <span style="color: #000000"> }
- </span><span style="color: #008080">272</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">273</span> <span style="color: #008000"> * 修改信息
- </span><span style="color: #008080">274</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">275</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> updateDept(String f1,String f7)
- </span><span style="color: #008080">276</span> <span style="color: #000000"> {
- </span><span style="color: #008080">277</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">278</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080">279</span> <span style="color: #0000ff">this</span>.field7 =<span style="color: #000000"> f7;
- </span><span style="color: #008080">280</span>
- <span style="color: #008080">281</span> sql = "update Person set DeptID = "+field7+"where PersonID ="+<span style="color: #000000">field1;
- </span><span style="color: #008080">282</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">283</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">284</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080">285</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "人员调动成功!"<span style="color: #000000">);
- </span><span style="color: #008080">286</span> <span style="color: #000000"> }
- </span><span style="color: #008080">287</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">288</span> <span style="color: #000000"> System.out.println(e);
- </span><span style="color: #008080">289</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "更新失败","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">290</span> <span style="color: #000000"> }
- </span><span style="color: #008080">291</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">292</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">293</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">294</span> <span style="color: #000000"> }
- </span><span style="color: #008080">295</span> <span style="color: #000000"> }
- </span><span style="color: #008080">296</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">297</span> <span style="color: #008000"> * 修改信息
- </span><span style="color: #008080">298</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">299</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> updateSalary(String f1,String f8)
- </span><span style="color: #008080">300</span> <span style="color: #000000"> {
- </span><span style="color: #008080">301</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">302</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080">303</span> <span style="color: #0000ff">this</span>.field8 =<span style="color: #000000"> f8;
- </span><span style="color: #008080">304</span>
- <span style="color: #008080">305</span> sql = "update Person set Salary =‘"+field8+"‘where PersonID ="+<span style="color: #000000">field1;
- </span><span style="color: #008080">306</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">307</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">308</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080">309</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "劳资更改成功!"<span style="color: #000000">);
- </span><span style="color: #008080">310</span> <span style="color: #000000"> }
- </span><span style="color: #008080">311</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">312</span> <span style="color: #000000"> System.out.println(e);
- </span><span style="color: #008080">313</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "更新失败","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">314</span> <span style="color: #000000"> }
- </span><span style="color: #008080">315</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">316</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">317</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">318</span> <span style="color: #000000"> }
- </span><span style="color: #008080">319</span> <span style="color: #000000"> }
- </span><span style="color: #008080">320</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">321</span> <span style="color: #008000"> * 修改信息
- </span><span style="color: #008080">322</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">323</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> updateAssess(String f1,String f9)
- </span><span style="color: #008080">324</span> <span style="color: #000000"> {
- </span><span style="color: #008080">325</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">326</span> <span style="color: #0000ff">this</span>.field1 =<span style="color: #000000"> f1;
- </span><span style="color: #008080">327</span> <span style="color: #0000ff">this</span>.field8 =<span style="color: #000000"> f9;
- </span><span style="color: #008080">328</span>
- <span style="color: #008080">329</span> sql = "update Person set Assess =‘"+field9+"‘where PersonID ="+<span style="color: #000000">field1;
- </span><span style="color: #008080">330</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">331</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">332</span> <span style="color: #000000"> DB.executeUpdate(sql);
- </span><span style="color: #008080">333</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "人员考核成功!"<span style="color: #000000">);
- </span><span style="color: #008080">334</span> <span style="color: #000000"> }
- </span><span style="color: #008080">335</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">336</span> <span style="color: #000000"> System.out.println(e);
- </span><span style="color: #008080">337</span> JOptionPane.showMessageDialog(<span style="color: #0000ff">null</span>, "更新失败","错误"<span style="color: #000000">,JOptionPane.ERROR_MESSAGE);
- </span><span style="color: #008080">338</span> <span style="color: #000000"> }
- </span><span style="color: #008080">339</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">340</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">341</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">342</span> <span style="color: #000000"> }
- </span><span style="color: #008080">343</span> <span style="color: #000000"> }
- </span><span style="color: #008080">344</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">345</span> <span style="color: #008000"> * 人员信息综合查询
- </span><span style="color: #008080">346</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">347</span> <span style="color: #0000ff">public</span><span style="color: #000000"> String[][] searchAll()
- </span><span style="color: #008080">348</span> <span style="color: #000000"> {
- </span><span style="color: #008080">349</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">350</span> String[][] sn = <span style="color: #0000ff">null</span><span style="color: #000000">;
- </span><span style="color: #008080">351</span> <span style="color: #0000ff">int</span> row = 0<span style="color: #000000">;
- </span><span style="color: #008080">352</span> <span style="color: #0000ff">int</span> i = 0<span style="color: #000000">;
- </span><span style="color: #008080">353</span> sql = "select * from Person order by PersonID"<span style="color: #000000">;
- </span><span style="color: #008080">354</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">355</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">356</span> rs =<span style="color: #000000"> DB.executeQuery(sql);
- </span><span style="color: #008080">357</span> <span style="color: #0000ff">if</span><span style="color: #000000">(rs.last()){
- </span><span style="color: #008080">358</span> row =<span style="color: #000000"> rs.getRow();
- </span><span style="color: #008080">359</span> <span style="color: #000000"> }
- </span><span style="color: #008080">360</span> <span style="color: #0000ff">if</span>(row==0<span style="color: #000000">){
- </span><span style="color: #008080">361</span> sn = <span style="color: #0000ff">new</span> String[1][6<span style="color: #000000">];
- </span><span style="color: #008080">362</span> sn[0][0] = " "<span style="color: #000000">;
- </span><span style="color: #008080">363</span> sn[0][1] = " "<span style="color: #000000">;
- </span><span style="color: #008080">364</span> sn[0][2] = " "<span style="color: #000000">;
- </span><span style="color: #008080">365</span> sn[0][3] = " "<span style="color: #000000">;
- </span><span style="color: #008080">366</span> sn[0][4] = " "<span style="color: #000000">;
- </span><span style="color: #008080">367</span> sn[0][5] = " "<span style="color: #000000">;
- </span><span style="color: #008080">368</span> <span style="color: #000000"> }
- </span><span style="color: #008080">369</span> <span style="color: #0000ff">else</span><span style="color: #000000">{
- </span><span style="color: #008080">370</span> sn = <span style="color: #0000ff">new</span> String[row][6<span style="color: #000000">];
- </span><span style="color: #008080">371</span> <span style="color: #000000"> rs.first();
- </span><span style="color: #008080">372</span> <span style="color: #000000"> rs.previous();
- </span><span style="color: #008080">373</span> <span style="color: #0000ff">while</span><span style="color: #000000">(rs.next()){
- </span><span style="color: #008080">374</span> sn[i][0] = rs.getString("PersonID"<span style="color: #000000">);
- </span><span style="color: #008080">375</span> sn[i][1] = rs.getString("Name"<span style="color: #000000">);
- </span><span style="color: #008080">376</span> sn[i][2] = rs.getString("Sex"<span style="color: #000000">);
- </span><span style="color: #008080">377</span> sn[i][3] = rs.getString("Nat"<span style="color: #000000">);
- </span><span style="color: #008080">378</span> sn[i][4] = rs.getString("Address"<span style="color: #000000">);
- </span><span style="color: #008080">379</span> DeptBean dp = <span style="color: #0000ff">new</span><span style="color: #000000"> DeptBean();
- </span><span style="color: #008080">380</span> sn[i][5] = dp.getDeptStr(rs.getString("DeptID"<span style="color: #000000">));
- </span><span style="color: #008080">381</span> i++<span style="color: #000000">;
- </span><span style="color: #008080">382</span> <span style="color: #000000"> }
- </span><span style="color: #008080">383</span> <span style="color: #000000"> }
- </span><span style="color: #008080">384</span> <span style="color: #000000"> }
- </span><span style="color: #008080">385</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">386</span>
- <span style="color: #008080">387</span> <span style="color: #000000"> }
- </span><span style="color: #008080">388</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">389</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">390</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">391</span> <span style="color: #000000"> }
- </span><span style="color: #008080">392</span> <span style="color: #0000ff">return</span><span style="color: #000000"> sn;
- </span><span style="color: #008080">393</span> <span style="color: #000000"> }
- </span><span style="color: #008080">394</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">395</span> <span style="color: #008000"> * 获得新的ID
- </span><span style="color: #008080">396</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">397</span> <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span><span style="color: #000000"> getId()
- </span><span style="color: #008080">398</span> <span style="color: #000000"> {
- </span><span style="color: #008080">399</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">400</span> <span style="color: #0000ff">int</span> ID = 1<span style="color: #000000">;
- </span><span style="color: #008080">401</span> sql = "select max(PersonID) from Person"<span style="color: #000000">;
- </span><span style="color: #008080">402</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">403</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">404</span> rs =<span style="color: #000000"> DB.executeQuery(sql);
- </span><span style="color: #008080">405</span> <span style="color: #0000ff">if</span><span style="color: #000000">(rs.next()){
- </span><span style="color: #008080">406</span> ID = rs.getInt(1) + 1<span style="color: #000000">;
- </span><span style="color: #008080">407</span> <span style="color: #000000"> }
- </span><span style="color: #008080">408</span> <span style="color: #0000ff">else</span>
- <span style="color: #008080">409</span> ID = 1<span style="color: #000000">;
- </span><span style="color: #008080">410</span> <span style="color: #000000"> }
- </span><span style="color: #008080">411</span> <span style="color: #0000ff">catch</span><span style="color: #000000">(Exception e){
- </span><span style="color: #008080">412</span>
- <span style="color: #008080">413</span> <span style="color: #000000"> }
- </span><span style="color: #008080">414</span> <span style="color: #0000ff">finally</span><span style="color: #000000">{
- </span><span style="color: #008080">415</span> <span style="color: #000000"> DB.closeStmt();
- </span><span style="color: #008080">416</span> <span style="color: #000000"> DB.closeConn();
- </span><span style="color: #008080">417</span> <span style="color: #000000"> }
- </span><span style="color: #008080">418</span> <span style="color: #0000ff">return</span><span style="color: #000000"> ID;
- </span><span style="color: #008080">419</span> <span style="color: #000000"> }
- </span><span style="color: #008080">420</span> <span style="color: #008000">/**</span>
- <span style="color: #008080">421</span> <span style="color: #008000"> * 取得DeptID
- </span><span style="color: #008080">422</span> <span style="color: #008000">*/</span>
- <span style="color: #008080">423</span> <span style="color: #0000ff">public</span><span style="color: #000000"> String getDeptId(String f1)
- </span><span style="color: #008080">424</span> <span style="color: #000000"> {
- </span><span style="color: #008080">425</span> Database DB = <span style="color: #0000ff">new</span><span style="color: #000000"> Database();
- </span><span style="color: #008080">426</span> sql = "select DeptID from Person where personID = "+<span style="color: #000000">f1;
- </span><span style="color: #008080">427</span> String deptid = <span style="color: #0000ff">null</span><span style="color: #000000">;
- </span><span style="color: #008080">428</span> <span style="color: #0000ff">try</span><span style="color: #000000">{
- </span><span style="color: #008080">429</span> <span style="color: #000000"> DB.OpenConn();
- </span><span style="color: #008080">430</span> rs =<span style="color: #000000"> DB.executeQuery(sql);
- </span><span style="color: #008080">431</span> <span style="color: #0000ff">if</span><span style="color: #000000">(rs.next()){
- </span><span style="color: #008080">432</span> deptid = rs.getString("DeptID"<span style="color: #000000">);
- </span><span style="color: #008080">433</span> <span style="color: #000000"> }
- </span><span style="color: #008080">434</span> <span style="color: #0000ff">els </span>