remobabu Posted December 14, 2012 Report Posted December 14, 2012 [img]http://www.andhrafriends.com/uploads/gallery/album_15/gallery_24383_15_147101.gif[/img]
chinni005 Posted December 14, 2012 Author Report Posted December 14, 2012 sry adhi exporting DB to CVS file in java
biscuitRAJA000 Posted December 14, 2012 Report Posted December 14, 2012 [quote name='manmadudhu' timestamp='1355494340' post='1302950523'] gm [/quote] gm
chinni005 Posted December 14, 2012 Author Report Posted December 14, 2012 @fake try this [CODE] public void actionPerformed(ActionEvent evt) { private String m_MySqlPath=""; ResultSet res=null; res = DBHandler.getInstance().executeQuery("select @@basedir",null); while(res.next()) { m_MySqlPath=res.getString(1) ; } m_MySqlPath = m_MySqlPath.replace("\\Data\\", "\\bin\\"); if (exportDB.isSelected() { try { String executeCmd = m_MySqlPath + "\\mysqldump -u " + DB_USER +" -p" + DB_PASSWORD + " " + DB_NAME + " -r " + "\""+FilePath + "\\" + FileName+"\""; Process runtimeProcess = Runtime.getRuntime().exec(executeCmd, null); BufferedReader r=new BufferedReader(new InputStreamReader(runtimeProcess.getInputStream())); String s; while((s=r.readLine())!=null) { System.out.println(s); } return true; } catch (final Exception ex) { ex.printstackTrace(); return false; } } [/CODE]
Recommended Posts