package com.feeyar.service;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.feeyar.database.JdbcBean;
import com.feeyar.model.User;
public class UserService {
public User getUserByName(String username){
User user=null;
JdbcBean bean=new JdbcBean();
String sql="select * from t_user where name='"+username+"'";
ResultSet rs=bean.query(sql);
try {
while(rs.next()){
user=new User();
user.setId(rs.getString("id"));
user.setName(rs.getString("name"));
user.setPassword(rs.getString("password"));
user.setDepartment_id(rs.getInt("department_id"));
user.setSex(rs.getString("sex").charAt(0));
user.setAddress(rs.getString("address"));
user.setAdmin_flag(rs.getString("admin_flag").charAt(0));
user.setEmail(rs.getString("email"));
user.setLevel_id(rs.getInt("level_id"));
user.setRole_id(rs.getInt("role_id"));
user.setTelephone(rs.getString("telephone"));
}
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
bean.close();
}
return user;
}
public List<User> getAllUser(){
List<User> temp=new ArrayList<User>();
JdbcBean bean=new JdbcBean();
String sql="select * from t_user";
ResultSet rs=bean.query(sql);
try {
while(rs.next()){
User user=new User();
user.setId(rs.getString("id"));
user.setName(rs.getString("name"));
user.setPassword(rs.getString("password"));
user.setDepartment_id(rs.getInt("department_id"));
user.setSex(rs.getString("sex").charAt(0));
user.setAddress(rs.getString("address"));
user.setAdmin_flag(rs.getString("admin_flag").charAt(0));
user.setEmail(rs.getString("email"));
user.setLevel_id(rs.getInt("level_id"));
user.setRole_id(rs.getInt("role_id"));
user.setTelephone(rs.getString("telephone"));
temp.add(user);
}
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
bean.close();
}
return temp;
}
public boolean isUserNameExited(String username){
boolean result=false;
String sql="select * from t_user where name='"+username+"'";
JdbcBean bean=new JdbcBean();
ResultSet rs=bean.query(sql);
try {
if(rs.next()){
result=true;
}
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
bean.close();
}
return result;
}
public boolean insertUser(User user){
boolean result=true;
String sql="insert into t_user values('"+user.getId()+"','"+user.getName()+"','"+user.getPassword()+"',"+user.getDepartment_id()+",'"+user.getSex()+"','"+user.getAddress()+"','"+user.getTelephone()+"','"+user.getEmail()+"','"+user.getAdmin_flag()+"',"+user.getLevel_id()+","+user.getRole_id()+")";
JdbcBean bean=new JdbcBean();
int temp=bean.update(sql);
if(temp==0){
result=false;
}
return result;
}
}
企业竞争情报系统.rar
需积分: 0 62 浏览量
2008-12-16
10:07:08
上传
评论
收藏 61KB RAR 举报
cis.rar （51个子文件） 
cis 
.project 1KB .mymetadata 282B WebRoot article addArticle.jsp 6KB updateArticle.jsp 8KB articleManager.jsp 8KB search_normal.jsp 8KB ajax_test.jsp 2KB WEB-INF web.xml 2KB lib classes com feeyar database JdbcBean.class 2KB servlet LoginServlet.class 3KB AddServlet.class 3KB ValidateUserName.class 2KB model User.class 2KB Role.class 744B Department.class 798B Level.class 744B service UserService.class 4KB HelperService.class 4KB index.jsp 4KB META-INF MANIFEST.MF 39B purview updatePurview.jsp 6KB user addUser.jsp 7KB userManager.jsp 6KB roleList.jsp 5KB updateUser.jsp 6KB styles public.css 3KB images 
images_10.gif 197B images_09.gif 112B images_11.gif 44B images_05.gif 196B
images_08.jpg 4KB images_02.jpg 653B images_06.jpg 358B images_04.gif 49B images_12.gif 60B SPACES.GIF 43B images_03.jpg 10KB images_01.jpg 346B images_07.jpg 7KB js checkUserValidity.js 1KB .myeclipse src com feeyar database JdbcBean.java 1KB servlet LoginServlet.java 2KB ValidateUserName.java 1KB AddServlet.java 2KB model Role.java 366B Department.java 456B User.java 2KB Level.java 360B service UserService.java 3KB HelperService.java 3KB .classpath 362B资源评论
