解决方案 »
- 用java怎么写定时更新数据库
- spring-webmvc.jar包下载
- 求一个最简单的树
- 急救!JBuilder2005与Tomcat的问题!!!!
- 请问TOMCAT在WIN2K SERVER里直接安装好后就可以使用TOMCAT了呢还是必须要TOMCAT+IIS集成
- 用JAVA JSP中读取MAC 地址
- 请问怎样才能通过url将一个值传给一个action,然后在action中将其得到???
- 用Struts开发你的网站(一)
- 求救各位大虾 那里有中文字库(字体)呀! 现急用!!!!!!!!!!!!!!!!!!!!!
- spring mvc+hibernate插入时候中文乱码
- 求tomcat的配置问题?
- 很简单的问题
如果你是在tomcat下使用jdbc for mysql ,你把mysql的驱动放到tomcat目录下的common\lib子目录下就可以了。
还有,最好是把驱动也放到C:\Program Files\Java\j2re1.5.0\lib\ext\mysql-connector-java-5.0.0-beta-bin.jar 下一份。在系统变量中的classpath加入C:\Program Files\Java\j2re1.5.0\lib\ext\mysql-connector-java-5.0.0-beta-bin.jar。
现在mysql的jdbc驱动是mysql-connector-java-5.0.0-beta-bin.jar
<%@ include file="incdb.jsp"%>
<%
String userName = (String) session.getAttribute("userName_s");
if (userName!=null){
response.sendRedirect("index.jsp");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<title>财务管理</title>
<link rel="stylesheet" href="images/css.css" type="text/css" media="screen">
<script Language="JavaScript">
<!--
function isspacestring(mystring)
{ var istring=mystring;
var temp,i,strlen;
temp=true;
strlen=istring.length;
for (i=0;i<strlen;i++)
{
if ((istring.substring(i,i+1)!=" ")&(temp))
{ temp=false; }
}
return temp;
}function firstisspace(mystring)
{ var istring=mystring;
var temp,i,strlen;
temp=false;
if (istring.substring(0,1)==" ")
{ temp=true; }
return temp;
}function check_input(theForm)
{ if ((theForm.username.value == "")|(firstisspace(theForm.username.value)))
{
alert("请输入用户名.不能为空!");
theForm.username.focus();
return (false);
} if ((theForm.password.value == "")|(isspacestring(theForm.password.value)))
{
alert("请输入密码.不能为空!");
theForm.password.focus();
return (false);
}
}
//-->
</script>
</head>
<body>
<p> </p><FORM action=chklogin.jsp method=post onsubmit="return check_input(this)">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6685C5"> <tr>
<td bgcolor="#FFFFFF"><table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><img src="images/login.gif" width="400" height="167"></td>
</tr>
<tr>
<td height="35" colspan="3"><div align="center">用户:
<INPUT
name=username class="s01" size=16 maxLength=16>
密码:
<INPUT name=password type=password class="s01" size=16 maxLength=20>
</div></td>
</tr>
<tr>
<td width="239" height="37"><div align="center"> copyright2006
</div></td>
<td width="21"> </td>
<td width="140"><input name=submit type=submit class="s02" value="登 陆">
<input name=submit1 type=reset class="s02" id="submit1" value="取 消"></td>
</tr>
</table></td>
</tr>
</table> </FORM>
</body></html>
<%@ include file="incdb.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<title>财务管理</title>
<link rel="stylesheet" href="images/css.css" type="text/css" media="screen">
</head>
<body>
<%
String loginerror = null;
String userName = request.getParameter("username");
String passWord = request.getParameter("password");
%>
<%
if(userName==""){
loginerror = "请输入您的用户名!";
}
if(passWord=="") {
loginerror = "请输入您的密码!";
}
DispMaster dispmaster = new DispMaster();
dispmaster.setUserName(userName);
dispmaster.setUserPassword(passWord);
if(!dispmaster.chkLogin()){
loginerror = "用户名或密码错误!请重新登陆。";
%> <TABLE width=400 border="0" align=center cellpadding=0 cellspacing=1 class="tableBorder">
<TR bgcolor=#336699 >
<Th align=center bgcolor="#336699" height=25><B>错误</B></th>
</TR>
<TR>
<TD align=center class="forumrow"><p><BR>
<%=loginerror%><BR>
<BR>
<A href="javascript:onclick=history.back()">[返回上页]</A><BR>
</p>
</TD>
</TR>
</TABLE>
<%}
else{
String userName_s = null;
String passWord_s = null;
session.setAttribute("userName_s",userName);
session.setAttribute("passWord_s",passWord);
MasterControl mastercontrol = new MasterControl();
mastercontrol.setUserName(userName);
mastercontrol.addloginnum();
//在登陆信息里加一条记录
LogControl logcontrol =new LogControl();
String ip=request.getRemoteAddr();//获得登陆人员ip地址 logcontrol.setUser(userName);
logcontrol.setIp(ip);
logcontrol.addlogin();
if (userName.equals("admin")){
response.sendRedirect("index.jsp");
}
else{
response.sendRedirect("index_user.jsp");
}
}
%>
import java.util.*;public class DispMaster extends Master{public boolean ismaster;public ResultSet rs;public DispMaster(){};/*login*/
public boolean chkLogin() throws Exception {
DBConnect dbc = null;
try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM master WHERE name = ? and pass = ?");
dbc.setBytes(1,userName.getBytes("GB2312"));
dbc.setBytes(2,userPassword.getBytes("GB2312"));
rs = dbc.executeQuery();
if(!rs.next()){
ismaster = false;
}else{
ismaster = true;
}
}catch(Exception e){
System.err.println(e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return ismaster;
}/*
* 查询所有的管理员,检查是否重复
*/
public boolean reLogin() throws Exception {
DBConnect dbc = null;
try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM master WHERE name = ?");
dbc.setBytes(1,userName.getBytes("GB2312"));
rs = dbc.executeQuery();
if(!rs.next()){
ismaster = false;
}else{
ismaster = true;
}
}catch(Exception e){
System.err.println(e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return ismaster;
}/*
* 查询所有的管理员(按id排序)
*/
public Vector allMaster() {
DBConnect dbc = null;
Vector allMasterVector = new Vector(); try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM master order by id desc");
rs = dbc.executeQuery();
while(rs.next()){
Master master = new Master();
master.setID(rs.getInt("id"));
master.setUserName(rs.getString("name"));
master.setUserPassword(rs.getString("pass"));
master.setJoindate(rs.getString("joindate"));
master.setClassid(rs.getInt("classid"));
master.setLoginnum(rs.getInt("loginnum"));
allMasterVector.add(master);
}
}catch(Exception e){
System.err.println("error:"+e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return allMasterVector;
}/*
* 查询所有的管理员(按id排序)
*/
public Vector masterOrderID() {
DBConnect dbc = null;
Vector allMasterVector = new Vector(); try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM master order by id");
rs = dbc.executeQuery();
while(rs.next()){
Master master = new Master();
master.setID(rs.getInt("id"));
master.setUserName(rs.getString("name"));
master.setUserPassword(rs.getString("pass"));
master.setJoindate(rs.getString("joindate"));
master.setClassid(rs.getInt("classid"));
master.setLoginnum(rs.getInt("loginnum"));
master.setUserTruename(rs.getString("truename"));
master.setUserIpaddress(rs.getString("ipaddress"));
allMasterVector.add(master);
}
}catch(Exception e){
System.err.println("error:"+e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return allMasterVector;
}/*
* 计算管理员的总数
*/
public int masterNum() {
DBConnect dbc = null;
int masterCount = 0;
try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT count(*) FROM master");
rs = dbc.executeQuery();
if(rs.next()) masterCount = rs.getInt(1);
}catch(Exception e){
System.err.println(e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return masterCount;
}/*
* 根据ID得到管理员
*/
public Master idToMaster() {
DBConnect dbc = null;
Master master = new Master();
try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM master WHERE id = ?");
dbc.setInt(1,ID);
rs = dbc.executeQuery();
if(rs.next()){
master.setID(rs.getInt("id"));
master.setUserName(rs.getString("name"));
master.setUserPassword(rs.getString("pass"));
master.setJoindate(rs.getString("joindate"));
master.setClassid(rs.getInt("classid"));
master.setLoginnum(rs.getInt("loginnum"));
master.setUserTruename(rs.getString("truename"));
master.setUserIpaddress(rs.getString("ipaddress"));
}
}catch(Exception e){
System.err.println(e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return master;
}/*
* 根据用户名称得到管理员
*/
public Master nameToMaster() {
DBConnect dbc = null;
Master master = new Master();
try{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM master WHERE name = ?");
dbc.setBytes(1,userName.getBytes("GB2312"));
rs = dbc.executeQuery();
if(rs.next()){
master.setID(rs.getInt("id"));
master.setUserName(rs.getString("name"));
master.setUserPassword(rs.getString("pass"));
master.setJoindate(rs.getString("joindate"));
master.setClassid(rs.getInt("classid"));
master.setLoginnum(rs.getInt("loginnum"));
master.setUserTruename(rs.getString("truename"));
}
}catch(Exception e){
System.err.println(e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return master;
}}