?? shiplog.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標題文檔</title>
</head>
<body>
<%request.setCharacterEncoding("gb2312");%>
<%
try{
String target_id=request.getParameter("target_id");
String custom_id=request.getParameter("custom_id");
String person_id=request.getParameter("person_id");
String fleetno=request.getParameter("fleetno");
String shipcName=request.getParameter("shipcName");
String country=request.getParameter("country");
String area=request.getParameter("area");
String makefactory=request.getParameter("makefactory");
String shiptype=request.getParameter("shiptype");
String color=request.getParameter("color");
String shipowner=request.getParameter("shipowner");
String stephull=request.getParameter("stephull");
String year1=request.getParameter("year1");
String month1=request.getParameter("month1");
String shipusage=request.getParameter("shipusage");
String value1=request.getParameter("value1");
String shipport=request.getParameter("shipport");
String sailscope=request.getParameter("sailscope");
String loadton=request.getParameter("loadton");
String shiplength=request.getParameter("shiplength");
String shipwidth=request.getParameter("shipwidth");
String shipdepth=request.getParameter("shipdepth");
String seatcount=request.getParameter("seatcount");
String currency=request.getParameter("currency");
/*String Photo=request.getParameter("Photo"); */
if(target_id.equals("")){
out.print("<script>alert('請輸入ID!');window.location.href='shipins.jsp'</script>");
String redirctURL="shipins.jsp";
response.sendRedirect(response.encodeURL(redirctURL));
}
else{
String sqlquerystring="SELECT target_id FROM Target_ship ";
sqlquerystring+=" "+"WHERE target_id LIKE"+""+"'"+target_id+"'";
String driver= "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver).newInstance();
String ConURL = "jdbc:odbc:login";
Connection con = null;
con = DriverManager.getConnection(ConURL,"sa","453558337");
Statement stmt = con.createStatement();
ResultSet rs = null;
rs = stmt.executeQuery(sqlquerystring);
Connection con1 = null;
con1 = DriverManager.getConnection(ConURL,"sa","453558337");
Statement stmt1 = con1.createStatement();
ResultSet rs1 = null;
String sqlquerystring1="SELECT target_id FROM customtable";
sqlquerystring1+=" "+"WHERE target_id LIKE"+""+"'"+target_id+"'";
rs1 = stmt1.executeQuery(sqlquerystring1);
if(rs.next()){
if(rs.getString(1).trim().equals(target_id.trim()))out.print("<script>alert('客戶號已存在，請從新輸入客戶號');window.location.href='shipins.jsp'</script>");
else{
String redirectURL="shipins.jsp";
response.sendRedirect(response.encodeURL(redirectURL));
}
rs.close();
stmt.close();
con.close();
}
else if(rs1.next()){
if(rs1.getString(1).trim().equals(target_id.trim()))out.print("<script>alert('客戶號已存在，請從新輸入客戶號');window.location.href='shipins.jsp'</script>");
else{
String redirectURL="shipins.jsp";
response.sendRedirect(response.encodeURL(redirectURL));
}
rs1.close();
stmt1.close();
con1.close();
}
else{
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlquerystring="SELECT * FROM Target_ship ";
rs=stmt.executeQuery(sqlquerystring);
rs.last();
rs.updateString(1,target_id);
rs.updateString(2,custom_id);
rs.updateString(3,person_id);
rs.updateString(4,fleetno);
rs.updateString(5,shipcName);
rs.updateString(6,country);
rs.updateString(7,area);
rs.updateString(8,makefactory);
rs.updateString(9,shiptype);
rs.updateString(10,color);
rs.updateString(11,shipowner);
rs.updateString(12,stephull);
rs.updateString(13,year1);
rs.updateString(14,month1);
rs.updateString(15,shipusage);
rs.updateString(16,value1);
rs.updateString(17,shipport);
rs.updateString(18,sailscope);
rs.updateString(19,loadton);
rs.updateString(20,shiplength);
rs.updateString(21,shipwidth);
rs.updateString(22,shipdepth);
rs.updateString(23,seatcount);
rs.updateString(24,currency);
/*rs.updateString(16,Photo);*/
rs.insertRow();
stmt1=con1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlquerystring1="SELECT target_id,custom_id FROM customtable";
rs1=stmt1.executeQuery(sqlquerystring1);
rs1.last();
rs1.updateString(1,target_id);
rs1.updateString(2,custom_id);
rs1.insertRow();
SQLWarning warn=rs.getWarnings();
if(warn!=null){
out.println("---------------Warning-----------");
out.println("<br>");
while(warn!=null){
out.println("Message:"+warn.getMessage());
out.println("<br>");
out.println("SQLState:"+warn.getSQLState());
out.println("<br>");
out.println("Vendor error code:");
out.println("<br>");
warn=warn.getNextWarning();
}
}
rs.close();
stmt.close();
con.close();
out.print("<script>alert('添加成功，請繼續填入客戶詳細信息')</script>");
String redirectURL="useradd.jsp";
response.sendRedirect(response.encodeURL(redirectURL));
}
}
}
catch(SQLException ex) {
out.println("SQLException caught");
out.println("<br>");
while(ex!=null){
out.println("Message:"+ex.getMessage());
out.println("<br>");
out.println("SQLState:"+ex.getSQLState());
out.println("<br>");
out.println("ErrorCode:"+ex.getErrorCode());
out.println("<br>");
ex=ex.getNextException();
}
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -