資源簡介
基于java和sql的開發平臺。易于理解。難度適中。

代碼片段和文件信息
package?cn.kfu.dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?cn.kfu.entity.AdminInfo;
import?cn.kfu.entity.UserInfo;
import?cn.kfu.util.DBUtil;
public?class?AdminInfoDAO?{
public?boolean?searchUserInfo(AdminInfo?u)?{
boolean?result=false;
Connection?conn?=?DBUtil.getConnection();
String?sql?=?“select?*?from?adminInfo?where?userName=??and?password=?“;
try?{
PreparedStatement?pstm?=?conn.prepareStatement(sql);
pstm.setString(1?u.getUserName());
pstm.setString(2?u.getPassword());
ResultSet?rs=pstm.executeQuery();
if(rs.next()){
result=true;
}
if(rs!=null)rs.close();
if(pstm!=null)pstm.close();
if(conn!=null)DBUtil.close(conn);
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?result;
}
public?ArrayList?selectAll()?{
????????ArrayList?arr?=?null;
Connection?conn?=?DBUtil.getConnection();
String?sql?=?“select?*?from?userinfo“;
try?{
Statement?stm?=?conn.createStatement();
ResultSet?rs?=?stm.executeQuery(sql);
arr?=?new?ArrayList();
while(rs.next()){
UserInfo?a?=?new?UserInfo();
a.setUsername(rs.getString(1));
a.setPassword(rs.getString(2));
arr.add(a);
}
if(rs!=null)rs.close();
if(stm!=null)stm.close();
if(conn!=null)DBUtil.close(conn);
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?arr;
}
public?boolean?update(String?passwordString?username)?{
Connection?conn?=?DBUtil.getConnection();
String?sql?=?“update?adminInfo?set?password=??where?userName=?“;
boolean?result=false;
try?{
PreparedStatement?pstm?=?conn.prepareStatement(sql);
????pstm.setString(1?password);
????pstm.setString(2?username);
????int?i=pstm.executeUpdate();
????if(i>0){
???? result=true;
????}
if(pstm!=null)pstm.close();
if(conn!=null)DBUtil.close(conn);
}?catch?(SQLException?e)?{
e.printStackTrace();
}
return?result;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-05-06?08:47??BookShop\
?????文件?????????492??2011-04-19?16:47??BookShop\.classpath
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????文件???????????0??2011-04-26?15:51??BookShop\.me
?????文件????????2846??2011-04-26?15:51??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????文件???????????0??2011-04-26?15:51??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????文件???????????1??2011-04-26?15:52??BookShop\.me
?????文件??????????57??2011-04-26?15:51??BookShop\.me
?????文件???????????1??2011-04-26?15:52??BookShop\.me
?????文件??????????77??2011-04-26?15:52??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????文件?????????319??2011-04-26?15:52??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????目錄???????????0??2011-05-06?08:47??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
?????文件?????????104??2011-04-26?15:51??BookShop\.me
............此處省略297個文件信息
- 上一篇:學生課績管理系統 - Java源碼
- 下一篇:apriori算法java實現源代碼
評論
共有 條評論