mysql教研室_spring MVC+mysql开发java web黔南医专英语教研室情景英语平台,可用于java web毕业设计系统...

package cn.st.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import cn.st.entity.Judge;

import cn.st.query.Page;

import cn.st.util.ConnDB;

public class JudgeDao {

/**

* 导入判断题

*/

public boolean addJudge(Judge judge) {

boolean bol=false;

Connection conn=null;

PreparedStatement ps=null;

String sql="insert into tbl_judge(question,r_true,r_wrong,answer,parse)"

+ " values(?,?,?,?,?)";

conn=ConnDB.getConnection();//获取数据库连接

try {

ps=conn.prepareStatement(sql);//预处理sql语句

ps.setString(1, judge.getQuestion());//实体对象通过get方法获取值set到数据表中

ps.setInt(2, judge.getR_true());

ps.setInt(3, judge.getR_wrong());

ps.setInt(4, judge.getAnswer());

ps.setString(5, judge.getParse());

ps.executeUpdate();

bol=true;//数据添加成功后返回ture

System.out.println("判断题导入成功！！！");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

try {

ps.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return bol;

}

/**

* 查看判断题

*/

public Page queryAllJudgeIng(Page page) {

List list=new ArrayList();//实例化链表对象用于存取数据

Judge judge=null;//声明实例化实体对象(判断题)

Connection conn=null;

PreparedStatement ps=null;

ResultSet rs=null;

StringBuffer sql =new StringBuffer("select * from tbl_judge where 1=1");

//分页限制

if (page.getCurrentPage() == 1) {

sql.append(" limit " + page.getPageSize());

} else {

sql.append(" limit " + (page.getCurrentPage()-1) * page.getPageSize() + "," + page.getPageSize() );

}

conn=ConnDB.getConnection();//获取数据库连接

try {

ps=conn.prepareStatement(sql.toString());

rs=ps.executeQuery();

while (rs.next()) {

judge=new Judge();

judge.setQuestion(rs.getString("question"));

judge.setR_true(rs.getInt("r_true"));

judge.setR_wrong(rs.getInt("r_wrong"));

judge.setAnswer(rs.getInt("answer"));

judge.setParse(rs.getString("setParse"));

judge.setParse(rs.getString("parse"));

list.add(judge);//将实体对象的值添加到链表对象中

System.out.println("判断题数据查询成功"+judge.getQuestion());

}

page.setResult(list);//将链表的结果集分页

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

try {

//关闭资源流

rs.close();

ps.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return page;

}

/**

* 统计选择题

*/

public long countJudge() {

long count=0;

Connection conn=null;

PreparedStatement ps=null;

ResultSet rs=null;

String sql="select count(*) as c from tbl_judge";

conn=ConnDB.getConnection();//获取数据库连接

try {

ps=conn.prepareStatement(sql);//预处理sql语句

rs=ps.executeQuery();

while (rs.next()) {

count=rs.getLong("c");

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

//关闭资源流

try {

rs.close();

ps.close();

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return count;

}

}