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

[kevnlin]

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#3979296

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