daowcheck.java

JSP+SERVLE源码 JSP+SERVLE源码

package com.dao;

import com.Conn;
import java.sql.*;

import com.vo.*;
public class DaoWcheck {
	Conn conn=new Conn();
	Connection con=conn.getCon();
	ResultSet rs=null;
	public void check(){
		Statement stmt;
		try {
			stmt = con.createStatement();
			String sql="select * frome alluser where sign=2 and isdelete=1";			
			rs = stmt.executeQuery(sql);
			VoWcheck check =new VoWcheck();
			check.setAtime(rs.getString("atime"));
			check.setDepartemnt(rs.getString("departement"));
			check.setIsdelete(rs.getInt("isdelete"));
			check.setJob(rs.getString("job"));
			check.setName(rs.getString("name"));
			check.setNum(rs.getInt("num"));
			check.setPaw(rs.getInt("paw"));
			check.setSex(rs.getString("sex"));
			check.setSign(rs.getInt("sign"));
			check.setUtime(rs.getString("utime"));
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		
	}
	
	

}