主页登录系统的设计：页面：<%@ page contentType="text/html" pageEncoding="gb2312"%><html><head><link rel="stylesheet" type="text/css" href="css/layout_review.css" /> </head><body><div id="container"><center><div id="header"><div id="logo"></div><div id="banner"></div><div id="menu"><ul><li><a href="home_review.html">编审首页</a></li><li class="tiao"></li><li><a href="introduction.jsp">公司简介</a></li><li class="tiao"></li><li><a href="">规章制度</a></li><li class="tiao"></li><li><a href="">公司详情</a></li><li class="tiao"></li><li><a href="">节日活动</a></li><li class="tiao"></li><li><a href="">相关下载</a></li><li class="tiao"></li><li><a href="">联系我们</a></li><li class="tiao"></li></ul></div></div><center><hr><form action="loginDo.jsp" method="post" name="myform"><font size="8" color="#000000">用户登录</font><table border="2"><tr><td>用  户  名</td><td><input type="text" name="userid"></td></tr><tr><td>密        码</td><td><input type="password" name="password"></td></tr><tr><td>登录类型</td><td><select name="type"><option value="普通用户">普通用户</option><option value="管理员">管理员</option><option value="审稿员">审稿员</option></select></td></tr><tr><td colspan="2"><input type="submit" name="submit" value="登录"><input type="reset" name="reset" value="重置"><a href="register.jsp" target="right">作者注册</a></td><a href="register2.jsp" target="right">审稿员注册</a></td></tr></table></form><hr></center><body style="background:url('image/around.png') no-repeat;"> </body></html>连接数据库：<%@ page contentType="text/html" pageEncoding="gb2312"%><%@ page import="java.sql.*"%><html><head><title></title></head><body><% request.setCharacterEncoding("gb2312");session.setAttribute("userid",request.getParameter("userid"));session.setAttribute("password",request.getParameter("password"));String userid=(String)session.getAttribute("userid");String password=(String)session.getAttribute("password");String type=request.getParameter("type");%><%!public static final String DBDRIVER="org.gjt.mm.mysql.Driver";public static final String DBURL="jdbc:mysql://localhost:3306/sw0334";public static final String DBUSER="root";public static final String DBPASSWORD="mysql";%><%Connection conn=null;PreparedStatement ps=null;ResultSet rs=null;String sql;%><%try{Class.forName(DBDRIVER);conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);if(type.equals("管理员")){sql="select userid,password from admin where userid=? and password=?";ps=conn.prepareStatement(sql);ps.setString(1,userid);ps.setString(2,password);rs=ps.executeQuery();if(rs.next()){%><jsp:forward page="loginAdminPage.jsp"/><%}else{out.println("<h1>登录的用户名密码不正确，请重新输入：</h1>");}}if(type.equals("普通用户")){sql="select userid,password from sw0334 where userid=? and password=?";ps=conn.prepareStatement(sql);ps.setString(1,userid);ps.setString(2,password);rs=ps.executeQuery();if(rs.next()){%><jsp:forward page="loginUserPage.jsp"/><%}else{out.println("<h1>登录的用户名密码不正确，请重新输入：</h1>");}}if(type.equals("审稿员")){sql="select userid,password from writesee where userid=? and password=?";ps=conn.prepareStatement(sql);ps.setString(1,userid);ps.setString(2,password);rs=ps.executeQuery();if(rs.next()){%><jsp:forward page="loginadmin2page.jsp"/><%}else{out.println("<h1>登录的用户名密码不正确，请重新输入：</h1>");}}}catch(Exception e){out.println(e);}finally{try{rs.close();ps.close();conn.close();}catch(Exception e){out.println(e);}}%><%="over"%></body></html>普通用户（作者）个人信息的增删改和稿件上交程序:页面：<%@ page contentType="text/html" pageEncoding="gb2312"%> <%@ page import="java.sql.*"%><html><head><title>普通用户登录后的页面</title><style>#main{width:1000px;height:400px;}#leftStyle{float:left;width:150px;height:400px;}#rightStyle{float:left;width:800px;height:400px;}.nav{float:left;width:100%;height:10px;clear:both;overflow:hidden;}</style></head><body><% request.setCharacterEncoding("gb2312");%><%@ include file="head.jsp"%><div id="main"><div class="nav"></div><div id="leftStyle"><ul><li><a href="loginUserDo.jsp" target="right">查看报名信息</a></li><br><li><a href="registerUpdate.jsp" target="right">修改报名信息</a></li><br><li><a href="writing.jsp" target="right">编写投稿内容</a></li><br><li><a href="deleteDo.jsp" target="right" onclick='return confirm("确定要删除吗？")'>删除报名信息</a></li><br></ul></div><div id="rightStyle"><iframe width=800px height=400px name="right"></iframe></div></div><%@ include file="tail.jsp"%></body></html>数据库连接：<%@ page contentType="text/html" pageEncoding="gb2312"%><%@ page import="java.sql.*"%><html><head><title></title></head><body><% request.setCharacterEncoding("gb2312");%><%!//定义全局变量public static final String DBDRIVER="org.gjt.mm.mysql.Driver";//定义数据库驱动程序public static final String DBURL="jdbc:mysql://localhost:3306/sw0334";//数据库连接地址public static final String DBUSER="root";public static final String DBPASSWORD="mysql";%><%Connection conn=null;//声明数据库连接对象PreparedStatement ps=null;//声明数据库操作ResultSet rs=null;//声明数据库结果集%><%try{Class.forName(DBDRIVER);//加载驱动程序conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//取得数据库连接String sql="select userid,password,name,sex,dept,phone,email,interest1,interest2,note from sw0334 where userid=? and password=?";//编写要使用的SQL语句ps=conn.prepareStatement(sql);//实例化数据库操作对象String userid=(String)session.getAttribute("userid");String password=(String)session.getAttribute("password");ps.setString(1,userid);//设置查询所需要的内容ps.setString(2,password);rs=ps.executeQuery();//执行查询if(rs.next()){%><center><table border="2" width="100%"><br><caption><h1>你的报名信息是</h1></caption><tr><td>用户名</td><td>密码</td><td>真实姓名</td><td>性别</td><td>工作单位</td><td>联系电话</td><td>email</td><td>兴趣爱好1</td><td>兴趣爱好2</td><td>备注</td></tr><tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td><td><%=rs.getString(5)%></td><td><%=rs.getString(6)%></td><td><%=rs.getString(7)%></td><td><%=rs.getString(8)%></td><td><%=rs.getString(9)%></td><td><%=rs.getString(10)%></td></tr></table></center><br><%}else{out.println("<h1>用户名密码不正确！</h1>");}}catch(Exception e){out.println(e);}finally{try{rs.close();//关闭查询对象ps.close();conn.close();}catch(Exception e){out.println(e);}}%></body></html>审稿员的注册及稿件的审阅：页面<%@ page contentType="text/html" pageEncoding="gb2312"%> <%@ page import="java.sql.*"%><html><head><title>审稿员登录后的页面</title><style>#main{width:1000px;height:400px;}#leftStyle{float:left;width:150px;height:400px;}#rightStyle{float:left;width:800px;height:400px;}.nav{float:left;width:100%;height:10px;clear:both;overflow:hidden;}</style></head><body><% request.setCharacterEncoding("gb2312");%><%@ include file="head.jsp"%><div id="main"><div class="nav"></div><div id="leftStyle"><ul><li><a href="loginadmin2do.jsp" target="right">查看个人信息</a></li><br><li><a href="registerUpdate.jsp" target="right">修改个人信息</a></li><br><li><a href="writedo.jsp" target="right">查看稿件内容</a></li><br><li><a href="deleteDo.jsp" target="right" onclick='return confirm("确定要删除吗？")'>删除报名信息</a></li><br></ul></div><div id="rightStyle"><iframe width=800px height=400px name="right"></iframe></div></div><%@ include file="tail.jsp"%></body></html>查看稿件内容调用数据库：<%@ page contentType="text/html" pageEncoding="gb2312"%><%@ page import="java.sql.*"%><html><head><title></title></head><body><% request.setCharacterEncoding("gb2312");%><%!//定义全局变量public static final String DBDRIVER="org.gjt.mm.mysql.Driver";//定义数据库驱动程序public static final String DBURL="jdbc:mysql://localhost:3306/sw0334";//数据库连接地址public static final String DBUSER="root";public static final String DBPASSWORD="mysql";%><%Connection conn=null;//声明数据库连接对象PreparedStatement ps=null;//声明数据库操作ResultSet rs=null;//声明数据库结果集%><%try{Class.forName(DBDRIVER);//加载驱动程序conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);//取得数据库连接String sql = "select name,passname,text from student";ps=conn.prepareStatement(sql);rs=ps.executeQuery();%><center><table border="1" width="100%" color="blue"><br><caption><h1>所有人的报名信息是</h1></caption><br><tr><td>作者姓名</td><td>稿件名称</td><td>稿件内容</td></tr><%while(rs.next()){%><tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td></tr><%}%></table></center><%}catch(Exception e){out.println(e);}finally{try{rs.close();//关闭查询对象ps.close();conn.close();}catch(Exception e){out.println(e);}}%></body></html>。