资源简介
本排课管理软件归纳起来,好处大约有以下几点:
1. 可以存储历届的排课,安全、高效;
2. 只需一到二名排课录入员即可操作系统,节省大量人力;
3. 可以按照录入人员的输入来自动生成课程表,并尽量减少冲突等情况发生。
包含数据库文件论文资料源文件以及运行文件
1. It can store all previous courses, which is safe and efficient;
2. Only one or two course arrangement entry personnel can operate the system, saving a lot of manpower;
3. The course schedule can be automatically generated according to the input of the entry personnel, and conflicts can be minimized.
Including database files, paper source files and running files)
代码片段和文件信息
package com.bean;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import com.util.*;
public class AllBean {
Connection conn = null;
Statement st = null;
ResultSet rs = null;
ArrayList kecheng = new ArrayList();
ArrayList laoshi = new ArrayList();
ArrayList jiaoshi = new ArrayList();
ArrayList kechengtime = new ArrayList();
ArrayList zhuanye = new ArrayList();
ArrayList banji = new ArrayList();
ArrayList xueshengchaxun = new ArrayList();
public ArrayList getKecheng(){
conn = DBConn.getConn();
try {
st = conn.createStatement();
rs = st.executeQuery(“select a.*b.* from kecheng azhuanye b where a.zhuanyeid=b.zhuanyeid“);
while(rs.next()){
ArrayList alRow = new ArrayList();
alRow.add(rs.getString(1));
alRow.add(rs.getString(2));
alRow.add(rs.getString(3));
alRow.add(rs.getString(4));
alRow.add(rs.getString(5));
alRow.add(rs.getString(6));
alRow.add(rs.getString(7));
alRow.add(rs.getString(9));
kecheng.add(alRow);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBConn.close(connstrs);
}
return kecheng;
}
public ArrayList getLaoshi(){
conn = DBConn.getConn();
try {
st = conn.createStatement();
rs = st.executeQuery(“select * from laoshi“);
while(rs.next()){
ArrayList alRow = new ArrayList();
alRow.add(rs.getString(1));
alRow.add(rs.getString(2));
alRow.add(rs.getString(3));
laoshi.add(alRow);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConn.close(connstrs);
}
return laoshi;
}
public ArrayList getjiaoshi(){
conn = DBConn.getConn();
try {
st = conn.createStatement();
rs = st.executeQuery(“select * from jiaoshi“);
while(rs.next()){
ArrayList alRow = new ArrayList();
alRow.add(rs.getString(1));
alRow.add(rs.getString(2));
alRow.add(rs.getString(3));
jiaoshi.add(alRow);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConn.close(connstrs);
}
return jiaoshi;
}
public ArrayList getKechengtime(){
conn = DBConn.getConn();
try {
st = conn.createStatement();
rs = st.executeQuery(“select a.kechengida.kechengmingb.begintimeb.endtime from kecheng akechengtime b where a.kechengid *=b.kechengid“);
while(rs.next()){
ArrayList alRow = new ArrayList();
alRow.add(rs.getString(1));
alRow.add(rs.getString(2));
alRow.add(rs.getString(3));
alRow.add(rs.getString(4));
kechengtime.add(alRow);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConn.close(connstrs);
}
return kechengtime;
}
public ArrayList getZhuanye(){
conn = DBConn.getConn();
try {
st = conn.createStatement();
rs = st.executeQuery(“select * from zhuanye“);
while(rs.next()){
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
文件 50493 2004-05-04 20:23 sqlserver-driver\jsp-api.jar
文件 286707 2002-11-21 16:40 sqlserver-driver\msba
文件 67024 2002-11-21 16:40 sqlserver-driver\mssqlserver.jar
文件 58903 2002-11-21 16:40 sqlserver-driver\msutil.jar
文件 97523 2004-05-04 20:23 sqlserver-driver\servlet-api.jar
文件 440483 2005-10-10 15:59 sqlserver-driver\mysql-connector-java-3.1.11-bin.jar
目录 0 2007-03-09 14:40 sqlserver-driver
----------- --------- ---------- ----- ----
1001133 7
- 上一篇:MG
- 下一篇:JAVA文件压缩与解压缩实践
相关资源
- JAVA文件压缩与解压缩实践
- JAVA语言程序设计与数据结构第十一版
- 水库调度java程序
- java大型OA管理系统
- java高速文件缓存
- Java大数据视频加源码 全集免费
- 黑马Java基础教程,完整版从入门到精
- 2019最新Java面试题视频讲解
- Java RSA 分段加密解密工具 .NET密钥转换
- mysql数据库JDBC驱动mysql-connector-java-5
- javax jar集合包
- JAVA从无到有构建大型电商微服务架构
- 从数据库动态生成树形菜单的JSP实现
- Eclipse运行时提示failed to create the jav
- Java EE 8 Cookbook-Packt Publishing(2018)
- Java8新特性练习.zip
- javax.mail.1.4.7.jar
- javamail的jar包:javamail-1.6
- 学生考勤管理系统的设计与实现.doc
- javaweb教务管理系统项目设计.zip
- 最新201808达内Java大数据web阶段商城
- Selenium2 Java自动化测试实战 第二版
- 学生信息管理系统.zip
- 自考04747Java语言程序设计(一) 视频
- 阿里巴巴编码规范Java满分答卷
- 华为C++/C/java代码规范完整版
- 基于Java的煤矿安全监控系统通用软件
- JAVA JSP物流管理系统 源代码 论文
- Java源程序之简易计算器的设计
- 酒店订餐管理系统.zip
评论
共有 条评论