1,用java实现创建数据库表 a(a1,a2),b(b1,b2),c(c1,c2,c3);2, 用java写一个程序,将score.xml内容读入,并统计总分,按总分从高到底输出到rank.txt;
<?xml version="1.0" encoding="ISO-8859-1"?>
<score>
<student><no>1001</no><name>王二</name><s><A>80</A><B>70</B><C>90</C><D>A</D><E>C</E></s></student>
<student><no>1002</no><name>刘一</name><s><A>40</A><B>40</B><C>67</C><D>B</D><E>A</E></s></student>
<student><no>1003</no><name>张三</name><s><A>60</A><B>77</B><C>84</C><D>C</D><E>A</E></s></student>
<student><no>1004</no><name>李四</name><s><A>70</A><B>66</B><C>86</C><D>A</D></s></student>
<student><no>1005</no><name>杨五</name><s><A>88</A><B>64</B><C>97</C><D>C</D></s></student>
<student><no>1006</no><name>赵六</name><s><A>46</A><B>78</B><C>65</C><D>D</D><E>C</E></s></student>
<student><no>1007</no><name>钱九</name><s><A>67</A><B>76</B><C>87</C><D>A</D><E>C</E></s></student>
<student><no>1008</no><name>孙八</name><s><A>84</A><B>87</B><C>94</C></s></student>
<student><no>1009</no><name>李七</name><s><A>96</A><B>97</B><C>93</C><E>C</E></s></student>
<student><no>10010</no><name>周十</name><s><A>20</A><B>46</B><C>32</C><D>A</D><E>C</E></s></student>
</score>