資源簡介
主要是JSP汽車銷售網站的源代碼,界面友好,功能齊全,歡迎大家下載。

代碼片段和文件信息
package?bean;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;
public?class?AdminLoginBean?{
private?static?int?SUCCESS=1;
private?static?int?ERROR=2;
private?static?int?SAME=3;
private?ResultSet?rs;
//管理員登陸通用類
public?int?userLogin(String?usernameString?password){
String?sql=“select?*?from?admin?where?name?=‘“+username+“‘?and?password=‘“+password+“‘“;
DBO?dbo=new?DBO();
dbo.open();
try{
rs=dbo.executeQuery(sql);
if(rs.next()){//登陸驗證
return?this.SUCCESS;
}
else{
return?this.ERROR;
}
}catch(Exception?e){
e.printStackTrace();
return?this.ERROR;
}
finally{
dbo.close();
}
}
//增加管理員?
public?int?addUser(String?nameString?pwd){
String?sql=“insert?into?admin?values(‘“+name+“‘‘“+pwd+“‘)“;
DBO?dbo=new?DBO();
dbo.open();
try{
rs=dbo.executeQuery(“select?*?from?admin?where?name=‘“+name+“‘“);
if(rs.next()){//查看是否重名
return?this.SAME;
}
else{
int?i=dbo.executeUpdate(sql);
if(i==1){
return?this.SUCCESS;
}
else{
return?this.ERROR;
}
}
}catch(Exception?e){
return?this.ERROR;
}finally{
dbo.close();
}
}
public?List?getUser(){
String?sql=“select?id?name?from?admin?“;
DBO?dbo=new?DBO();
dbo.open();
List?list=new?ArrayList();
try{
rs=dbo.executeQuery(sql);
while(rs.next()){
List?list2=new?ArrayList();
list2.add(rs.getString(1));
list2.add(rs.getString(2));
list.add(list2);
}
return?list;
}catch(Exception?e){
return?list;
}finally{
dbo.close();
}
}
public?int?delUser(int?id){
String?sql=“delete?from?admin?where?id=‘“+id+“‘“;
DBO?dbo=new?DBO();
dbo.open();
try{
int?i=dbo.executeUpdate(sql);
if(i==1){
return?this.SUCCESS;
}
else{
return?this.ERROR;
}
}catch(Exception?e){
return?this.ERROR;
}finally{
dbo.close();
}
}
public?List?getUser(int?id){
String?sql=“select?id?namepassword?from?admin?where?id=‘“+id+“‘“;
DBO?dbo=new?DBO();
dbo.open();
List?list=new?ArrayList();
try{
rs=dbo.executeQuery(sql);
rs.next();
list.add(rs.getString(1));
list.add(rs.getString(2));
list.add(rs.getString(3));
return?list;
}catch(Exception?e){
return?list;
}finally{
dbo.close();
}
}
public?int?upUser(int?idString?nameString?pwd){
String?sql=“update?admin?set?name=‘“+name+“‘password=‘“+pwd+“‘?where?id=‘“+id+“‘“;
DBO?dbo=new?DBO();
dbo.open();
try{
int?i=dbo.executeUpdate(sql);
if(i==1){
return?this.SUCCESS;
}
else{
return?this.ERROR;
}
}catch(Exception?e){
e.printStackTrace();
return?this.ERROR;
}finally{
dbo.close();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-11-28?16:26??源程序\
?????文件?????????552??2008-12-17?15:15??源程序\.classpath
?????目錄???????????0??2014-12-04?20:45??源程序\.myeclipse\
?????文件?????????297??2009-05-25?16:53??源程序\.myme
?????文件????????1414??2009-05-25?17:16??源程序\.project
?????目錄???????????0??2014-11-28?16:26??源程序\.settings\
?????文件?????????500??2009-05-25?17:16??源程序\.settings\.jsdtscope
?????文件??????????49??2009-05-25?17:16??源程序\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2009-05-25?17:16??源程序\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-11-28?16:26??源程序\WebRoot\
?????目錄???????????0??2013-02-24?14:43??源程序\WebRoot\me
?????文件??????????39??2008-12-08?18:15??源程序\WebRoot\me
?????目錄???????????0??2014-11-28?16:26??源程序\WebRoot\WEB-INF\
?????目錄???????????0??2013-02-24?14:43??源程序\WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-11-28?16:26??源程序\WebRoot\WEB-INF\classes\bean\
?????文件????????3919??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\AdminLoginBean.class
?????文件????????5886??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\BookBean.class
?????文件????????2560??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\BookPageBean.class
?????文件????????1995??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\CommontBean.class
?????文件????????2407??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\CommontPageBean.class
?????文件????????2897??2009-05-25?16:56??源程序\WebRoot\WEB-INF\classes\bean\DBO.class
?????文件????????7101??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\DinggouBean.class
?????文件????????2448??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\GeRenPageBean.class
?????文件????????2497??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\MemberPageBean.class
?????文件????????1954??2009-05-25?20:03??源程序\WebRoot\WEB-INF\classes\bean\NewBean.class
?????文件????????3026??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\NewsBean.class
?????文件????????2398??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\NewsPageBean.class
?????文件???????12552??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\OrderBean.class
?????文件????????2379??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\OrderPageBean.class
?????文件???????15916??2009-05-30?15:29??源程序\WebRoot\WEB-INF\classes\bean\ProductBean.class
?????文件????????2604??2009-05-25?16:53??源程序\WebRoot\WEB-INF\classes\bean\ServletUpload.class
............此處省略252個文件信息
- 上一篇:2.設計實現一個圖書管理系統。圖書信息存放到一個數據庫中。
- 下一篇:企業考勤系統
評論
共有 條評論