dwr js 查询 java jsp

package com.page.db; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.Properties; import org.apache.log4j.Logger; public class MYSQL { /** * @param args * @throws Exception */ public static void main(String[] args) throws Exception { // TODO Auto-generated method stub // System.out.println("dd"+new Timestamp (System.currentTimeMillis())); // System.out.println(new SimpleDateFormat("yyyy-MM-dd HH/mm/ss/SSSS").format(new java.util.Date(System.currentTimeMillis()))); MYSQL a=new MYSQL(); Connection con=a.getConnection(); Statement st=con.createStatement(); String sql="SELECT * FROM user "; ResultSet rs=st.executeQuery(sql); while(rs.next()) { System.out.println("+++++++"+rs.getString(1)); System.out.println("+++++++"+rs.getString(2)); } //System.out.println(rs.getDate(0)); //System.out.println(rs.toString()); } // window 环境下用 //start private static Logger logger = Logger.getLogger(MYSQL.class); private Connection conn = null; private String dirver = null; private String url = null; private String sUser = null; private String pWord = null; public MYSQL() throws Exception { Properties p = new Properties(); InputStream in = MYSQL.class.getClassLoader().getResourceAsStream("mysqlconfig.properties"); try { p.load(in); logger.info("加载配置文件成功!"); //System.out.println("加载配置文件成功!"); } catch (IOException e) { logger.error("加载配置文件出错：" + e); //System.out.println("加载配置文件出错："+e); throw e; } dirver = p.getProperty("driver"); //System.out.println(p2.getProperty("driver")+" "+p2.getProperty("url")+" "+p2.getProperty("uname")); url = p.getProperty("url"); sUser = p.getProperty("uname"); pWord = p.getProperty("pword"); init(); } public void init() throws Exception { try { Class.forName(dirver).newInstance(); conn = DriverManager.getConnection(url, sUser, pWord); } catch (InstantiationException e) { logger.error("数据库连接超：" + e); //System.out.println("数据库连接超：" + e); throw e; } catch (IllegalAccessException e) { logger.error("数据库连接超：" + e); //System.out.println("数据库连接超：" + e); throw e; } catch (ClassNotFoundException e) { logger.error("数据库连接超：" + e); //System.out.println("数据库连接超：" + e); throw e; } catch (SQLException e) { logger.error("数据库连接超：" + e); //System.out.println("数据库连接超：" + e); throw e; } } public Connection getConnection() throws SQLException{ if (conn == null) { throw new SQLException("数据库连接超！！！"); } return conn; } //end //unix 环境下用， /*public Connection getConnection() throws SQLException{ return DbPool.getConn(); }*/ }