myrs.java

java版QQ聊天,实现用户登录验证

package com.net;

import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.util.Properties;
import java.io.*;

public class myRs
{
	
	public PreparedStatement ps ;
	public ResultSet rs;				//记录集
	public ResultSetMetaData rsmd;		//记录的列名信息
	
	public static void main(String age[])
	{
		String sql = "select * from TabUser where id = '001' ";
		myRs rs = new myRs(sql);
		
		
		try{
		    int colCount = rs.getRsmd().getColumnCount();
		    if(rs.getRs().next())
    		{
			    for (int i = 1; i<colCount+1; i++){
			    	System.out.println (rs.getRsmd().getColumnName(i));
			    	System.out.println(rs.getRs().getString(rs.getRsmd().getColumnName(i)));
			    	}
		    }


		}catch(SQLException e)
		{
			System.out.println(e);
		}		

	}
	
	public myRs(String sql)
	{		
		ps = null;
		rs = null;
		
		myConn conn = new myConn("db.ini");			//实例化 记录桥
		try{
		    ps = conn.getConn().prepareStatement(sql);
	//	    ps.setString(1,"001");   
		    
		    rs = ps.executeQuery();
		    rsmd = rs.getMetaData();

		}catch(SQLException e)
		{
			System.out.println(e);
		}
	}
	
	public ResultSet getRs()
	{
		return rs;
	}
	public ResultSetMetaData getRsmd()
	{
		return rsmd;
	}
	public PreparedStatement getPs()
	{
		return ps;
	}
}