reg.java

用Java开发的购物车程序!

package mypackage;

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

public class Reg
{
	private Connection conn=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	private boolean flag=false;
	private String username=null;
	private String password=null;
	private String email=null;
	
	public Reg()throws Exception
	{
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public boolean regInfo()throws Exception
	{
		int i=0;
		try
		{	
			conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle","scott","tiger");
			stmt=conn.createStatement();
			rs=stmt.executeQuery("select username from userinfo where username='"+this.username+"'");
						
			while(rs.next())
			{
				i++;
			}
			if(i==0)
			{
				stmt.executeUpdate("insert into userinfo values('"+this.username+"','"+this.password+"')");
				stmt.executeUpdate("insert into reginfo values('"+this.username+"','"+this.password+"','"+this.email+"')");
				flag=true;
			}
			conn.close();
//				PrintWriter out=new PrintWriter(new FileWriter("c:\\1.txt"),true);
//			out.print(this.username);
//			out.print(' ');
//			out.print(this.password);
//			out.print(' ');
//			out.print(this.email);
//			out.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return flag;
	}
	
	public void setUsername(String username)
	{
		this.username=username;
	}

	public void setPassword(String password)
	{
		this.password = password; 
	}

	public void setEmail(String email) 
	{
		this.email = email; 
	}

	public String getUsername() 
	{
		return (this.username); 
	}

	public String getPassword() 
	{
		return (this.password); 
	}

	public String getEmail() 
	{
		return (this.email); 
	}
//	public static void main(String[] args)throws Exception
//	{
//		
//		Reg reg=new Reg();
//		System.out.println(reg.regInfo());
//	}
}