为什么里面的数据库操作程序段 不能生效？
<%@ page contentType="text/html; charset=gb2312" import="java.io.*,SampleSP.*,Microsoft.ZJVNET.PSO.*,java.util.*,javax.servlet.http.*,java.sql.*" %>
<jsp:useBean id='oMD5' scope='request' class='SampleSP.MD5'/>
<%
String cookieName = "SPToken";
String cookieValue = null;
String SPTokenResponse = null;
String ConfigFilePath = "E:\\Tomcat 4.1\\webapps\\SampleSP\\Config.properties";
//String ConfigFilePath = "D:\\cyh\\SampleSP\\Config.properties";
//检查用户是否已经登录
Cookie[] userCookie = request.getCookies();
for(int i=0;i<userCookie.length;i++)
{
if (userCookie[i].getName().equalsIgnoreCase(cookieName))
{
cookieValue = userCookie[i].getValue();
break;
}
}
SPTokenResponse = request.getParameter("SPTokenResponse");
SampleSP.AuthValidation auth = SampleSP.AuthValidation.getInstance(ConfigFilePath);
if (cookieValue == null)
{
if (SPTokenResponse == null)
{
//强制登录
String returnURL = "http://" + request.getServerName() + ":" + request.getServerPort() + request.getRequestURI();
response.sendRedirect(auth.Authoration(returnURL));
}
else
{
java.util.Vector v = auth.ParseSPToken(SPTokenResponse);
if (v.get(0).equals(Boolean.TRUE))
{
//登录成功则写Cookie
Cookie uCookie = new Cookie(cookieName,SPTokenResponse);
response.addCookie(uCookie);
String s = v.get(1).toString();
//拆分返回结果
String[] tmp = PSOCryptography.parseValues(s, "$");
String SPID=tmp[0];
String Result=tmp[1];
String UserID=tmp[2];
String MD5UserID=oMD5.getMD5ofStr(UserID);
String NickName=tmp[3];
String TimeStamp=tmp[4];
String ExpireTime=tmp[5];
String UserProfile=tmp[6];
try
{
//装载驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//创建连接
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sp","sp","sp");
//创建执行语句。
//===========================使用PreparedStatement========//
ResultSet rs = null;
Statement stmt=con.createStatement();
rs = stmt.executeQuery("Select * From sp where UserID='"+UserID+"'");
if(rs.next()){
stmt.executeUpdate("UPDATE sp set TimeStamp='"+TimeStamp+"',ExpireTime='"+ExpireTime+"' where UserID='"+UserID+"'");
// out.println("更新数据成功");
}
else{
stmt.execute("INSERT INTO sp(SPID,Result,UserID,NickName,TimeStamp,ExpireTime,UserProfile,md5) values('"+SPID+"','"+Result+"','"+UserID+"','"+NickName+"','"+TimeStamp+"','"+ExpireTime+"','"+UserProfile+"','"+MD5UserID+"')");
//out.println("添加数据成功");
//关闭连接、释放资源
}
String user=UserID;
response.sendRedirect("http://www.hzgd.com/do_splogin.php?key="+user+"");
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
else
{
//登录失败，跳回到错误页面
String returnURL = "http://" + request.getServerName() + ":" + request.getServerPort() + "/SampleSP/error.jsp?errorinfo=登录失败";
response.sendRedirect(returnURL);
}
}
}
else //检查Cookie
{
java.util.Vector v = auth.ParseSPToken(cookieValue);
if (!v.get(0).equals(Boolean.TRUE))
{
//强制登录
String returnURL = "http://" + request.getServerName() + ":" + request.getServerPort() + request.getRequestURI();
response.sendRedirect(auth.Authoration(returnURL));
}
String s = v.get(1).toString();
//拆分返回结果
String[] tmp = PSOCryptography.parseValues(s, "$");
String UserID=tmp[2];//12100041650 11为
String user=UserID;
response.sendRedirect("http://www.hzgd.com/do_splogin.php?key="+user+"");
}%>
问题点数：100、回复次数：2Top
1 楼ljy118（ljy118）回复于 2005-08-03 08:59:26 得分 0
你写了一堆：哪里有问题啊；你没有说清楚Top
2 楼stone831122（石头）回复于 2005-08-03 09:06:38 得分 0
try
{
//装载驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//创建连接
Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sp","sp","sp");
//创建执行语句。
//===========================使用PreparedStatement========//
ResultSet rs = null;
Statement stmt=con.createStatement();
rs = stmt.executeQuery("Select * From sp where UserID='"+UserID+"'");
if(rs.next()){
stmt.executeUpdate("UPDATE sp set TimeStamp='"+TimeStamp+"',ExpireTime='"+ExpireTime+"' where UserID='"+UserID+"'");
// out.println("更新数据成功");
}
else{
stmt.execute("INSERT INTO sp(SPID,Result,UserID,NickName,TimeStamp,ExpireTime,UserProfile,md5) values('"+SPID+"','"+Result+"','"+UserID+"','"+NickName+"','"+TimeStamp+"','"+ExpireTime+"','"+UserProfile+"','"+MD5UserID+"')");
//out.println("添加数据成功");
//关闭连接、释放资源
}
String user=UserID;
response.sendRedirect("http://www.hzgd.com/do_splogin.php?key="+user+"");
stmt.close();
con.close();
}
Top
