PK系统核心代码Word下载.docx
- 文档编号:21205294
- 上传时间:2023-01-28
- 格式:DOCX
- 页数:27
- 大小:22.40KB
PK系统核心代码Word下载.docx
《PK系统核心代码Word下载.docx》由会员分享,可在线阅读,更多相关《PK系统核心代码Word下载.docx(27页珍藏版)》请在冰豆网上搜索。
publicjava.sql.ConnectiongetConnectionByUrl()
{
Connectioncon=null;
try
{
Class.forName(DriverClass);
con=DriverManager.getConnection(connectinURL);
returncon;
}catch(Exceptionerr)
err.printStackTrace();
returncon;
//
publicjava.sql.ConnectiongetConnection(){
if(this.connection==null)
try{
Class.forName(DriverClass);
connection=DriverManager.getConnection(connectinURL);
returnconnection;
}catch(Exceptione)
e.printStackTrace();
returnthis.connection;
publicCachedRowSetgetResultSet(Stringsql)
CachedRowSetresultset=null;
try
resultset=newCachedRowSetImpl();
resultset.setCommand(sql);
resultset.execute(this.getConnection());
if(resultset.size()>
0)
returnresultset;
else
{
resultset.close();
resultset.release();
returnnull;
}
err.printStackTrace();
throwerr;
}finally
publicCachedRowSetgetResultSetByUrl(Stringsql)
resultset.execute(this.getConnectionByUrl());
//函数exeSqlNoQuery用于执行向数据库中插入、修改和删除数据
publicintexeUpdate(Stringsql)
intresult=0;
Statementstatement=this.getConnectionByUrl().createStatement();
result=statement.executeUpdate(sql);
statement.close();
returnresult;
result=-1;
//发生异常返回-1
returnresult;
publicintexeSqlNoQuery(Stringsql)
Statementstatement=getConnection().createStatement();
publicvoidbeginTransaction()
this.connection.setAutoCommit(false);
}catch(SQLExceptionerr)
//提交事务
publicvoidcommitTransaction()
mit();
}catch(SQLExceptionerr)
}
//回滚事务
publicvoidrollbackTransaction()
try{
this.connection.rollback();
}
//释放资源
publicvoidrelease()
if(connection!
=null)
if(!
connection.isClosed())
connection.close();
connection=null;
}
********************************************************************
*系统登录action
*@authorheshuai
publicclassLoginActionextendsAction
publicStringprocess(HttpServletRequestrequest,HttpServletResponseresponse)
StringuserName=request.getParameter("
userName"
);
Stringpassword=request.getParameter("
password"
if(userName!
=null)userName=userName.trim();
if(password!
=null)password=password.trim();
System.out.println("
inLoinAction:
userName="
+userName);
Stringview="
"
DBdb=newDB();
Connectionconnection=db.getConnection();
//获取数据库连接
Statementstatement=connection.createStatement();
Stringsql="
selectU.Actor,F.functionID,F.functionName,F.FileName"
sql+="
fromUSERSU,FunctionsF,PowerAssignPwhere"
userID='
+userName+"
'
andpassword='
+password+"
sql+="
andU.Actor=P.Actor"
andF.FunctionID=P.FunctionID"
groupbyU.Actor,F.functionID,F.functionName,F.FileName"
orderbyF.functionID"
ResultSetresult=statement.executeQuery(sql);
HashtablefunctionTable=newHashtable();
if(result.next())//如果用户存在,取出他可以访问的功能模块名和对应的文件
request.getSession().setAttribute("
userName);
if(result.getString("
FileName"
)!
functionTable.put(result.getString("
functionName"
),result.getString("
));
else
),"
#"
while(result.next())
if(result.getString("
result.close();
connection.close();
functionTable"
functionTable);
view="
/index.jsp"
}else//用户不存在或口令密码错
/login.jsp"
returnview;
*********************************************************************
*添加课程
publicclasscourseAdd2
implementsAction,SessionAware
Stringmessage="
操作成功,请返回!
StringclassID;
Coursecourse=null;
Mapsession=null;
publicvoidsetSession(Mapsession){this.session=session;
publicMapgetSession(){returnthis.session;
publicvoidsetClassID(StringclassID)
this.classID=classID;
publicStringgetClassID(){returnthis.classID;
publicvoidsetMessage(Stringmessage){
this.message=message;
publicStringgetMessage(){returnthis.message;
publicStringexecute()
Stringresult="
success"
DBdb=newDB();
DBanotherDb=newDB();
Stringsql="
CachedRowSetcrs=null;
this.course=((Course)this.session.get("
course"
if(this.course!
=null)
intcourseID=999;
booleanisNewCourse=false;
if((this.course.getNewCourseName()!
=null)&
&
(!
this.course.getNewCourseName().trim().equals("
))){
isNewCourse=true;
if(isNewCourse)
sql="
selectmax(courseID)fromcourse"
crs=anotherDb.getResultSet(sql);
if(crs.size()>
0)
while(crs.next())
atline83"
if(crs.getInt
(1)>
courseID=crs.getInt
(1)+1;
courseID++;
crs.close();
courseID=Integer.parseInt(this.course.getCourseID());
db.beginTransaction();
insertintocourse(courseID,CourseName,Period,CourseType,departmentID)"
sql=sql+"
values("
+courseID+"
'
+this.course.getNewCourseName()+"
"
+this.course.getHours()+"
sql=sql+this.course.getCourseType()+"
+this.course.getDepartmentID()+"
)"
sql:
+sql);
if(db.exeSqlNoQuery(sql)<
=0)
this.message="
添加新课程时发生错误!
result="
error"
db.rollbackTransaction();
else{
mitTransaction();
isNewCourse=false;
}else{
StringTokenizertokenizer=newStringTokenizer(this.classID,"
"
selectB.classID,B.major,YEAR(EntranceYear)Year"
fromscheduleA,classB"
whereA.classID=B.classID"
AndA.courseID="
+this.course.getCourseID();
AndA.classIDin('
while(tokenizer.hasMoreTokens())
sql=sql+tokenizer.nextToken()+"
sql=sql.substring(0,sql.length()-2)+"
if((crs.size()>
0)&
(crs.next()))
你重复给其中某个班级安排了该课程"
selectmax(UnitID)fromschedule"
intunitID=0;
unitID=crs.getInt
(1)+1;
insertintoschedule(UnitID,CourseID,TeacherID,roomType,ClassID)values"
("
+unitID+"
+this.course.getTeacherID()+"
+this.course.getRoomType()+"
tokenizer=newStringTokenizer(this.classID,"
Stringsql1="
sql1=sql+tokenizer.nextToken()+"
if(db.exeSqlNoQuery(sql1)<
添加课程计划时发生数据库错误!
break;
selectmax(coursetime)fromcoursetable"
intcoursetime=0;
if(crs.next())
coursetime=crs.getInt
(1)+1;
Stringsqlt="
insertintocoursetablevalues("
+coursetime+"
001102'
1'
0,20)"
db.exeSqlNoQuery(sqlt);
ActionContext.getContext().getSession().remove("
mitTransaction();
db.release();
anotherDb.release();
catch(Exceptionerr){
this.message=err.getMessage();
finally{
}returnresult;
查询课程代码(JSP中):
<
%@pagecontentType="
text/html;
charset=gb2312"
%>
%@pageimport="
java.sql.ResultSet"
%>
java.sql.Statement"
java.sql.Connection"
DBCommon.DB"
html>
head>
title>
chaxun
/title>
/head>
bodybgcolor="
>
%
request.setCharacterEncoding("
gb2312"
StringdepartmentID=request.getParameter("
departmentID"
StringcourseType=request.getParameter("
courseType"
StringCourseID=request.getParameter("
CourseID"
Stringhours=request.getParameter("
hours"
StringCourseName=request.get
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- PK 系统 核心 代码