java菜鸟求大神-Java教程-爱易网页

java菜鸟求大神

日期：2014-05-20　浏览次数：20728 次

java初学者求大神
代码
<%@ page language="java" import="java.sql.*"
contentType="text/html; charset=gb2312" pageEncoding="gb2312"%>
<%@page import="java.lang.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Insert title here</title>
</head>
<body>

<%
java.sql.Connection conn;
java.lang.String strConn;
java.sql.PreparedStatement preparedStmt = null;
//语句对象
java.sql.ResultSet sqlRst = null; //结果集对象
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = java.sql.DriverManager.getConnection(
"jdbc:oracle:thin:@10.128.9.239:1522:ADP630",
"javastudy", "javastudy");
//设置参数
String parm = request.getParameter("parm");
    String parm1=new String(request.getParameter("parm1").getBytes("iso-8859-1"));
    String parm2=new String(request.getParameter("parm2").getBytes("iso-8859-1"));

if (parm != null) {
preparedStmt = conn
.prepareStatement("select * from EMP t where EMPCODE like ?");
preparedStmt.setString(1, "%" + parm + "%");
sqlRst = preparedStmt.executeQuery();
} else if ((parm == null) && (parm1 != null)) {
preparedStmt = conn
.prepareStatement("select * from EMP t where EMPNAME like ?");
preparedStmt.setString(1,"%" + parm1 + "%");
sqlRst = preparedStmt.executeQuery();
} else if ((parm == null) && (parm1 == null) && (parm2 != null)) {
preparedStmt = conn
.prepareStatement("select * from EMP t where SEX like ?");
preparedStmt.setString(1, "%" + parm2 + "%");
sqlRst = preparedStmt.executeQuery();
} else
out.println("请输入：");
//执行SQL 语句
%>
<center>顾客信息表</center>
<table border="1" width="100％" cellspacing="0">
<tr>

<td align="center">编码</td>
<td align="center">姓名</td>
<td align="center">性别</td>
<td align="center">生日</td>
<td align="center">邮编</td>
<td align="center">地址</td>
<td align="center">电话</td>
<td align="center">工资</td>
</tr>
<%
while (sqlRst.next()) { //取得下一条记录
%>
<tr>

<td align="center"><%=sqlRst.getString("empcode")%></td>
<td align="center"><%=new String(sqlRst.getString("EMPNAME").getBytes(
"gb2312"))%></td>
<td align="center"><%=new String(sqlRst.getString("SEX").getBytes(
"gb2312"))%></td>
<td align="center"><%=new String(sqlRst.getString("BIRTHDAY").getBytes(
"iso-8859-1"))%></td>
<td align="center"><%=new String(sqlRst.getString("POSTCODE").getBytes(

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

java菜鸟求大神

相关资料更多>

推荐阅读更多>

java菜鸟 求大神

相关资料更多>

推荐阅读更多>

java菜鸟求大神