📄 buy.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/myjsp/tushu/inc/db.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);;
%>
<html>
<head>
<link href=css.css rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>
<%!
int Cint(String cint)
{
try {
int n;
n= Integer.parseInt(cint);
return n;
}
catch (NumberFormatException e) {
return 0;
}
}
%>
<%!
String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
e.printStackTrace();
return null;
}
}
%>
<%
String user_name,action,hw_name,dailis,user_type,basket_count,dingj;
int count,hw_id,basket_id,hw_cash,totalcash,jiage;
user_name=(String)session.getValue("user_name");
user_type=(String)session.getValue("user_type");
action=request.getParameter("action");
String hw_ids=request.getParameter("hw_id");
String counts=request.getParameter("count");
String hw_cashs=request.getParameter("hw_cash");
hw_name=request.getParameter("hw_name");
dingj=null;
if(hw_cashs.length()==23){
dingj=hw_cashs.substring(0,1);
}
if(hw_cashs.length()==24){
dingj=hw_cashs.substring(0,2);
}
if(hw_cashs.length()==25){
dingj=hw_cashs.substring(0,3);
}
//String dingj=daj.toString();
if(hw_name!=null){
hw_name=getStr(hw_name);
}
if(user_name!=null)
{
out.print(user_name+"的购物车");
}
else
{
out.print("购物车");
}%>
</title>
</head>
<body topmargin="0">
<!----------------------------initial check----------------------------------------------->
<font color="#000000"><b>
<%
if(user_name==null)
{
out.print( "<br>");
out.print( "1.你尚未登录!请登录后再订购本站商品!");
out.print( "<br>2.第一次来本站，请先注册会员（免费）!");
out.print( "<br>");
out.print( "<br>");
}
else{
//<!-----------------------------logged ------------------------------------------->
if(action!=null){
if(action.equals("buy"))
{
if(counts==null)
{
counts="1";
}
if(hw_cashs==null)
{
hw_cashs="1000";
}
if (hw_ids==null)
{
out.print("没有此货物!");
}
String sql="select * from basket where hw_id='"+hw_ids+"' and user_name='"+user_name+"' and basket_check=false";
ResultSet rs=stmt.executeQuery(sql);
if(!rs.next())
{
sql="insert into basket(hw_id,user_name,basket_count,hw_name,daili)";
sql=sql+"values('"+hw_ids+"','"+user_name+"','"+counts+"','"+hw_name+"','"+dingj+"')";
stmt.executeUpdate(sql);
}
} %>
</b>
</FONT>
<%
}
//end action=buy
response.sendRedirect("showing.jsp");
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -