selecta.java

dwr demo DWR的一个实例。。DWR的一个实例

package forbest.tool;
import java.sql.*;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class SelectA {
	public String testDWR(String str)	
	{
		
		String newsId="";
		String result[];
		int i=0;
		int count=0;
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet RsSpecial=null;
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}catch(Exception e){}
		try{
			conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=nxqdb","sa","");
		}catch(SQLException e){
			e.printStackTrace();
			return null;
		}
		try{
		
			String sql_Special = "Select  * from tArticleClass where fParentID =? ";
			pstmt=conn.prepareStatement(sql_Special);
			pstmt.setInt(1, Integer.parseInt(str));
			System.out.println("传入的值为："+str);
		
			RsSpecial=pstmt.executeQuery();
			RsSpecial.last();
			count=RsSpecial.getRow();
			if (RsSpecial.getRow()==0){newsId="暂无使用排序ID";}
			else{
					RsSpecial.beforeFirst();
					result=new String[RsSpecial.getRow()];
				while(RsSpecial.next())
				{
					result[i]=RsSpecial.getString("fOrderID");
					i++;
				}
				if(result.length>0){
					for(int j=0;j<result.length;j++){
						
						newsId+=result[j]+",";
					}
				}
			}
		RsSpecial.close(); //关闭记录集对象
		pstmt.close(); //关闭语句对象
			}
			catch(Exception e){
				e.printStackTrace();
				}
			

		System.out.println("您选择的父栏目ID是："+newsId+"吗？");
		System.out.println("您取出的记录个数是："+count);
		return newsId;
		
	
	}
	public String compareNewsID1(String id){
		String result[];
		String ss="";
		//建立数据库连接
		//根据id取出结果
		//把ResultSet对象遍历出来，循环复制到该[]就可以了
		//
		String id_list[]={"1","2","3","4","5","6","7"};
		result=new String[id_list.length];
		for(int i=0;i<id_list.length;i++){
			if(id.equals(id_list[i]))
			{
				result=id_list;
				break;
			}
		}
		if(result.length>0){
			for(int i=0;i<result.length;i++){
				
				ss+=result[i];
			}
		}
		return ss;
		
	}
}