logindao.java

来自「xueyuan gongzuojieshao」· Java 代码 · 共 337 行

/*
 * 创建日期 2007-4-29
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package dao.login;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import oracle.DBConnection;

import bean.login.loginBean;

/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class loginDao {
	
	//根据用户名和密码查询该用户是否注册和权限
	
	public loginBean loginSelect(loginBean bean){
		String sql = " select isadmin , content from table_user " +
				"where  username='"+bean.getUserName()+"' and password='"+bean.getPassWord()+"'";
		Connection conn = null;  
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn=DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				bean.setIsAdmin(rs.getString("isadmin"));
				bean.setContent(rs.getString("content"));								
			}
		} catch (SQLException e) {
			System.out.println("loginSelect失败");
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				System.out.println("关闭数据库失败");
			}	
		}
		return bean;
	}
	
     //根据用户输入的信息，向table_user表里插入相关信息
	
	public int userInsert(loginBean bean){
		int ret = 0;
		StringBuffer sql =new StringBuffer(" insert into table_user " +
				"values( user_seq.nextval,?,?,?,to_date(?,'YYYY-MM-DD'),sysdate,?,?)");
		Connection conn = null;
		PreparedStatement stm = null;
		try {
			conn = DBConnection.getConnection();
			conn.setAutoCommit(false);
			stm = conn.prepareStatement(sql.toString());
			stm.setString(1,bean.getUserName());
			stm.setString(2,bean.getPassWord());
			stm.setString(3,bean.getSex());
			stm.setString(4,bean.getBirthDay());
			stm.setString(5,bean.getIsAdmin());
			stm.setString(6,bean.getContent());
			stm.executeUpdate();
			conn.commit();
			ret = 1;
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				System.out.println("数据会滚失败");
			}
			e.printStackTrace();
			System.out.println("数据插入失败");
		}finally{
			try {
				conn.setAutoCommit(true);
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				System.out.println("关闭数据库失败");
			}
		}
		return ret;
	}
	
	//查询table_user里的所有信息
	
	public List userSelect(){
		List list = new ArrayList();
		String sql = " select user_id,userName,passWord,sex,birthDay,createTime,isAdmin,content" +
				" from table_user ";
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				loginBean bean = new loginBean();
				bean.setUser_id(rs.getString("user_id"));
				bean.setUserName(rs.getString("userName"));
				bean.setPassWord(rs.getString("passWord"));
				if(rs.getInt("sex")==1){
					bean.setSex("男");
				}else{
					bean.setSex("女");
				}
				bean.setBirthDay(rs.getString("birthDay"));
				bean.setCreateTime(rs.getString("createTime"));
				if(rs.getInt("isAdmin")==1){
					bean.setIsAdmin("是");
				}else{
					bean.setIsAdmin("不是");
				}
				bean.setContent(rs.getString("content"));
				list.add(bean);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return list;
	}
	
	//根据user_id 查询相关信息
	
	public loginBean selectPerson(loginBean bean){
		String sql=" select * from table_user where user_id="+bean.getUser_id();
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				bean.setUser_id(rs.getString("user_id"));
				bean.setUserName(rs.getString("userName"));
				bean.setPassWord(rs.getString("passWord"));
				if(rs.getInt("sex")==1){
					bean.setSex("男");
				}else{
					bean.setSex("女");
				}
				bean.setBirthDay(rs.getString("birthDay"));
				bean.setCreateTime(rs.getString("createTime"));
				if(rs.getInt("isAdmin")==1){
					bean.setIsAdmin("是");
				}else{
					bean.setIsAdmin("不是");
				}
				bean.setContent(rs.getString("content"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		}
		return bean;
	}
	
	//根据id和密码查询相关信息
	
	public loginBean selectAll(loginBean bean){
		String sql =" select * from table_user where " +
				"user_id="+bean.getUser_id()+" and password='"+bean.getPass()+"'";
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				bean.setUser_id(rs.getString("user_id"));
				bean.setUserName(rs.getString("userName"));
				bean.setPassWord(rs.getString("passWord"));
				if(rs.getInt("sex")==1){
					bean.setSex("男");
				}else{
					bean.setSex("女");
				}
				bean.setBirthDay(rs.getString("birthDay"));
				bean.setCreateTime(rs.getString("createTime"));
				if(rs.getInt("isAdmin")==1){
					bean.setIsAdmin("是");
				}else{
					bean.setIsAdmin("不是");
				}
				bean.setContent(rs.getString("content"));
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return bean;
	}
	
	//根据id修改用户信息
	
	public int updatePerson(loginBean bean){
		int ret = 0;
		String sql = " update table_user set userName='"+bean.getUserName()+"'" +
				" , passWord='"+bean.getPassWord()+"'" +
				" , sex ="+bean.getSex()+"  ,birthDay=to_date('"+bean.getBirthDay()+"','YYYY-MM-DD')" +
				" , isAdmin="+bean.getIsAdmin()+" , content='"+bean.getContent()+"' where user_id="+bean.getUser_id();
		System.out.print(sql);
		Connection conn = null;
		PreparedStatement stm = null;
		try {
			conn =DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			ret = stm.executeUpdate();
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return ret;
	}
	
	//删除相关信息
	
	public int dropPerson(loginBean bean){
		int ret = 0;
		String sql =" delete from table_user where user_id="+bean.getUser_id();
		Connection conn = null;
		PreparedStatement stm = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			ret = stm.executeUpdate();
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			try {
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		}
		return ret;
		
	}
	
//	public static void main(String[] arge){
//		loginBean bean = new loginBean();
//		bean.setUser_id("3");
//		bean.setUserName("李刚");
//		bean.setPassWord("885522");
//		bean.setBirthDay("1987-04-21");
//		bean.setIsAdmin("1");
//		bean.setSex("1");
//		bean.setContent("老实人");
//		loginDao dao = new loginDao();
//		dao.updatePerson(bean);
//		
//	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	

}