📄 jsp.txt

📁 基于jsp的人事管理系统
💻 TXT
📖 第 1 页 / 共 2 页
字号:
上一页 12
  
 作者： 宋福钰   2006-5-29 19:30 　 回复此发言    
 
--------------------------------------------------------------------------------
 
7 回复：公司人事管理系统-东北大学东软信息学院计算机系软件工程045  
 totallogin.jsp 


<%@ page language="java" import="java.sql.*" %> 
<%@ page contentType="text/html;charset=gb2312"%> 
<html> 
<head> 
<title>用户登录界面</title> 
<SCRIPT LANGUAGE="JavaScript"> 
function setf() 
{ 
document.S_form.username.focus(); 
} 
function cancle() 
{ document.S_form.username.value=""; 
document.S_form.password.value=""; 
return false; 
} 
function selec(txt) 
{ 
txt.focus(); 
txt.select(); 
} 
function chkUser(txt) 
{ var user = document.S_form.username; 
if (user.value=="") 
{ 
alert ("please input username"); 
selec(txt); 
return false; 
}else{ 
return true;} 
} 
function chkPw(txt) 
{ var pw = document.S_form.password; 
if (pw.value=="") 
{ 
alert ("please input password"); 
selec(txt); 
return false; 
}else{ 
return true;} 
} 
function chkUserPw() 
{var user = document.S_form.username; 
 var pw = document.S_form.password; 
if(chkUser(user)) 
{ 
if(chkPw(pw)) 
{ 
return true; 
} 
return false; 
} 
return false; 
} 
</SCRIPT> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<LINK href="/DSN/b.files/art.css" rel=stylesheet type=text/css> 
</head> 

 <body background="/DSN/b.files/bj.gif"> 

<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%"　> 
 <TBODY> 
 <TR class=top> 
 <TD width=296><IMG align=left  
 alt=SoftshapeArt border=0 height=58 hspace=0 src="/DSN/b.files/top1.gif"  
 width=80><IMG align=left border=0 height=58 hspace=0  
 src="/DSN/b.files/top2.gif" width=216></TD> 
 <TD>  </TD> 
 <TD width=517>  </TD> 
 </TR></TBODY></TABLE> 
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%"> 
 <TBODY>  
 <TR > 
 <td width="16%"> <IMG align=left border=0 height=22 hspace=0 src="/DSN/b.files/nav1.gif"  
 width=165></td> 
  
 </TR></TBODY></TABLE> 
<TABLE border=0 cellPadding=0 cellSpacing=0 class=splash width="100%"> 
 <TBODY>  
 <TR>  
 <TD class=splash width="8%" align="center" valign="bottom"><IMG align=left border=0 height=72 hspace=0  
 src="/DSN/b.files/spl_1.gif" width=76></TD> 
 <TD width="92%" align="center"><font size="5">公司内部管理系统</font> </TD> 
 </TR> 
 </TBODY>  
</TABLE> 
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="299"> 
 <tr> 
 <td height="207" width="27%"> </td> 
 <td height="207" width="39%"> 
 <form method="POST" action="totalLogin1.jsp" name="S_form" onSubmit="return chkUserPw()"> 
 <table width="350" border="0" cellspacing="0" cellpadding="0" height="235" align="center">  
 <tr>  
 <td align="center">  
 <table border=0 width=259 cellpadding="0" cellspacing="0" height="180"> 
 <tr align="center" valign="bottom">  
 <td colspan="2" height="30">  
 <table width="150" border="0" cellspacing="0" cellpadding="0"> 
 <tr>  
 <td><b class="Blue">user name</b></td> 
 </tr> 
 </table> 
 </td> 
 </tr> 
 <tr align="center">  
 <td colspan="2" height="35">  
 <input class=bo1 type="text" name="username" size="20" tabindex="1" selected> 
 </td> 
 </tr> 
 <tr align="center" valign="bottom">  
 <td colspan="2" height="15"><span class=Blue></span>  
 <table width="150" border="0" cellspacing="0" cellpadding="0"> 
 <tr>  
 <td><span class=Blue><b>password</b></span></td> 
 </tr> 
 </table> 
 </td> 
 </tr> 
 <tr align="center">  
 <td colspan="2" height="35">  
 <input type="password" name="password" size="20" tabindex="2" class="bo1"> 
 </td> 
 </tr> 
 <tr>  
 <td align="center" height="65">  
 <input type="image" border="0" name="imageField" src="../DSN/b.files/login.gif" width="60" height="25"> 
 </td> 
 <td align="center" height="65">  
 <input type="image" border="0" name="imageField2" src="../DSN/b.files/reset.gif" width="60" height="25" onclick="return cancle();"> 
 </td> 
 </tr> 
 </table> 
 </td> 
 </tr>  
 </table> 
 </form> 
 </td> 
 <td height="207" width="34%"> </td> 
 </tr> 
</table> 
<p> </p> 
</body> 
</html>  
 
  
 作者： 宋福钰   2006-5-29 19:31 　 回复此发言    
 
--------------------------------------------------------------------------------
 
8 回复：公司人事管理系统-东北大学东软信息学院计算机系软件工程045  
 restWrite.jsp 

