Wednesday, December 29, 2010

get Mysql path from java

import java.sql.*;
import javax.sql.*;

public class MysqlPathFinderDemo{

public static void main(String args[]){
String dbtime;
String dbUrl = "jdbc:mysql://your.database.domain/yourDBname";
String dbClass = "com.mysql.jdbc.Driver";
String query = "Select * FROM users";

try {

      Class.forName("com.mysql.jdbc.Driver");
      Connection con = DriverManager.getConnection (dbUrl);
      Statement stmt = con.createStatement();
res=Myconnection.st.executeQuery("select @@datadir");
String Mysqlpath="";
      while(res.next()){
          Mysqlpath=res.getString(1) ;
      } 
Mysqlpath=Mysqlpath.replace("Data", "bin"); 
System.err.println("Mysql path is :"+a);
   }catch(Exception ee){
}
 }
} 

Thursday, December 23, 2010

Java - How to print table with multi line header and footer

PrinterJob job = PrinterJob.getPrinterJob();
MessageFormat[] header = new MessageFormat[3];
header[0] = new MessageFormat("");
header[1] = new MessageFormat("line 1");
header[2] = new MessageFormat("line 2");

MessageFormat[] footer = new MessageFormat[2];
footer[0] = new MessageFormat("footer 1");
footer[1] = new MessageFormat("footer 2");
job.setPrintable(new MyTablePrintable(tblmunim, PrintMode.FIT_WIDTH, header, footer));

    if (job.printDialog())
      try {
        System.out.println("Calling PrintJob.print()");
        job.print();
        System.out.println("End PrintJob.print()");
      }
      catch (PrinterException pe) {
        System.out.println("Error printing: " + pe);
      }

Here is MyTablePrintable class  MyPrintable.java