find1.java

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

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 Find1 {
	
	public Connection co=null;
	public Statement sta=null;
	public ResultSet rs=null;
	public String a=null;

	public User1 find(String dd){
		ConnectionFactory a=new ConnectionFactory();
		co=a.getConnection();
		User1 u = new User1();	
							
				   
					try {
						System.out.println("nihao");
										   sta=co.createStatement();
										   System.out.println("hao");
										   rs=sta.executeQuery(dd);
										   
						while(rs.next()){
							
							System.out.println("rs");	
							u.setEmpid(rs.getInt("empid"));
							System.out.println("empdi="+rs.getInt("empid"));
							u.setQq(rs.getLong("qq"));
							u.setName(rs.getString("name"));
							System.out.println(rs.getString("name"));
							u.setSex(rs.getString("sex"));
							u.setEmail(rs.getString("email"));
							System.out.println(rs.getString("email"));
							
							u.setMobilphone(rs.getLong("MOBILPHONE"));
							
							u.setOfficephone(rs.getLong("officephone"));
							
							u.setFixphone(rs.getLong("FIXPHONG"));
							
							u.setFax(rs.getLong("fax"));
							
							u.setAddress1(rs.getString("address1"));
							
							u.setAddress(rs.getString("address"));
							
							u.setMsn(rs.getString("msn"));
						
						}
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
			
	           return u;
	
}
	public static void main(String[] args) {
		Find1 fin=new Find1();
		fin.find("select * from o_connection where name='杨雯'");
	}
}