<%@ 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);
}
}
}
<%@ 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);
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货