search.java

实现功能：(1)管理员由1.浏览帖子2.添加主贴3.添加复帖4.更改 5.删除6.搜索帖子的权限 (2)注册会员有1.浏览帖子2.添加主贴3添加复帖4.搜索帖子的权限 (3)游客需注册

import java.sql.*;
import java.io.*;
import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class Search{
	public static void search()
	{
    try{
  	Connection con=SecondList2.getConnection();
    System.out.println("\n请输入要搜索的关键字:");
  	Scanner se=new Scanner(System.in);
  	String ses=se.next();
  	String strSql;
  	strSql="select forumNumber,subjectName,dataTime from messagetable where messageType=-1 order by forumNumber";
  	PreparedStatement pp = con.prepareStatement(strSql);
  	ResultSet rst=pp.executeQuery();
  	System.out.println("* * * * * * * * * * * * * * * * * * * * * * * * * * * ");
  	while(rst.next())
    {
    	Pattern pattern = Pattern.compile(ses);
        Matcher m = pattern.matcher(rst.getString(2));
         
    	if(m.find())
    	{
    		System.out.println("  "+rst.getInt(1)+"\t"+rst.getString(2)+"\t "+rst.getString(3));
    	}
    }
    System.out.println("* * * * * * * * * * * * * * * * * * * * * * * * * * * ");	
    	System.out.println(" 0.增加新主题");
        System.out.println(" -1.搜索关键字");
        System.out.println("others.选择跟帖号");
        System.out.print("\n请输入您的选择...: ");
        Scanner br = new Scanner(System.in);
        int choice =br.nextInt();
        switch (choice) 
        {
          case 0:
            System.out.print("\n正在添加新主题......");
            SecondList2.fazhutie("zhanghao");
            break;
          case -1:
            System.out.println("\n请输入要搜索的关键字:");
            Search.search();
            break;
          default:
            rst.beforeFirst();
            while(rst.next()){
            	Pattern pattern = Pattern.compile(ses);
                Matcher m = pattern.matcher(rst.getString(2));
            	if(m.find()){
            		if(choice==rst.getInt(1)){
          		    SecondList1.gentie("zhanghao",3);
          	        }
          	    }
            }
           // System.out.println("请输入一个有效数字!");
            LunTanDetails.firstList();
          }
  }catch(Exception e){
  	e.printStackTrace();
  }
  }
}