[jboss-user] [JBoss Portal] - test reply max character --you can delete this reply

Thursday, 19 October 2006

Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
public DataSource()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); 
}
catch (ClassNotFoundException e){
System.err.println("class loader error: "+e.getMessage());
}
}

public Connection getConn()
{
try
{
String url="jdbc:oracle:thin:@10.56.69.94:1521:FITI"; 
String user="wipuser"; 
String password="wipuser"; 
conn= DriverManager.getConnection(url,user,password); 
}
catch(SQLException e)
{
e.getMessage();
}
return conn;
}

public ArrayList getVendorMsgList(String date)
{
ArrayList arr = new ArrayList();
String sql="SELECT DISTINCT
VENDORID,TRIM(VENDORNAME),TRIM(VENDOR_CONTACTOR),TRIM(EMAIL_ADDRESS),nvl(PEMAIL,'
') as PEMAIL,nvl(PNAME,' ') as PNAME FROM WEB1_PUR_ITEM_FORECAST WHERE
IMPORT_MONTH='"+date+"' ORDER BY VENDORID ,pemail";
try 
{ String mmail="";String mname="";
conn = getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
String vendid="";
while(rs.next())
{ VendorMsgVo vo = new VendorMsgVo();

View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979296#...

Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[jboss-user] [JBoss Portal] - test reply max character --you can delete this reply