以下是公司前辈让我参考已有文档自己做的程序 也不知道对不对
package com.zjxcsoft.ge.user.action;
import java.sql.*;
import com.opensymphony.xwork.ActionSupport;
import java.sql.Connection;
public class UserAction extends ActionSupport {
public UserAction() {
}
public void query(Connection conn, String sql){
try{
if(conn==null){
throw new Exception("database connection can't use!");
}
if(sql==null) throw new Exception("check your parameter: 'sql'! don't input null!");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rmeta = rs.getMetaData();
int numColumns = rmeta.getColumnCount();
while(rs.next())
{
for(int i = 0;i< numColumns;i++)
{
String sTemp = rs.getString(i+1);
System.out.print(sTemp+" ");
}
System.out.println("");
}
}catch(Exception e){
System.out.println("query error:"+e);
}
}
public String getUserList(String sql1) {
com.zjxcsoft.util.DBControl dbc = new com.zjxcsoft.util.DBControl();
com.zjhcsoft.util.DbAction dba = new com.zjhcsoft.util.DbAction();
Connection conn = null;
conn = dbc.getDBConnetion();
try{
String sql = sql1;
query(conn,sql);
conn.close();
}catch(SQLException se){
System.out.println(se);
} catch(Exception e){
System.out.println(e);
}
return "success";
}
// public static void main(String[] args) {
// UserAction user = new UserAction();
// String sql = "select * from GEUSER";
// user.getUserList(sql);
// }
package com.zjxcsoft.ge.user.service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.zjxcsoft.ge.user.action.UserAction;
import com.zjxcsoft.ge.user.domain.UserDomain;
import com.zjxcsoft.system.persistent.db.ibatis.IbatisDao;
public class UserService {
private Connection conn = null;
private IbatisDao dao = null;
public UserService() {
}
public UserService(Connection con) {
this.conn = con;
}
public List UserList(String sqll){
if(conn==null){
System.out.println("database connection can't use!");
}
PreparedStatement pstmt = null;
ResultSet rs = null;
ArrayList list=new ArrayList();
try {
String sql=sqll;
pstmt=this.conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next()){
UserDomain domain=new UserDomain();
domain.setUserid(rs.getString("userid"));
domain.setCustomid(rs.getString("customid"));
domain.setUsername(rs.getString("username"));
System.out.println(rs.getString("userid")+" "+rs.getString("customid")+" "+rs.getString("username"));
list.add(domain);
}
rs.close();
rs = null;
pstmt.close();
pstmt = null;
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if (rs != null) {
rs.close();
rs = null;
}
if (pstmt != null) {
pstmt.close();
pstmt = null;
}
}
catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
public static void main(String[] args) {
UserAction user = new UserAction();
String sql = "select userid,customid,username from geuser";
user.getUserList(sql);
}
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
this.conn = conn;
}
public IbatisDao getDao() {
return dao;
}
public void setDao(IbatisDao dao) {
this.dao = dao;
}
}
最后是自己做的一个简单的网页 我知道有问题 但是不知道具体在哪 怎么修改 请大神帮帮忙
因为基础比较差 所以写的很凌乱 有些地方可能与主题无关也不知道
<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="/webwork" prefix="ww" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
搜索
<script src="./js/cookie.js" type="text/javascript"></script>
SELECT FROM GEUSER
');">
/ww:if
');"> var tempareaid='<ww:property value="userid"/>';
/ww:iterator
/ww:if
<!--modify 3-->
