find.java

来自「个人办公平台,用JAVA开发的TOMCAT的服务器」· Java 代码 · 共 55 行

package com.icss.control;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.icss.common.ConnectionFactory;

public class Find {
	//Connection co=null;
	Statement sta=null;
	ResultSet rs=null;
	//String a=null;
	public User find(String fin){
		
		ConnectionFactory a=new ConnectionFactory();
		Connection co=a.getConnection();
		User u = new User();			
							
				try {System.out.println("nihao");
					sta=co.createStatement();
					System.out.println("hao");
					rs=sta.executeQuery(fin);
					if(rs.next()){
					
	                    u.setEmpid(rs.getInt("empid"));
				        u.setPassWord(rs.getString("password"));
						u.setName(rs.getString("name"));
					    u.setSex(rs.getInt("sex"));
						u.setPosition(rs.getString("position"));
						u.setBloodType(rs.getInt("bloodtype"));
						u.setStature(rs.getInt("stature"));
					    u.setWeight(rs.getInt("weight"));}
					    u.setDepartment(rs.getString("department"));
					    u.setTel(rs.getLong("tel"));
					    u.setMotto(rs.getString("motto"));
					    u.setInterest(rs.getString("interest"));
					    u.setOpen(rs.getInt("open"));
				System.out.println("===="+rs.getInt("empid"));
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			
	return u;
	}

	public static void main(String[] args) {
		Find fi=new Find();
		fi.find("select * from o_myinfo1 where name='' or empid='2'");
	}
}