当前页面: 开发资料首页 → JSP 专题 → Oracle 和 JSP 开发的小型信息管理系统 (三) 源代码2
摘要: Oracle 和 JSP 开发的小型信息管理系统 (三) 源代码2
//articleconn.jsp 数据库连接文件,几乎被每个页面包含,有的页面去掉获得Session,修改一下这个代码,很简单
<%@ page contentType="text/html;charset=big5"%>
<%@ page import="java.sql.*"%>
<%
request.setCharacterEncoding("big5");
Connection conn=null;
Statement stmt=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.56.199:1521:asdb";
String user="system";
String password="oracle01";
conn=DriverManager.getConnection(url, user, password);
}
catch(Exception e1){
e1.printStackTrace();}
%>
//************************************manage.jsp管理页面,提供分页,修改,删除,添加的链接
<%/*Cookie cookies[]=request.getCookies();
if(cookies==null)
{ response.sendRedirect("login.jsp"); }
String userName=(String)session.getAttribute("admin");
out.println("Welcome, "+userName);
if(userName==null)
{response.sendRedirect("login.jsp");}*/
%>
<%@ include file="articleconn.jsp"%>
<head>
<%
request.setCharacterEncoding("big5");
String query=" Select * "+
" from learning order by article_id ";
String title=null;
String queryCount=" select count(*)from learning ";
String strPage=request.getParameter("strPage");
int intPage;
if(strPage==null){
intPage=1;}
else
{intPage=Integer.parseInt(strPage);}
int pageSizes=10;//每頁顯示信息數目
int counts=1;//信息總條數
int pageCounts=1;//總頁數
try{
PreparedStatement ps=conn.prepareStatement(queryCount);
ResultSet rs=ps.executeQuery();
if(rs.next()){
counts=Integer.parseInt(rs.getString(1));}
%>
<body bgcolor="#FFFFFF">
添加信息
返回首頁
//計算總頁數
if(counts%pageSizes==0){pageCounts=counts/pageSizes;}
else{pageCounts=counts/pageSizes+1;}
if(intPage>pageCounts)
{intPage=pageCounts;}
int i=(intPage-1)*pageSizes;
ps=conn.prepareStatement(query);
ResultSet rs1=ps.executeQuery();
/*while(rs1.next())
{String temp=rs1.getString("title");
out.println(temp);}*/
if(counts!=1){
for( int j=0; jrs1.next();}
//out.println(rs1+"
");
i=0;
while(rs1.next()&&i
{out.println("沒有您想看的數據!");}
%>
<tr>
<td width="12%" height="7">
<%= rs1.getString("article_id")%>
}
catch(SQLException se1){se1.printStackTrace();}
finally{}
conn.close();
%>
</td>
</tr>
</table>
<form action="manage.jsp" method="post" >
第<%=intPage%>頁,共<%=pageCounts%>頁
<%
if(intPage
<%}if(intPage>1){%>
">上一頁<%}%>
到第<input type="text" maxlength="5" name="strPage" value="1"/>頁進行查看
<input type="submit" value="確認" class="buttonface"/>
</form>
添加信息
返回首頁
//******************************************FilterSpecial .java过滤用户输入
package moonsoft.test.j2ee.news;
public class FilterSpecial
{
public FilterSpecial()
{
}
public static String filter(String input)
{
if(!hasSpecialChars(input))
{
return input;
}
StringBuffer filtered =new StringBuffer(input.length());
char c;
for(int i=0; i<=input.length()-1; i++)
{
c=input.charAt(i);
switch(c)
{
case '<':filtered.append("<"); break;
case '>':filtered.append(">"); break;
case '"':filtered.append("&uot;"); break;
case '&':filtered.append("&"); break;
default: filtered.append(c);
}
}
return (filtered.toString());
}
public static boolean hasSpecialChars(String input)
{
boolean flag=false;
if((input!=null)&&(input.length()>0))
{
char c;
for(int i=0; i<=input.length()-1; i++)
{
c=input.charAt(i);
switch(c)
{
case '>': flag=true; break;
case '<': flag=true; break;
case '"': flag=true; break;
case '&': flag=true; break;
}
}
}
return flag;
}
}