??????SQL Server???????????????????????????????????????????????????????????????????????????????
<form action="index.jsp" method="post" >
<!--???div?????-->
<div id="div">
<!--???div?????-->
<div id="div1">
<p style="margin-left:30px;"><img src="image/login/vjia.gif"></img></p>
<div style="width:350px;height:20px;margin-left:30px;margin-top:-10px">
<p><hr/></p>
</div>
<p style="margin-top:0px;margin-left:30px"><img src="image/red_btn.gif"></img></p>
<p style="margin-top:-35px;margin-left:40px;color:#fff;font-size:12px;align:center">Vjia???</p>
<p style="margin-top:-28px;margin-left:110px"><img src="image/btn_long.gif"></img></p>
<p style="margin-top:-35px;margin-left:120px;font-size:12px">Vancl???</p>
<div style="width:350px;height:20px;margin-left:30px;margin-top:-8px">
<p><hr/></p>
</div>
<p style="margin-left:60px">???????<input type="text" name="userName"></p>
<p style="margin-left:75px">????<input type="password" name="password"></p>
<p style="margin-left:150px;margin-top:10px"><input type="submit" value="" style="width:65px;height:26px;background:url(image/tu2.gif)"></p>
<p style="margin-left:30px;margin-top:30px;margin-right:80px">??ú????????????Vjia??<img src="image/account_qq.gif"></img></p>
<p style="margin-left:30px;margin-top:0px;color:red;font-weight:bold">????????</p>
<p style="text-indent:3em;font-size:14px">?????δ???VJIA??????????????VANCL????????е???????????????????????????VANCL??????????VJIA?????????????????????VANCL??????????????</p>
<p style="margin-top:30px;margin-left:100px">???κ?????????<font style="font-weight:bold">????????</font>??<font style="font-weight:bold">??????</font></p>
</div>
</form>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="jdbc.sqlServer"%>
<%
String userName = request.getParameter("userName");
userName = new String(userName.getBytes("ISO-8859-1")??"utf-8");
String password = request.getParameter("password");
//???????????????
sqlServer sq=new sqlServer();
//????????????
Connection con = sq.getConnection();
//??дsql???
String sql="select * from Admin where userName=? and password=? ";
//???????????????
PreparedStatement st=null;
st =con.prepareStatement(sql);
st.setString(1??userName);
st.setString(2??password);
//????????
ResultSet rs=null;
rs=st.executeQuery();
if(rs.next()){
session.setAttribute("url"??userName);
%>
<script type="text/javascript">
alert("??????");
location="jieHe.jsp";
</script>
<%
}else{
%>
<script type="text/javascript">
alert("????????????");
location="doLog.jsp";
</script>
<%
}
//??????
sq.ShiFang(rs??st??con);
%>