search.java

准备： 1、启动MS-SQL服务器； 2、运行“DBCreate_MusicSky.bat”,安装本项目所需的数据库 （如果安装不成功

import java.io.*;
import java.sql.*;

public class  search
{
	private String input=" ";
	private String option=" ";
	Connection connect=null;
	Statement state=null;
	ResultSet result=null;

	public void setinput(String input)
     {
     	this.input=input;
     }  
   
    public String  getinput()
     {
     	return input;
     } 
     	public void setoption(String option)
     {
     	this.option=option;
     }  
   
    public String  getoption()
     {
     	return option;
     } 
     public search() throws ClassNotFoundException 
    {
    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    public String output()
    {
    	String sql=new String();
 	    String output=new String();
    	try
    	{
    		connect=DriverManager.getConnection("jdbc:odbc:MusicSky","sa","");
    			 if(option.equals("musicname"))
    			 {
    			 	sql=	"Select * from musicinfo where Title LIKE '%"+input+"%'";
    			 }
    			 else if(option.equals("artist"))
    			 {
    			 	sql=	"Select * from musicinfo where ArtistName LIKE '%"+input+"%'";
    			 }
    			 else if(option.equals("cd"))
    			 {
    			 	sql=	"Select * from musicinfo where CdName LIKE '%"+input+"%'";
    			 }
    			 	
    		state=connect.createStatement();
    		result=state.executeQuery(sql);
    		
    		ResultSetMetaData rsmd=result.getMetaData();
			int colCount=rsmd.getColumnCount();
			
			output=rsmd.getColumnName(1).trim();
			
			for(int i=2;i<=colCount;i++)
		   {
		   		output=output+" : "+rsmd.getColumnName(i).trim();
		   }
				//System.out.println(output);
			 
			while(result.next())
		   {
		   		output=output+":"+ result.getString(1).trim();
				for(int i=2;i<=colCount;i++)
				{
					output=output+" : "+result.getString(i).trim();
				}
		   }
		  
		  	//System.out.println(output);
		}
    	catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
		System.out.println (output);
    	return  output;
    }	
}