package com.User;

import java.sql.*;

import javax.sql.*;
import java.io.*;
import java.util.*;

/**
 * 實現(xiàn)具體的業(yè)務(wù)邏輯 
 * 它被Action類調(diào)用
 * 并且和HttpRequest等無關(guān)，這樣增加了重用性
 */

public class UserBean
{
     private Connection conn;
     
     public UserBean()throws Exception
 	 {
 		String CLASSFORNAME="oracle.jdbc.OracleDriver";
   	    String SERVANDDB="jdbc:oracle:thin:@127.0.0.1:1521:myoracle";
   	    String USER="admin";
   	    String PWD="admin";
   	    try
   	    {
   		  Class.forName(CLASSFORNAME);
   		        this.conn = DriverManager.getConnection(SERVANDDB, USER, PWD);
   	    }
   	    catch(Exception e)
   	    {
   		  e.printStackTrace();
   	    }
 	  }
     public void addUser(UserForm f)throws Exception
     {
    	 Statement stmt = conn.createStatement();
    	   stmt.executeUpdate("insert into login_user values('"+f.getUserName()+"',"+f.getPassWord()+")");
     }
     
}