datadao.java

选课系统,基于SSH2的选课系统,欢迎下载

					pr.setString(1, sno);
					re = pr.executeQuery();
					if (re.next()) {
						cxianxuannianji1 = re.getString("student_info.snianji");
					}
					//System.out.println(nianji);
					//System.out.println(cxianxuannianji1);
					if (cxianxuannianji1.equals(nianji)) {
						pr = conn.prepareStatement("select course_info.cno,course_info.cname,course_info.ctno,course_info.ctname,course_info.ctime,course_info.caddress from course_info where course_info.cno=?");
						pr.setString(1, cno);
						re = pr.executeQuery();
						// System.out.println(nianji);
						if (re.next()) {
							ecno = re.getString("course_info.cno");
							ecname = re.getString("course_info.cname");
							etno = re.getString("course_info.ctno");
							etname = re.getString("course_info.ctname");
							ectime = re.getString("course_info.ctime");
							ecaddress = re.getString("course_info.caddress");
						}
						// System.out.println("...."+ecno+ecname+etno+etname+ectime+ecaddress);

						pr = conn
								.prepareStatement("insert into elected_info(esno,esname,esbanji,esxibu,ecno,ecname,etno,etname,ectime,ecaddress) values(?,?,?,?,?,?,?,?,?,?)");
						pr.setString(1, esno);
						pr.setString(2, esname);
						pr.setString(3, esbanji);
						pr.setString(4, esxibu);
						pr.setString(5, ecno);
						pr.setString(6, ecname);
						pr.setString(7, etno);
						pr.setString(8, etname);
						pr.setString(9, ectime);
						pr.setString(10, ecaddress);
						flag = pr.executeUpdate();

						pr = conn
								.prepareStatement("select course_info.cselectednum from course_info where course_info.cno=?");
						pr.setString(1, cno);
						re = pr.executeQuery();
						if (re.next()) {
							xianxuanshu = Integer.valueOf(re
									.getString("course_info.cselectednum"));
						}
						xianxuanshu += 1;
						// update table1 set field1=value1 where
						pr = conn
								.prepareStatement("update course_info set cselectednum=? where course_info.cno=?");
						pr.setLong(1, xianxuanshu);
						pr.setString(2, cno);
						pr.executeUpdate();
					} else {
						//System.out.println("超出限选年级");
						flag = 9002;// 超出限选年级
					}
				} else {
					// System.out.println("超出限选人数");
					flag = 9001;// 超出限选人数
				}
			} else {
				flag = 9000;
				// System.out.println("选课重复!!!");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}

	// delete from table1 where
	// update table1 set field1=value1 where
	public int tuike(String sno, String cno) {
		int electednum = 0;
		int flag = 0;
		try {
			pr = conn
					.prepareStatement("delete from elected_info where elected_info.esno=?");
			pr.setString(1, sno);
			flag = pr.executeUpdate();

			pr = conn
					.prepareStatement("select course_info.cselectednum from course_info where course_info.cno=?");
			pr.setString(1, cno);
			re = pr.executeQuery();
			if (re.next()) {
				electednum = Integer.valueOf(re
						.getString("course_info.cselectednum"));
			}
			electednum = electednum - 1;

			pr = conn
					.prepareStatement("update course_info set course_info.cselectednum=? where course_info.cno=?");
			pr.setLong(1, electednum);
			pr.setString(2, cno);
			flag = pr.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return flag;
	}
	//update table1 set field1=value1 where 范围
	public int chengjicharu(String sno,String chengji){
		int flag = 0;
			try {
				pr = conn.prepareStatement("update elected_info set echengji=? where elected_info.esno=?");
				pr.setString(1, chengji);
				pr.setString(2, sno);
				flag = pr.executeUpdate();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return flag;
	}
	
	//sno;sname; spassword; sxibu; sbanji; sxianxuanshu; snianji; sid;
	public ResultSet managerStudent() {
		try {
			st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			re = st
					.executeQuery("select s.sno,s.sname,s.spassword,s.sxibu,s.sbanji,s.sxianxuanshu,s.snianji,s.sid from student_info s  order by s.sno");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return re;
	}
	
	public int managerstudentxiugai(String sno,String sname,String spassword,String sxibu,String sbanji,String sxianxuanshu,String snianji,String sid) {
		int flag = 0;
		try {
			pr = conn.prepareStatement("update student_info set sname=?,spassword=?,sxibu=?,sbanji=?,sxianxuanshu=?,snianji=?,sid=? where sno=?");
			pr.setString(1, sname);
			pr.setString(2, spassword);
			pr.setString(3, sxibu);
			pr.setString(4, sbanji);
			pr.setString(5, sxianxuanshu);
			pr.setString(6, snianji);
			pr.setString(7, sid);
			pr.setString(8, sno);
			flag = pr.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
	
	
	
	public ResultSet managerTeacher() {
		try {
			st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			re = st
					.executeQuery("select t.tno,t.tname,t.tpassword,t.txibu,t.tjieshao from teacher_info t order by t.tno");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return re;
	}
	
	public int managerteacherxiugai(String tno,String tname,String tpassword,String txibu,String tjieshao) {
		int flag = 0;
		try {
			pr = conn.prepareStatement("update teacher_info set tname=?,tpassword=?,txibu=?,tjieshao=? where tno=?");
			pr.setString(1, tname);
			pr.setString(2, tpassword);
			pr.setString(3, txibu);
			pr.setString(4, tjieshao);
			pr.setString(5, tno);
			flag = pr.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
	
	
	//cno;cname;ctno;ctname;cxibu;cjieshao;ctime;caddress;cxianxuanshu;cxianxuannianji;cselectednum;
	public ResultSet managerCourse() {
		try {
			st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			re = st
					.executeQuery("select c.cno,c.cname,c.ctno,c.ctname,c.cxibu,c.cjieshao,c.ctime,c.caddress,c.cxianxuanshu,c.cxianxuannianji,c.cselectednum from course_info c order by c.cno");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return re;
	}
	
//	cno;cname;ctno;ctname;cxibu;cjieshao;ctime;caddress;cxianxuanshu;cxianxuannianji;cselectednum;
	public int managercoursexiugai(String cno,String cname,String ctno,String ctname,String cxibu,String cjieshao,String ctime,String caddress,String cxianxuanshu,String cxianxuannianji,String cselectednum) {
		int flag = 0;
		try {
			pr = conn.prepareStatement("update course_info set cname=?,ctno=?,ctname=?,cxibu=?,cjieshao=?,ctime=?,caddress=?,cxianxuanshu=?,cxianxuannianji=?,cselectednum=? where cno=?");
			pr.setString(1, cname);
			pr.setString(2, ctno);
			pr.setString(3, ctname);
			pr.setString(4, cxibu);
			pr.setString(5, cjieshao);
			pr.setString(6, ctime);
			pr.setString(7, caddress);
			pr.setString(8, cxianxuanshu);
			pr.setString(9, cxianxuannianji);
			pr.setString(10, cselectednum);
			pr.setString(11, cno);
			flag = pr.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
	

//	public void cloes() {
//		try {
//			if (conn != null){
//				conn.close();
//			System.out.print("conn.close()"+"....");
//			}
//		} catch (SQLException e) {
//			e.printStackTrace();
//		}
//	}

}