<%@page import="javax.swing.text.html.HTML"%>
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=utf-8");
%>
设置权限
<%@include file="../mysqlconnect.jsp"%>
<%
String yuyan1="cn";
String yuyan2=request.getParameter("yuyan");
if(yuyan2==""||yuyan2==null){
}else{
yuyan1=yuyan2;
}
String yemian="shezhi.jsp";
String[] group=new String[6];
//连接数据库
//装载一个类并且对其进行实例化的操作
/* Class.forName(driverClass1);{
Connection con1=DriverManager.getConnection( url1,user1,password1);
CallableStatement cs = con1.prepareCall("{call yuyan(?,?)}");
cs.setString(1, yemian);
cs.setString(2, yuyan1);
ResultSet rs = cs.executeQuery();
int i=0;
while(rs.next())
{
group[i]=rs.getString(1);
i++;
}
} */
Class.forName(driverClass);{
Connection con=DriverManager.getConnection( urlglass,user,password);
//通过connection数据库链接对象 创建一个statement对象数据库操作对象
Statement stmts=con.createStatement();
//执行sql语句
String anquan="select * from anquanbiao where anquanma = '"+request.getParameter("anquanma")+"' ";
ResultSet rss = stmts.executeQuery(anquan);
int coun=0;
while(rss.next())
{
coun++;
}
if(coun==0){
out.print("");
}
con.close();
}
%>
<%
String chongzhibianhao=request.getParameter("shangpinbianhao");
//装载一个类并且对其进行实例化的操作
if(chongzhibianhao!=null){
Class.forName(driverClass);{
Connection con1=DriverManager.getConnection( urlglass,user,password);
//调用存储过程
CallableStatement cs = con1.prepareCall("{call mimachongzhi(?,?)}");
cs.setString(1,chongzhibianhao);
cs.registerOutParameter( 2, java.sql.Types.INTEGER);
cs.execute();
int fanhui=cs.getInt(2);
if(fanhui==5000){
out.print("");
}else{
out.print("");
}
con1.close();
}
}
%>
重置密码为123456 |