<%@ page language="java" import="datadisp.*" %>
<%@ page errorPage="error.jsp" %>
<jsp:useBean id="ProjectInforBean" scope="session" class="datadisp.ProjectInforBean"/>
<jsp:setProperty name="ProjectInforBean" property="*"/>
</jsp:useBean>
<% ProjectInforBean.inputInforReq();%>
package datadisp;
import java.sql.*;public class ProjectInforBean{

private static final String DATA_SOURCE_NAME="dsBHP";


private String code;
private String name;
private String type;
private String acceptDate;
private String asociater;
private JDBCCon jdbcCon;

public ProjectInforBean(){
jdbcCon=new JDBCCon(DATA_SOURCE_NAME);
}

public void setCode(String code){
this.code=code;
}

public void setName(String name){
this.name=name;
}

public void setType(String type){
this.type=type;
}

public void setAcceptDate(String acceptDate){
this.acceptDate=acceptDate;
}

public void setAsociater(String asociater){
this.asociater=asociater;
}


public String getCode(){
return code;
}

public String getName(){
return name;
}

public String getType(){
return type;
}

public String getAcceptDate(){
return acceptDate;
}

public String getAsociater(){
return asociater;
}
public void inputInforReq() throws java.lang.ClassNotFoundException,SQLException{

    String inforID=null;
Connection connection=null;


     String insertStatementStr="INSERT INTO INFORMATION (CODE,NAME,TYPE,ACCEPTDATE,ASOCIATER) VALUES(?,?,?,?,?)";
String selectStatementStr="SELECT INFROMATION.ID FROM INFORMATION WHERE INFORMATION.CODE=?";
String insertStatementStr1="INSERT INTO DATADISP (CODE,NAME,PMID) VALUES(?,?,?)";

            PreparedStatement insertStatement=null;
PreparedStatement selectStatement=null;
    PreparedStatement insertStatement1=null;

try{
connection=jdbcCon.getConnection();

insertStatement=connection.prepareStatement(insertStatementStr);


insertStatement.setString(1,getCode());
insertStatement.setString(2,getName());
insertStatement.setString(3,getType());
insertStatement.setString(4,getAcceptDate());
insertStatement.setString(5,getAsociater());


insertStatement.executeUpdate();

     selectStatement=connection.prepareStatement(selectStatementStr);

selectStatement.setString(1,getCode());

ResultSet rs=selectStatement.executeQuery();
inforID=rs.getString("ID");
rs.close();

         insertStatement1=connection.prepareStatement(insertStatementStr1);

insertStatement1.setString(1,getCode());
insertStatement1.setString(2,getName());
insertStatement1.setString(3,inforID);
insertStatement1.executeUpdate();

}
finally{
jdbcCon.cleanup(connection,insertStatement,selectStatement,insertStatement1);
}

}

}