📄 chenggong.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<title>成功</title>
<body>
<%String name="";
int a=0;
name=(String)session.getAttribute("name");
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:shop","sa","");
sql=con.createStatement();
String abc1="select * from shop where 用户名="+"'"+name+"'";
rs=sql.executeQuery(abc1);
while(rs.next())
{
a=rs.getInt(3);
}
}catch(SQLException m){out.print(m);}
%>
<p>尊敬的
<%
out.print(name);%>
<br>您的帐户余额为:
<%
out.print(a);
%>
<br><p>请选择您要购买的书籍:<br>
<form name="form1" method="post"action="mai.jsp">
<br><input type="checkbox" name="check1" value="柯南1">柯南1——定价：10
<br><input type="checkbox" name="check2" value="柯南2">柯南2——定价：20
<br><input type="checkbox" name="check3" value="柯南3">柯南3——定价：30
<br><input type="submit" name="Submit" value="提交">
</form>
<form action="1.jsp">
<p>重新登陆请按
<input type="submit" name="Submit" value="返回">
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -