<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%@ include file="/public/checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/><%!
ResultSet rs = null;
String username = "";
String truename = "";
String password = "";
String priv_ok = "";
int priv = 0;
%><html><head>
<title>帐号管理</title>
<link rel="stylesheet" href="../public/style.css">
</head><Body class="ss">
<center>
<%
priv_ok = (String)session.getAttribute("adminpriv");if(priv_ok!=null && priv_ok.equals("8")) { rs = conn.executeQuery("select * from test_admin");
if(!rs.next()) {
out.println("<center>");
out.println("数据库中还没有用户!<br>");
out.println("单击这里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
} else {
%>
<%@page import="java.sql.*"%>
<%@ include file="/public/checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/><%!
ResultSet rs = null;
String username = "";
String truename = "";
String password = "";
String priv_ok = "";
int priv = 0;
%><html><head>
<title>帐号管理</title>
<link rel="stylesheet" href="../public/style.css">
</head><Body class="ss">
<center>
<%
priv_ok = (String)session.getAttribute("adminpriv");if(priv_ok!=null && priv_ok.equals("8")) { rs = conn.executeQuery("select * from test_admin");
if(!rs.next()) {
out.println("<center>");
out.println("数据库中还没有用户!<br>");
out.println("单击这里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
} else {
%>
解决方案 »
- Enterprise Application工程配置及部署问题
- hibernate解决了lazy后产生的疑问,请大家进来探讨!!!
- 我安装的j2ee怎么没有J2ee.bat---我是新手
- 关于Struts错误的问题
- 对 ServiceLocator 的一点疑惑?
- 返回数据集的问题?
- ejb 下面本地接口AccountBean,编译时生成的AccountBean_8259n1_OImpl.java,等等程序文件有什么用
- 一款用于测试发布于服务器端(如Weblogic, Websphere)的 EJB组件、Servlet以及 Beans的黑盒/白盒智能化测试工具
- 为什么我不能”import javax.ejb.EJBObject;“ ?急!!!救救我
- 求解答问题有点复杂啊、
- 求struts+hibernate代码
- 哪位给发个jdk?
<tr>
<th width="20%">用户名</th>
<th width="16%">真实姓名</th>
<th width="16%">密码</th>
<th width="16%">面试权限</th>
<th width="16%">管理权限</th>
<th width="16%" colspan=2>操作</th>
</tr>
<%do {
username = rs.getString("loginname");
truename = rs.getString("truename");
password = rs.getString("password");
priv = rs.getInt("PRIVILEDGE");
%>
<tr align="center">
<form action="accountchange.jsp" method="post">
<td><%=username%></td>
<input type="hidden" name="username" value="<%=username%>">
<td><input type="text" name="truename" value="<%=truename%>"></td>
<td><input type="text" name="password" value="<%=password%>"></td>
<%
if(priv == 1) {
%>
<td>
<Input name="priv" type="radio" value="1" checked>
</td>
<td>
<Input name="priv" type="radio" value="8">
</td>
<%
}else if(priv == 8) {
%>
<td>
<Input name="priv" type="radio" value="1">
</td>
<td>
<Input name="priv" type="radio" value="8" checked>
</td>
<%
}
%>
<td><input type="submit" name="oper" value="修改"></td>
<td><input type="submit" name="oper" value="删除"></td>
</form>
</tr>
<% } while(rs.next());%>
<tr>
<td colspan=7><hr color="white"></td>
</tr>
<form action="accountadd.jsp">
<tr align="center">
<td><input type="text" name="username"></td>
<td><input type="text" name="truename"></td>
<td><input type="text" name="password"></td>
<td><input type="radio" name="priv" value="1" checked></td>
<td><input type="radio" name="priv" value="8"></td>
<td colspan="2">
<Input type="submit" value="添加">
</td>
</tr>
</form>
</table>
<%
}
} else {
out.println("对不起,您的权限不足!<br>");
out.println("单击这里<a href=javascript:history.back()>返回</a><br>");
}
%>
</form>
</center>
</Body></html>
connoracle.class文件package test;import java.io.PrintStream;
import java.sql.*;public class ConnOracle
{ String serverName;
String sDBDriver;
String sConnStr;
Connection connect;
ResultSet rs; public ConnOracle()
{
serverName = "localhost";
sDBDriver = "oracle.jdbc.driver.OracleDriver";
sConnStr = "jdbc:oracle:thin:@" + serverName + ":1521:myoracle";
connect = null;
rs = null;
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println(classnotfoundexception.getMessage());
}
} public ResultSet executeQuery(String s)
{
try
{
connect = DriverManager.getConnection(sConnStr, "scott", "tiger");
Statement statement = connect.createStatement(1004, 1007);
rs = statement.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
return rs;
} public int executeUpdate(String s)
{
int i = 0;
try
{
connect = DriverManager.getConnection(sConnStr, "scott", "tiger");
Statement statement = connect.createStatement(1004, 1007);
i = statement.executeUpdate(s);
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
return i;
}
}
-----------------------------------------------
如果这里不正常,试用这些方法
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<%@ page contentType="text/html; charset=GB2312"%>
request.setCharacterEncoding("GB2312");
或取回内容转换编码
String value = new String(str.getBytes("ISO8859-1"),"GBK");
其次,如果取回数没有问题,确认你数据库是GBK还是ASCII的,数据转换编码
String value = new String(str.getBytes(),"GBK");
或String value = new String(str.getBytes(),"ISO8859-1");
http://dev.csdn.net/develop/article/27/article/27/27837.shtm