-
大小: 1.25MB文件類型: .zip金幣: 2下載: 0 次發(fā)布日期: 2023-08-29
- 語言: Java
- 標(biāo)簽: jsp??選課系統(tǒng)??
資源簡介
jsp平臺編寫，數(shù)據(jù)庫是mysql。系統(tǒng)可供學(xué)生，管理員，老師三方使用，學(xué)生可以選課，老師可以開課，管理員可以增加老師和同學(xué)等信息，并有系統(tǒng)的簡介及截圖，挺好用的！
代碼片段和文件信息
package?homework;
import?java.sql.*;
import?javax.naming.*;
import?javax.sql.DataSource;
import?java.io.*;
?
public?class?ChouseCoure
{
?private?String?AdminAcc;
?private?String?AdminPwd;
?private?String?AdminType;
?private?ResultSet?rs;
?private?int?i;
?private?Connection?conn;
?private?Statement?stmt;
String?url?=?“jdbc:mysql://localhost/sql_test“;
String?userName=“root“;
String?password=“123“;
?
?public?ChouseCoure（）?throws?Exception
????{
conn?=?null;
stmt?=?null;
rs?=?null;
String?url?=?“jdbc:mysql://localhost/sql_test“;
String?userName=“root“;
String?password=“123“;
String?sql=null;
Connection?conn=null;
Statement?stmt=null;
try
{??
Class.forName（“com.mysql.jdbc.Driver“）;
conn=DriverManager.getConnection（url?userName?password）;
}
catch（SQLException?e）?
{
System.out.print（“It?is?wrong“）;
}
}
??
?public?ResultSet?executeQuery（String?sql）?{?
?rs=null;?
?try?{?
//?String?sConnStr?=?“jdbc:mysql://localhost/sql_test“;
conn=DriverManager.getConnection（urluserName?password）;??
?stmt=conn.createStatement（）;?
?rs=stmt.executeQuery（sql）;?
?}??
?catch（SQLException?ex）?{??
?System.err.println（“aq.executeQuery:?“?+?ex.getMessage（））;?
?System.err.println（“aq.executeQuerystrSQL:?“?+?sql）;?
?}?
?return?rs;?
?}?
?public??int??executeUpdate（String?sql）?{?
?try?{?
//?String?sConnStr?=?“jdbc:mysql://localhost/sql_test“;
conn=DriverManager.getConnection（urluserName?password）;??
?stmt=conn.createStatement（）;?
?i?=stmt.executeUpdate（sql）;?
?}??
?catch（SQLException?ex）?{??
?System.err.println（“aq.executeUpdate:?“?+?ex.getMessage（））;?
?System.err.println（“aq.executeUpadatestrSQL:?“?+?sql）;?
?}?
?return?i;
?}?
// 用來顯示中文字體；
public?String?getStr（String?str）?{
try?{
String?temp_p=str;
byte[]?temp_t=temp_p.getBytes（“ISO8859-1“）;
String?temp=new?String（temp_t）;
return?temp;
}
catch（Exception?e）?{
e.printStackTrace（）;
}
return?“null“;
}
public?void?closeCon（）{
if（rs?!=?null）{
try{
rs.close（）;
}catch（SQLException?e）{e.printStackTrace（）;}
rs?=?null;
}
if（stmt?!=?null）{
try{
stmt.close（）;
}catch（SQLException?e）{e.printStackTrace（）;}
stmt?=?null;
}
if（conn?!=?null）{
try{
conn.close（）;
}catch（SQLException?e）{e.printStackTrace（）;}
conn?=?null;
}
}
public?static?void?main（String?args[]）
{
ChouseCoure?a?=?null;
try?{
a?=?new?ChouseCoure（）;
}?catch?（Exception?e）?{
//?TODO?自動生成?catch?塊
e.printStackTrace（）;
}
a.executeUpdate（“update?student?set?psw=‘123‘?where?sid=‘200701‘“）;
}
}
//錯誤：It?is?wrongaq.executeUpdate:?Access?denied?for?user?‘‘@‘localhost‘?（using?password:?NO）
//aq.executeUpadatestrSQL:?update?student?set?spsw=‘123‘?where?sno=‘01‘
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2009-02-23?19:01??jsp學(xué)生選課系統(tǒng)\
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\
?????文件?????????533??2008-12-22?18:23??jsp學(xué)生選課系統(tǒng)\jsp\.classpath
?????文件?????????849??2008-12-22?18:23??jsp學(xué)生選課系統(tǒng)\jsp\.project
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\.settings\
?????文件?????????330??2008-12-22?18:23??jsp學(xué)生選課系統(tǒng)\jsp\.settings\org.eclipse.jdt.core.prefs
?????文件?????????364??2008-12-22?18:23??jsp學(xué)生選課系統(tǒng)\jsp\.settings\org.eclipse.jst.common.project.facet.core.prefs
?????文件?????????396??2008-12-22?18:23??jsp學(xué)生選課系統(tǒng)\jsp\.settings\org.eclipse.wst.common.component
?????文件?????????269??2008-12-22?18:23??jsp學(xué)生選課系統(tǒng)\jsp\.settings\org.eclipse.wst.common.project.facet.core.xm
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\build\
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\build\classes\
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\build\classes\homework\
?????文件????????3344??2008-12-26?22:08??jsp學(xué)生選課系統(tǒng)\jsp\build\classes\homework\ChouseCoure.class
?????文件?????????651??2008-12-26?22:08??jsp學(xué)生選課系統(tǒng)\jsp\build\classes\homework\deal.class
?????文件?????????708??2008-12-26?22:08??jsp學(xué)生選課系統(tǒng)\jsp\build\classes\homework\Getdate.class
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\src\
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\src\homework\
?????文件????????2879??2008-12-22?23:28??jsp學(xué)生選課系統(tǒng)\jsp\src\homework\ChouseCoure.java
?????文件?????????241??2008-12-26?16:11??jsp學(xué)生選課系統(tǒng)\jsp\src\homework\deal.java
?????文件?????????288??2008-12-26?16:11??jsp學(xué)生選課系統(tǒng)\jsp\src\homework\Getdate.java
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\
?????目錄???????????0??2008-12-28?13:51??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\
?????文件????????5416??2008-12-26?17:42??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin.jsp
?????文件????????2296??2008-12-23?16:33??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\addStuConfirm.jsp
?????文件????????5089??2008-12-23?13:23??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\addStudent.jsp
?????文件????????4607??2008-12-24?17:05??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\addTeacher.jsp
?????文件????????2163??2008-12-23?16:27??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\addTeaConfirm.jsp
?????文件????????3480??2008-12-23?17:08??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\countStuConfirm.jsp
?????文件????????1477??2008-12-23?16:41??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\countStudent.jsp
?????文件????????1477??2008-12-23?17:09??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\countTeacher.jsp
?????文件????????3412??2008-12-23?17:14??jsp學(xué)生選課系統(tǒng)\jsp\WebContent\admin\countTeaConfirm.jsp
............此處省略57個文件信息
評論
共有 條評論
川公網(wǎng)安備 51152502000135號