数据库设计:
/*商品信息表*/
/*id:序号 */
/*pdm:代码*/
/*pname:商品名字*/
/*povider:品牌*/
/*info:商品信息*/
/*stock:数量*/
/*price:单价*/
CREATE TABLE pro_T (
id int IDENTITY (1, 1) NOT NULL ,
pdm varchar (50) NOT NULL ,
pname varchar (50) NULL ,
provider varchar (50) NULL ,
info varchar (50) NULL ,
stock int NULL ,
price float NULL
) ON PRIMARY
GO
/*用户表*/
/*username:用户名*/
/*password:密码*/
CREATE TABLE user_T (
username varchar (10) NOT NULL ,
password varchar (16) NOT NULL
) ON PRIMARY
GO
index.jsp--登陆页面
function check()
{
if (form.Username.value==""){
alert("请输入用户名");
form.Username.focus();
return false;
}
}
用户登陆![]() |
![]() |
|
![]() |
|
check.jsp---登陆检测页面
认证码验证页面String username=request.getParameter("username");
String password=request.getParameter("password");
%>
boolean flag = false;
String sql = "select * from user_T where username='" + username
+ "'and password='" + password+ "'";
try {
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx