userloginrst.java

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

//package MusicSky;

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

public class userLoginrst
{
    private String userid=" ";
    private String password=" ";
   // private String pas=" ";
    Connection connect=null;
	Statement state=null;
	ResultSet result=null;
	
    public void setuserid(String userid)
     {
     	this.userid=userid;
     }  
   
    public String getuserid()
     {
     	return userid;
     } 
     
     public void setpassword(String password)
     {
     	this.password=password;
     }  
   
    public String getpassword()
     {
     	return password;
     } 
    
    public userLoginrst() throws ClassNotFoundException 
    {
    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } 
    
    public boolean Musicvalidate()
    {
    	boolean validate=false;
    	String pas="";
    	
		try
		{
			userid=getuserid();
			password=getpassword();
			
			connect=DriverManager.getConnection("jdbc:odbc:MusicSky","sa","");
			
			String sql="Select USER_PASSWORD from userpassword where USER_ID='"+userid+"'";
			
			state=connect.createStatement();
			
			ResultSet result=state.executeQuery(sql);
			while(result.next())
			{
				pas=result.getString(1);
			}
			pas=pas.trim();
			password=password.trim();
			if(pas.equals(password))
			{
				validate=true;
			}
			
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
		return validate;
    }
    
}