请问各位大侠,在servlet文件中有spring bao.jar包.为什么编译不了?提示找不到bao包.
是要在系统变量中加入什么吗?我下了整个spring framekwork就是知要放到哪?
package servlet;import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import dao.DataCourse;
public class AddCourseForm extends HttpServlet { /**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy();
是要在系统变量中加入什么吗?我下了整个spring framekwork就是知要放到哪?
package servlet;import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import dao.DataCourse;
public class AddCourseForm extends HttpServlet { /**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy();
这是什么包,从哪里来的?
此时指向tomcat的lib中的servlet-api即可。
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;import org.DataBaseConn;import bean.Course;
import bean.StuCourse;
import bean.Student;public class DataCourse { DataBaseConn dbc = new DataBaseConn();
//查询所有课程信息
public List<Course> allCourses(){
List<Course> allCourse = new ArrayList<Course>();
String sql = "select c.courseID ,c.courseName ,c.courseCredit ,c.totalScore,c.re ,t.teacherName from stu_course c join stu_teaCourse tc on c.courseID = tc.courseID left join stu_teacher t on tc.tID = t.tID";
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
ResultSet rs = psmt.executeQuery();
while(rs.next()){
Course cs = new Course();
cs.setCourseID(rs.getInt(1));
cs.setCourseName(rs.getString(2));
cs.setCourseCredit(rs.getInt(3));
cs.setTotalScore(rs.getInt(4));
cs.setRe(rs.getString(5));
cs.setTeacherName(rs.getString(6));
allCourse.add(cs);
}
psmt.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
dbc.closeConn();
}
return allCourse;
}
//根据课程编号查询该课程信息
public Course selectCourseByCID(int cID){
Course course = null;
String sql = "select * from stu_course where courseID = ?";
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
psmt.setInt(1,cID);
ResultSet rs = psmt.executeQuery();
if(rs.next()){
course = new Course();
course.setCourseID(rs.getInt(1));
course.setCourseName(rs.getString(2));
course.setCourseCredit(rs.getInt(3));
course.setTotalScore(rs.getInt(4));
course.setRe(rs.getString(5));
}
psmt.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
dbc.closeConn();
}
return course;
}
//根据课程名称查询该课程信息
public Course selectCourseByCName(String cname){
Course course = null;
String sql = "select * from stu_course where courseName = ?";
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
psmt.setString(1,cname);
ResultSet rs = psmt.executeQuery();
if(rs.next()){
course = new Course();
course.setCourseID(rs.getInt(1));
course.setCourseName(rs.getString(2));
course.setCourseCredit(rs.getInt(3));
course.setTotalScore(rs.getInt(4));
course.setRe(rs.getString(5));
}
psmt.close();
} catch (Exception e) {
System.out.println("DataCourse-selectCourseByCName操作失败!");
e.printStackTrace();
}finally{
dbc.closeConn();
}
return course;
}
//添加课程记录信息
public boolean addCourse(String courseName,int courseCredit,int totalScore,String teacherID,String re){
boolean flag = false;
String sql = "insert into stu_course values(null,?,?,?,?,?)";
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
psmt.setString(1, courseName);
psmt.setInt(2,courseCredit);
psmt.setInt(3, totalScore);
psmt.setString(4,teacherID);
psmt.setString(5,re);
psmt.executeUpdate();
flag = true;
psmt.close();
} catch (Exception e) {
flag = false;
System.out.println("DataCourse添加记录addCourse操作失败!");
e.printStackTrace();
}finally{
dbc.closeConn();
}
return flag;
}
//根据登录学生 查询该学生选课信息
public List<Course> selectCourseBySID(int sid){
List<Course> myCourses = new ArrayList<Course>();
Course course = null;
String sql = "select c.courseID ,c.courseName ,c.courseCredit,c.totalScore ,sc.score from stu_course c " +
" join stu_stuCourse sc " +
" on c.courseID = sc.courseID " +
" where sc.ID = ?";
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
psmt.setInt(1,sid);
ResultSet rs = psmt.executeQuery();
while(rs.next()){
course = new Course();
course.setCourseID(rs.getInt(1));
course.setCourseName(rs.getString(2));
course.setCourseCredit(rs.getInt(3));
course.setTotalScore(rs.getInt(4));
myCourses.add(course);
}
psmt.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
dbc.closeConn();
}
return myCourses;
}
//获取课程总记录数
public int CourseTypesAmount(){
int courseAmount = 0;
String sql = "select count(*) from stu_course";
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
ResultSet rs = psmt.executeQuery();
if(rs.next()){
courseAmount = rs.getInt(1);
}
psmt.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
dbc.closeConn();
}
return courseAmount;
}
//查询所有学生记录信息(分页显示)
public List<Course> allcourseFen(int pageNumber,int pageSize){
List<Course> allCourse = new ArrayList<Course>();
String sql = "select c.courseID,c.courseName,c.courseCredit,c.totalScore,c.re,t.teacherName from stu_course c left join stu_teaCourse tc " +
"on c.courseID = tc.courseID join stu_teacher t " +
"on tc.tID = t.tID " +
"limit "+pageSize*(pageNumber-1)+","+pageSize;
// System.out.println(sql);
PreparedStatement psmt = null;
try {
psmt = dbc.getConn().prepareStatement(sql);
ResultSet rs = psmt.executeQuery();
while(rs.next()){
Course course = new Course();
course.setCourseID(rs.getInt(1));
course.setCourseName(rs.getString(2));
course.setCourseCredit(rs.getInt(3));
course.setTotalScore(rs.getInt(4));
course.setRe(rs.getString(5));
course.setTeacherName(rs.getString(6));
allCourse.add(course);
}
psmt.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
dbc.closeConn();
}
return allCourse;
}
}