package com.jspdev.One;

import java.sql.*;

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

public class OneBean
{
     private Connection conn;
     
     public OneBean()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 addOne(OneForm f)throws Exception
     {
    	 Statement stmt= conn.createStatement();
    	    stmt.executeUpdate("insert into topic(title,author,email,content) values('"+f.getTltle()+"','"+f.getAuthor()+"','"+f.getEamil()+"','"+f.getContent()+"' )");
     }
}