validate.java

用Java开发的购物车程序!

package mypackage;

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

public class Validate
{
	private Connection conn=null;
	private Statement ps=null;
	private ResultSet rs=null;
	private String username="";
	private String password="";
	static String constr="jdbc:oracle:thin:@localhost:1521:oracle";
	static boolean flag=false;
	
	public Validate()
	{
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public void setUsername(String username)
	{
		this.username=username;
	}
	public void setPassword(String password)
	{
		this.password=password;
	}
	
	public String getUsername()
	{
		return this.username;
	}
	public String getPassword()
	{
		return this.password;
	}
	
	public boolean userValidate()throws Exception
	{
		String str="";
		try
		{//this.username="小二";this.password="lhl";
		conn=DriverManager.getConnection(constr,"scott","tiger");
		ps=conn.createStatement();
		rs=ps.executeQuery("select password from userinfo where username='"+this.username+"'");
		while(rs.next())
		{
			str=rs.getString(1);
			if(str.equals(this.password))
			flag=true;
		}
			conn.close();
//			PrintWriter out=new PrintWriter(new FileWriter("c:\\dd.txt"),true);
//			out.print(this.username);
//			out.print('  ');
//			out.print(this.password);
//			
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	
		return flag;
	}
	
//	public static void main(String[] args)throws Exception 
//	{
//		Validate v=new Validate();
//		boolean b=v.userValidate();System.out.println(b);
//	}
}