package cn.com.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


import cn.com.entity.Question;
import cn.com.utils.DBUtils;


public class QuDao {
	Connection conn;
	PreparedStatement pst;
	ResultSet rs;
	public int addpj(Question qu) {
		// TODO Auto-generated method stub
		int i = 0;
		try {
			conn = DBUtils.getConn();
			String sql = "insert into question values(?,?,?,?,?)";
			pst = conn.prepareStatement(sql);
			pst.setInt(1, qu.getQid());
			pst.setInt(2, qu.getQpj());
			pst.setInt(3, qu.getQlx());
			pst.setString(4, qu.getQtxt());
			pst.setString(5, qu.getTid());
			
			i = pst.executeUpdate();
			System.out.println("!!!!!!!!!!!!!!!!!!!!");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DBUtils.closeResouce(conn, pst);
		}
		return i;
	}

}