<%@ page language="java" import="java.sql.*" %> 
<%@ page contentType="text/html;charset=gb2312"%> 
<html> 
<head> 
<title>请假的写入</title> 
</head> 
<body bgcolor="#ffffff" text="#000000"> 
<jsp:useBean id="db" scope="page" class="opendb.opendb"/> 
<% 
 String personID=(String)session.getAttribute("personID");  
 String Syear=request.getParameter("Syear"); 
 Syear=Syear.trim(); 
 String Smonth=request.getParameter("Smonth"); 
Smonth=Smonth.trim(); 
String Sday=request.getParameter("Sday"); 
Sday=Sday.trim(); 
String Shour=request.getParameter("Shour"); 
Shour=Shour.trim(); 
String Sminute=request.getParameter("Sminute"); 
Sminute=Sminute.trim(); 
String Eyear=request.getParameter("Eyear"); 
Eyear=Eyear.trim(); 
String Emonth=request.getParameter("Emonth"); 
Emonth=Emonth.trim(); 
String Eday=request.getParameter("Eday"); 
Eday=Eday.trim(); 
String Ehour=request.getParameter("Ehour"); 
Ehour=Ehour.trim(); 
String Eminute=request.getParameter("Eminute"); 
Eminute=Eminute.trim(); 
int hours=Integer.parseInt(request.getParameter("hours")); 
String cause = new String((request.getParameter("cause")).getBytes("ISO8859-1"),"gb2312");  
 //String Adate; 
 //Date usertime=new Date(); 
 //Adate=(String)usertime.getTime(); 
 String Sdate; 
Sdate=Syear+Smonth+Sday+Shour+Sminute; 
String Edate; 
Edate=Eyear+Emonth+Eday+Ehour+Eminute; 
 String sql=""; 
 sql=sql+"insert into wglMESSAGE "; 
sql=sql+"(EMP_CODE,"; 
sql=sql+"M_STIME,"; 
sql=sql+"M_ETIME,"; 
sql=sql+"M_HOURS,"; 
sql=sql+"M_CAUSE,"; 
sql=sql+"M_TIME)"; 

sql=sql+" values("; 
sql=sql+"'"+ personID +"',"; 
 sql=sql+"'" + Sdate + "',"; 
sql=sql+"'"+ Edate + "',"; 
sql=sql+"" + hours + ","; 
sql=sql+"'" + cause + "',"; 
sql=sql+"getdate())"; 
ResultSet rs=db.executeQuery(sql); 
%> 
<p align="center">您已经提交成功！</p> 
<p align="center"><a href="userBack.jsp">返回</a></p>  
</body> 
</html>  
 
  
 作者： 宋福钰   2006-5-29 19:33 　 回复此发言    
 
--------------------------------------------------------------------------------
 
9 回复：公司人事管理系统-东北大学东软信息学院计算机系软件工程045  
 Firm.java 



package firm; 
import java.sql.*; 

public class Firm 
{  
 String strDBDriver="sun.jdbc.odbc.JdbcOdbcDriver"; 
 String strDBUrl="jdbc:odbc:firm"; 
 private Connection conn=null; 
 private Statement stmt=null; 
 ResultSet rs=null; 
 //<!--注册数据库驱动程序--> 
 public firm() 
 { 
  try 
  { 
   Class.forName(strDBDriver); 
  } 
  //异常处理 
  catch(java.lang.ClassNotFoundException e)  
 { 
 System.err.println("firm():"+e.getMessage()); 
 } 
 } 
 //<!--建立数据库连接及定义数据查询--> 
 public ResultSet executeQuery(String sql) 
 { 
 rs=null; 
 try 
 { 
   conn=DriverManager.getConnection(strDBUrl,"sa","");//创建数据库连接对象  
 stmt=conn.createStatement(); 
 rs=stmt.executeQuery(sql); 
 } 
 catch(SQLException ex)  
 { 
   System.err.println("aq.executeQuery:"+ex.getMessage()); 
 } 
 return rs; 
 } 
 //<!--定义数据操作--> 
 public void executeUpdate(String sql) 
 { 
 stmt=null; 
 rs=null; 
 try 
 { 
   conn=DriverManager.getConnection(strDBUrl,"sa",""); 
   stmt=conn.createStatement(); 
   stmt.executeQuery(sql); 
   stmt.close(); 
   conn.close(); 
 } 
 catch(SQLException ex) 
 { 
 System.err.println("aq.executeQuery:"+ex.getMessage()); 
 } 
 } 
 //<!--关闭数据库连接--> 
 public void closeStmt() 
 { 
 try 
 { 
  stmt.close(); 
 } 
 catch(SQLException e) 
 { 
   e.printStackTrace(); 
 } 
 } 
 public void closeConn() 
 { 
 try 
 { 
 conn.close(); 
 } 
 catch(SQLException e) 
 { 
 e.printStackTrace(); 
 } 
 } 
}
上一页 12
💿 文件大小 7 K
👤 上传用户 x8610341
📂 所属分类 Jsp/Servlet
🏷️ 相关标签

#jsp #管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -