谁帮我看看阿
dbBean.java
package pub;
import java.sql.*;
import java.io.*;
import java.util.*;
import OP.GetSQL;
public class dbBean {
public Connection conn = null;
public Statement stmt = null;
public ResultSet rs = null;
dbBean dbb=new dbBean();
ResultSet rees=dbb.executeQuery(new GetSQL().getSQL());
public dbBean() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e) {
System.err.println("OpenDB():"+e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
conn=DriverManager.getConnection("jdbc:odbc:hytom","a","");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);//execute sql
}
catch (java.sql.SQLException e) {
System.err.println("OpenDB.executeQuery():"+e.getMessage());
}
finally
{
destroy();
}
return rs; }
public void destroy() {
try {
stmt.close();
conn.close();
}
catch(Exception e) {
System.err.println("DBOperate.destroy():"+e.getMessage());
}
}
}
-----------------------------
GetSQL.java
package OP;
import java.sql.*;
import java.util.*;
public class GetSQL {
GetSQL gs = new GetSQL();
private String orderID, proID, customer, Sale_Quant, handler, totals,
order_time, order_type;
public void setOrderID(String s) {
orderID = new String(s.toString());
}
public void setProID(String s) {
proID = new String(s.toString());
}
public void setCustomer(String s) {
customer = new String(s.toString());
}
public void setSale_Quant(String s) {
Sale_Quant = new String(s.toString());
}
public void setHandler(String s) {
handler = new String(s.toString());
}
public void setTotals(String s) {
totals = new String(s.toString());
}
public void setOrder_time(String s) {
order_time = new String(s.toString());
}
public void setOrder_type(String s) {
order_type = new String(s.toString());
}
String names[] = {
"orderID", "proID", "customer", "Sale_Quant", "handler", "totals",
"order_time", "order_type"};
String values[] = {
orderID, proID, customer, Sale_Quant, handler, totals, order_time,
order_type};
String sql;
int j = 0;
public String getSQL() {
for (int i = 0; i < values.length + 1; i++) {
if (values[i] != null) {
sql = "select * from HY_ORDER_TABLE where '" + names[i] + "'='" +
values[i] + "'";
j = i;
}
break;
}
for (int i = j; i < values.length + 1; i++) {
if (values[i] != null) {
sql = "select * from HY_ORDER_TABLE where '" + names[i] + "'='" +
values[i] + "'";
}
}
return sql;
}
}
-----------------------
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询</title>
</head>
<body>
<form method="POST" action="t.jsp"><p>主键<input type="text" name="orderId" size="20">
<p>产品ID<input type="text" name="proId" size="20">
<p>客户厂家名称<input type="text" name="customer" size="20">
<p>出货数量<input type="text" name="Sale_Quant" size="20">
<p>经手人姓名<input type="text" name="handler" size="20">
<p>总货款数<input type="text" name="totals" size="20">
<p>下单时间<input type="text" name="order_time" size="20">
<p>审批类型<input type="text" name="order_type" size="20">
<p><input type="submit" value="提交" name="B1"><input type="reset" value="重置" name="B2"></p>
</form>
</body>
</html>
还差一个 jsp 文件 调用。我不会写
谁帮我看看,谢谢了