jsp와 oracle(db)연계 소스

package register;

public class RegisterBean {
	private String id;  //private ==> 접근제어자(외부에서 바로 접근하지 못하게함)
	private String passwd;
	private String name;
	private String email;
	private String tel;
	
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String passwd) {
		this.passwd = passwd;
	}
	public String getTel() {
		return tel;
	}
	public void setTel(String tel) {
		this.tel = tel;
	}

}

package register;
import java.sql.*;
public class registerfunction{
	
	public int registerinsert(RegisterBean bean){
		Connection conn=null;
		PreparedStatement pstmt=null;
		int result=0;
		try{
			
			String jdbcURL="jdbc:oracle:thin:@localhost:1521:orcl";
		    String dbId="system";
		    String dbPass="oracle";
		     
		     Class.forName("oracle.jdbc.driver.OracleDriver");
		     conn=DriverManager.getConnection(jdbcURL,dbId,dbPass);
		     
		     String sql= "insert into member values(logmnr_seq$.nextval,?,?,?,?,?)";
		     pstmt=conn.prepareStatement(sql);
		     pstmt.setString(1,bean.getId());
		     pstmt.setString(2,bean.getPasswd());
		     pstmt.setString(3,bean.getName());
		     pstmt.setString(4,bean.getEmail());
		     pstmt.setString(5,bean.getTel());
		     
		     result=pstmt.executeUpdate();
		}catch(Exception e){
	         e.printStackTrace();
		}finally{
			if(pstmt!=null)try{pstmt.close();}catch(SQLException sqle){}
		    if(conn!=null)try{pstmt.close();}catch(SQLException sqle){} 
		    return 1;
	    }

	}

}

http://codesarang.com. mail to cpueblocpueblo.com