Flex调用WebService的例子（完形填空考试系统）

package dao; import java.sql.DriverManager; import java.sql.ResultSet; //import java.sql.SQLException; import java.sql.Connection; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class ConnMysql { private static String url="jdbc:mysql://localhost:3306/exam_lib"; //定义URL private static String driver="com.mysql.jdbc.Driver"; //mysql-jdbc驱动程序 private static Connection conn=null; private static ResultSet rs = null; private static Statement st = null; private static ResultSet rs2 = null; private static Statement st2 = null; public static Connection initConn() { try { //加载驱动程序 Class.forName(driver); //连接数据库，需要用户名和密码 conn = DriverManager.getConnection(url,"root","33445xh5zj"); } catch (Exception e) { e.printStackTrace(); } return conn; } // public void AddTitle(String title) throws Exception // { // st = ConnMysql.initConn().createStatement(); // String sql; // sql = "insert into cloze_content(title, content) values('" + title + "', '" + title + "')"; // st.executeUpdate(sql); // } // public int AddCloze(String title, int score, String content) throws Exception // { // st = ConnMysql.initConn().createStatement(); // String sql; // sql = "insert into cloze_content(title, content, score) values('" + title + "', '" + content + "', " + score + ")"; // st.executeUpdate(sql); // rs = st.executeQuery("select id from cloze_content order by id desc"); // rs.next(); // return rs.getInt("id"); // //rs.close(); // } // public void AddClozeAll(String title, int score, String content, String[] option, int[] answer) throws Exception // { // //写入title和content（cloze_content表），并获取刚刚插入content的ID // st = ConnMysql.initConn().createStatement(); // String sql; // sql = "insert into cloze_content(title, content, score) values('" + title + "', '" + content + "', " + score + ")"; // st.executeUpdate(sql); // rs = st.executeQuery("select id from cloze_content order by id desc"); // rs.next(); // int contentId = rs.getInt("id"); // // System.out.println(contentId); // // //写入选项(cloze_option表) // int choiceNum = 4; // // for(int i = 0; i <option.length; i++) // { // sql = "insert into cloze_option(content_id, question_id, option_content, is_answer) values(" + contentId + ", " + i/choiceNum + ", '" + option[i] + "', " + answer[i] + ")"; // st.executeUpdate(sql); // } // } //添加一道完型填空题 public void AddClozeObj(ClozeInfo ci) throws Exception { System.out.println("执行函数"); //写入title和content（cloze_content表），并获取刚刚插入content的ID st = ConnMysql.initConn().createStatement(); String sql; sql = "insert into cloze_content(title, content, score) values('" + ci.getTitle() + "', '" + ci.getContent() + "', " + ci.getScore() + ")"; st.executeUpdate(sql); rs = st.executeQuery("select id from cloze_content order by id desc"); rs.next(); int contentId = rs.getInt("id"); //获取刚刚插入的ID System.out.println(contentId); /*//输出测试 for(int j = 0; j < ci.getOptionList().size(); j++) { System.out.print(j + "abc--"); System.out.print(ci.getOptionList().get(j).getOption_content() + "-"); System.out.println(ci.getOptionList().get(j).getIs_answer()); } */ //写入选项(cloze_option表) int optionNum = 4; for(int i = 0; i < ci.getOptionList().size(); i++) { sql = "insert into cloze_option(content_id, question_id, option_content, is_answer) values(" + contentId + ", " + i/optionNum + ", '" + ci.getOptionList().get(i).getOption_content() + "', " + ci.getOptionList().get(i).getIs_answer()+ ")"; //sql = "insert into cloze_option(content_id, question_id, option_content, is_answer) values(" + contentId + ", " + i/optionNum + ", 'aaa', 1)"; st.executeUpdate(sql); } System.out.println("执行了函数"); rs.close(); st.close(); } //获取所有题目列表（包含所有数据） public List<ClozeInfo> GetClozeList(int pageSize, int page) throws Exception { List<ClozeInfo> ClozeList = new ArrayList<ClozeInfo>(); String sqlContent,sqlOption; st = ConnMysql.initConn().createStatement(); st2 = ConnMysql.initConn().createStatement(); sqlContent = "select * from cloze_content order by id desc"; rs = st.executeQuery(sqlContent); //逐一获取完型ClozeInfo对象 for(int i = 0; /*i < pageSize && */rs.next(); i++) { //获取title、content和score（cloze_content表） ClozeInfo ci = new ClozeInfo(); ci.title = rs.getString("title"); ci.content = rs.getString("content"); ci.score = rs.getInt("score"); //获取选项和答案(cloze_option表) sqlOption = "select * from cloze_option where content_id = " + rs.getInt("id"); rs2 = st2.executeQuery(sqlOption); while(rs2.next()) { ClozeOption co = new ClozeOption(); co.option_content = rs2.getString("option_content"); co.is_answer = rs2.getInt("is_answer"); ci.optionList.add(co); } //放入List数组 ClozeList.add(ci); } return ClozeList; } //获取一道题目全部数据 public ClozeInfo GetClozeObj(int clozeId) throws Exception { st = ConnMysql.initConn().createStatement(); String sql; //查询短文标题、内容和分值 sql = "select * from cloze_content where id = " + clozeId; rs = st.executeQuery(sql); rs.next(); ClozeInfo ci = new ClozeInfo(); ci.title = rs.getString("title"); ci.content = rs.getString("content"); ci.score = rs.getInt("score"); //查询选项信息 sql = "select * from cloze_option where content_id = " + clozeId; rs = st.executeQuery(sql); while(rs.next()) { ClozeOption co = new ClozeOption(); co.option_content = rs.getString("option_content"); co.is_answer = rs.getInt("is_answer"); ci.optionList.add(co); } return ci; } // public static void main(String[] args) throws Exception // { // ConnMysql cm = new ConnMysql(); // ClozeInfo ci = new ClozeInfo(); // ci = cm.GetClozeObj(108); // //输出测试 // System.out.println("标题:"+ci.title+"\t内容:"+ci.content); // for(int i = 0; i < ci.optionList.size(); i++) // { // System.out.print("选项："+ci.optionList.get(i).option_content); // System.out.println("答案："+ci.optionList.get(i).is_answer); // } // cm.GetClozeList(20,1); // //输出所有题目详细信息测试 // List<ClozeInfo> cl = new ArrayList<ClozeInfo>(); // cl = cm.GetClozeList(50, 1); // for(int i = 0; i < cl.size(); i++) // { // System.out.println("标题："+cl.get(i).title+"\t内容:"+cl.get(i).content+"\t分值："+cl.get(i).score); // for(int j = 0; j < cl.get(i).optionList.size(); j++) // { // System.out.print("选项:"+cl.get(i).optionList.get(j).option_content); // System.out.println("答案:"+cl.get(i).optionList.get(j).is_answer); // } // } // } }