?? vehicleinsurancelog.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 id=(String)session.getId();
String target_id=request.getParameter("target_id");
String custom_id=request.getParameter("custom_id");
String numberplate=request.getParameter("numberplate");
String carbuilder=request.getParameter("carbuilder");
String vehicleinspecies=request.getParameter("vehicleinspecies");
String color=request.getParameter("color");
String enginnumber=request.getParameter("enginnumber");
String vinn=request.getParameter("vinn");
String year1=request.getParameter("year1");
String month1=request.getParameter("month1");
String day1=request.getParameter("day1");
String kinds=request.getParameter("kinds");
String value1=request.getParameter("value1");
String busline=request.getParameter("busline");
String load1=request.getParameter("load1");
String photo=(String)session.getAttribute("photo");
session.setAttribute("target_id",target_id);
session.setAttribute("custom_id",custom_id);
if(target_id.equals("")){
String redirctURL="vehicleinsurance.jsp";
response.sendRedirect(response.encodeURL(redirctURL));
out.print("<script>alert('??????!');window.location.href='vehicleinsurance.jsp'</script>");
}
else{
String sqlquerystring="SELECT target_id FROM meitest";
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);
/*String s="CREATE TABLE VEIN("
+"target_id VARCHAR(16) PRIMARY KEY ",
+"custom_id VARCHAR(16) ",
+"x VARCHAR(16)",
+"numberplate VARCHAR(16)",
+"carbuilder VARCHAR(16)",
+"vehicleinspecies VARCHAR(16)",
+"color VARCHAR(16)",
+"enginnumber VARCHAR(16)",
+"vinn VARCHAR(16)",
+"year1 VARCHAR(16)",
+"month1 VARCHAR(16)",
+"day1 VARCHAR(16)",
+"kinds VARCHAR(16)",
+"value1 VARCHAR(16)",
+"busline VARCHAR(16)",
+"load1 VARCHAR(16)",
+"Photo VARCHAR(16);"
");" ;
stmt.execute(s); */
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('targetcan not be non,please fill it');window.location.href='vehicleinsurance.jsp'</script>");
else{
String redirectURL="vehicleinsurance.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('The target_id has exist,please reset it');window.location.href='vehicleinsurance.jsp'</script>");
else{
String redirectURL="vehicleinsurance.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 meitest";
rs=stmt.executeQuery(sqlquerystring);
rs.last();
rs.updateString(1,target_id);
rs.updateString(2,custom_id);
rs.updateString(3,numberplate);
rs.updateString(4,carbuilder);
rs.updateString(5,vehicleinspecies);
rs.updateString(6,color);
rs.updateString(7,enginnumber);
rs.updateString(8,vinn);
rs.updateString(9,year1);
rs.updateString(10,month1);
rs.updateString(11,day1);
rs.updateString(12,kinds);
rs.updateString(13,value1);
rs.updateString(14,busline);
rs.updateString(15,load1);
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();
rs1.close();
stmt1.close();
con1.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();
}
}
%>
</html>
</body>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -