急求java程序，现有访问数据库的程序，里面的sql是固定的，求java界面，可以输入sql语句，同时能够将查询

我用netbeans 写的，，在IE上可以运行结果，，，直接查询数据库内容，，加驱动mysql-connector-java<%@page contentType="text/html" pageEncoding="GBK"%>
<%@page language="java" import="java.util.*"%>
<%@page import="com.java.*" import="java.sql.*"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>







<%
List list=new ArrayList();

try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("创建驱动成功！");
Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/testbank","root","1989");
System.out.println("连接数据库成功！");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from dept");
while(rs.next()){
DeptVo deptvo=new DeptVo();
deptvo.setId(rs.getString("id"));
deptvo.setAddress(rs.getString("address"));
deptvo.setNum(rs.getInt("num"));
deptvo.setName(rs.getString("name"));
deptvo.setD_id(rs.getInt("d_id"));
list.add(deptvo);
}
request.setAttribute("list",list);
}catch(Exception e){

}
%>

部门编号	部门地址	部门人数	部门名称	部门id
${list.id}	${list.address}	${list.num}	${list.name}	${list.d_id}

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.java;
public class DeptVo {
private String id;
private String address;
private int num;
private String name;
private int d_id;
public String getAddress(){
return address;
}
public void setAddress(String address){
this.address=address;
}
public String getId(){
return id;
}
public void setId(String id){
this.id=id;
}
public int getNum(){
return num;
}
public void setNum(int num){
this.num=num;
}

public String getName(){
return name;
}
public void setName(String name){
this.name=name;
}
public int getD_id(){
return d_id;
}
public void setD_id(int d_id){
this.d_id=d_id;
}

}
可以用eclipse,,
package com.cn.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

//import java.awt.List;

public class Query {
public List showUser(){
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
List list=new ArrayList();
try{
conn=JDBC_Connection.getConnection();
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from users");
while(rs.next()){
UserVo userVo=new UserVo();
userVo.setId(rs.getInt("id"));
userVo.setName(rs.getString("name"));
userVo.setAge(rs.getInt("age"));
userVo.setTel(rs.getString("tel"));
userVo.setAddress(rs.getString("address"));
list.add(userVo);

}
}catch(SQLException e){
e.printStackTrace();
}finally{
JDBC_Connection.free(rs, conn, stmt);
}
return list;
}
public static void main(String[] args) {
Query query=new Query();
List list=query.showUser();
if(list!=null){
System.out.print("id\t");
System.out.print("name\t");
System.out.print("age\t");
System.out.print("tel\t");
System.out.print("address\t");
System.out.println();
for(int i=0;i System.out.print(list.get(i).getId()+"\t");
System.out.print(list.get(i).getName()+"\t");
System.out.print(list.get(i).getAge()+"\t");
System.out.print(list.get(i).getTel()+"\t ");
System.out.print(list.get(i).getAddress()+"\t");
System.out.println();
}

}

}

}
package com.cn.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.PreparedStatement;

public class QueryById {
public UserVo queryUserById(int id){
UserVo userVo=null;
Connection conn=null;
PreparedStatement psmt=null;
ResultSet rs=null;
try{
conn=JDBC_Connection.getConnection();
psmt=(PreparedStatement) conn.prepareStatement("select * from users where id=?");
psmt.setInt(1, id);
rs=psmt.executeQuery();
while(rs.next()){
userVo=new UserVo();
userVo.setId(rs.getInt("id"));
userVo.setName(rs.getString("name"));
userVo.setAge(rs.getInt("age"));
userVo.setTel(rs.getString("tel"));
userVo.setAddress(rs.getString("address"));
}
}catch(SQLException e){
e.printStackTrace();
}finally{
JDBC_Connection.free(rs,conn,psmt);
}

return userVo;

}
public static void main(String[] args) {
QueryById byId=new QueryById();
int id=211;
UserVo vo=byId.queryUserById(id);
if(vo!=null){
System.out.print("id\t");
System.out.print("name\t");
System.out.print("age\t");
System.out.print("tel\t");
System.out.print("address\t");
System.out.println();
System.out.print(vo.getId()+"\t");
System.out.print(vo.getName()+"\t");
System.out.print(vo.getAge()+"\t");
System.out.print(vo.getTel()+"\t ");
System.out.print(vo.getAddress()+"\t");
System.out.println();
}else{
System.out.println("id为"+id+"的用户不存在");
}

}

}
package com.cn.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.PreparedStatement;

public class QueryById {
public UserVo queryUserById(int id){
UserVo userVo=null;
Connection conn=null;
PreparedStatement psmt=null;
ResultSet rs=null;
try{
conn=JDBC_Connection.getConnection();
psmt=(PreparedStatement) conn.prepareStatement("select * from users where id=?");
psmt.setInt(1, id);
rs=psmt.executeQuery();
while(rs.next()){
userVo=new UserVo();
userVo.setId(rs.getInt("id"));
userVo.setName(rs.getString("name"));
userVo.setAge(rs.getInt("age"));
userVo.setTel(rs.getString("tel"));
userVo.setAddress(rs.getString("address"));
}
}catch(SQLException e){
e.printStackTrace();
}finally{
JDBC_Connection.free(rs,conn,psmt);
}

return userVo;

}
public static void main(String[] args) {
QueryById byId=new QueryById();
int id=211;
UserVo vo=byId.queryUserById(id);
if(vo!=null){
System.out.print("id\t");
System.out.print("name\t");
System.out.print("age\t");
System.out.print("tel\t");
System.out.print("address\t");
System.out.println();
System.out.print(vo.getId()+"\t");
System.out.print(vo.getName()+"\t");
System.out.print(vo.getAge()+"\t");
System.out.print(vo.getTel()+"\t ");
System.out.print(vo.getAddress()+"\t");
System.out.println();
}else{
System.out.println("id为"+id+"的用户不存在");
}

}

}
package com.cn.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.PreparedStatement;

public class QueryById {
public UserVo queryUserById(int id){
UserVo userVo=null;
Connection conn=null;
PreparedStatement psmt=null;
ResultSet rs=null;
try{
conn=JDBC_Connection.getConnection();
psmt=(PreparedStatement) conn.prepareStatement("select * from users where id=?");
psmt.setInt(1, id);
rs=psmt.executeQuery();
while(rs.next()){
userVo=new UserVo();
userVo.setId(rs.getInt("id"));
userVo.setName(rs.getString("name"));
userVo.setAge(rs.getInt("age"));
userVo.setTel(rs.getString("tel"));
userVo.setAddress(rs.getString("address"));
}
}catch(SQLException e){
e.printStackTrace();
}finally{
JDBC_Connection.free(rs,conn,psmt);
}

return userVo;

}
public static void main(String[] args) {
QueryById byId=new QueryById();
int id=211;
UserVo vo=byId.queryUserById(id);
if(vo!=null){
System.out.print("id\t");
System.out.print("name\t");
System.out.print("age\t");
System.out.print("tel\t");
System.out.print("address\t");
System.out.println();
System.out.print(vo.getId()+"\t");
System.out.print(vo.getName()+"\t");
System.out.print(vo.getAge()+"\t");
System.out.print(vo.getTel()+"\t ");
System.out.print(vo.getAddress()+"\t");
System.out.println();
}else{
System.out.println("id为"+id+"的用户不存在");
}

}

}
package com.cn.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.PreparedStatement;

public class QueryById {
public UserVo queryUserById(int id){
UserVo userVo=null;
Connection conn=null;
PreparedStatement psmt=null;
ResultSet rs=null;
try{
conn=JDBC_Connection.getConnection();
psmt=(PreparedStatement) conn.prepareStatement("select * from users where id=?");
psmt.setInt(1, id);
rs=psmt.executeQuery();
while(rs.next()){
userVo=new UserVo();
userVo.setId(rs.getInt("id"));
userVo.setName(rs.getString("name"));
userVo.setAge(rs.getInt("age"));
userVo.setTel(rs.getString("tel"));
userVo.setAddress(rs.getString("address"));
}
}catch(SQLException e){
e.printStackTrace();
}finally{
JDBC_Connection.free(rs,conn,psmt);
}

return userVo;

}
public static void main(String[] args) {
QueryById byId=new QueryById();
int id=211;
UserVo vo=byId.queryUserById(id);
if(vo!=null){
System.out.print("id\t");
System.out.print("name\t");
System.out.print("age\t");
System.out.print("tel\t");
System.out.print("address\t");
System.out.println();
System.out.print(vo.getId()+"\t");
System.out.print(vo.getName()+"\t");
System.out.print(vo.getAge()+"\t");
System.out.print(vo.getTel()+"\t ");
System.out.print(vo.getAddress()+"\t");
System.out.println();
}else{
System.out.println("id为"+id+"的用户不存在");
}

}

}
自己加2驱动把，，自己看吧，，

这和一个客户端没什么区别了。
oracle上以前下过一下，你去找找看看

能说清楚 点么？