mysql脱裤工具_脱裤脚本【支持Mysql、Oracle】

Class.forName(driver);

Connection conn=DriverManager.getConnection(url, username, password);

ResultSetMetaData rsmd= null;

ResultSet rs=null;

Statement stmt=conn.createStatement();

out.println("Dumping data for table" +table+ "...
");

OutputStreamWriter osw= newOutputStreamWriter(newFileOutputStream(backupDir+table+ex),"UTF-8");

BufferedWriter bw=newBufferedWriter(osw);

rs=stmt.executeQuery("SELECT * FROM" +table);

rsmd=rs.getMetaData();while(rs.next()) {

bw.append("INSERT INTO" +table+ "VALUES(");//JDBCis 1-based, Javais not!?for(intcol= 1; col<=rsmd.getColumnCount(); col++) {

bw.append("'");if(rs.getString(col)== null)

bw.append("");elsebw.append(rs.getString(col));if(col==rsmd.getColumnCount())

bw.append("'");elsebw.append("',");

}

bw.append(");");

bw.newLine();

}

bw.flush();

bw.close();

osw.close();

rs.close();

stmt.close();

out.println("backup is ok");

conn.close();

}else{

out.println("输入表名...");

}

} catch (Exception e) {

response.setStatus(200);

e.printStackTrace();

}%>

备份目录：/>

table_name:

url:"/>

driver:"/>

username:"/>

password:"/>

oracle.jsp oracle当前用户所有表

Class.forName(driver);

Connection conn=DriverManager.getConnection(url, username, password);// GettablesStringsql_tables="select TABLE_NAME from user_tab_comments";

PreparedStatement ps=conn.prepareStatement(sql_tables);

ResultSet rs=ps.executeQuery();

ArrayListtables= newArrayList();while(rs.next()) {

tables.add(rs.getString(1));

}

rs.close();for(inti=0;i

out.println("Dumping data for table" +table+ "...
");

OutputStreamWriter osw= newOutputStreamWriter(newFileOutputStream(backupDir+table+ex),"UTF-8");

BufferedWriter bw=newBufferedWriter(osw);Stringsql="select * from"+table;

PreparedStatement p=conn.prepareStatement(sql);

ResultSet r=p.executeQuery();

ResultSetMetaData rsmeta=r.getMetaData();while(r.next()){

bw.append("INSERT INTO" +table+ "VALUES(");//JDBCis 1-based, Javais not!?for(intcol= 1; col<=rsmeta.getColumnCount(); col++) {

bw.append("'");if(r.getString(col)== null)

bw.append("");elsebw.append(r.getString(col));if(col==rsmeta.getColumnCount())

bw.append("'");elsebw.append("',");

}

bw.append(");");

bw.newLine();

}

bw.flush();

bw.close();

osw.close();

r.close();

}

rs.close();

out.println("backup is ok");

conn.close();

} catch (Exception e) {

response.setStatus(200);

e.printStackTrace();

}

out.println("

finished

");%>