?? systemusersdaoimpl.java
字號:
package org.itstar.netbar.dao.impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.itstar.netbar.utils.ConnectDB;
import org.itstar.netbar.bean.SystemUsersBean;
import org.itstar.netbar.dao.ISystemUsersDao;
public class SystemUsersDaoImpl implements ISystemUsersDao
{
public SystemUsersBean delete(String sysUsername) {
// TODO 自動生成方法存根
return null;
}
public SystemUsersBean insert(SystemUsersBean suBean) {
// TODO 自動生成方法存根
return null;
}
public List query(Map map)
{
String strSQL;
Statement stmt=null;
strSQL="select * from systemUsers where 1=1";
if(map.get("sysUsername")!=null)
strSQL=strSQL+" and sysUsername='"+map.get("sysUsername")+"'";
if(map.get("sysPassword")!=null)
strSQL=strSQL+" and sysPassword='"+map.get("sysPassword")+"'";
// System.out.println(strSQL);
// System.exit(0);
ResultSet rs=null;
List list=new ArrayList();
try {
stmt=ConnectDB.getConn().createStatement();
rs=stmt.executeQuery(strSQL);
while(rs.next())
{
SystemUsersBean suBean=new SystemUsersBean();
suBean.setSysUsername(rs.getString(1));
suBean.setSysPassword(rs.getString(2));
list.add(suBean);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List queryAll()
{
String strSQL;
Statement stmt=null;
strSQL="select * from systemUsers";
ResultSet rs=null;
List list=new ArrayList();
try {
stmt=ConnectDB.getConn().createStatement();
rs=stmt.executeQuery(strSQL);
while(rs.next())
{
SystemUsersBean suBean=new SystemUsersBean();
suBean.setSysUsername(rs.getString(1));
suBean.setSysPassword(rs.getString(2));
list.add(suBean);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public SystemUsersBean update(SystemUsersBean suBean) {
// TODO 自動生成方法存根
return null;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -