程序博客网 > mac运行iphone应用

jsp数据库脱裤脚本,可脱mysql,oracle.

来源：互联网 发布：mac运行iphone应用 编辑：程序博客网 时间：2024/05/03 07:01

jsp数据库脱裤脚本,脱各种数据库

mysql.jsp 脱mysql数据库，所有表全脱光


  1. <%@ page import="java.sql.*" %>  
  2.  
  3. <%@ page import="java.util.*" %>  
  4.  
  5. <%@ page import="java.io.*" %>  
  6.  
  7. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
  8.  
  9. <%  
  10.  
  11. try {  
  12.  
  13.     //备份文件存放的绝对路径  
  14.  
  15.     String backupDir = "c:/";  
  16.  
  17.     String ex=".txt";  
  18.  
  19.     String driver = "com.mysql.jdbc.Driver";  
  20.  
  21.       
  22.  
  23.     String url = "jdbc:mysql://localhost:3306/dbname";  
  24.  
  25.     String username = "user";  
  26.  
  27.     String password = "pass";  
  28.  
  29.        
  30.  
  31.     Class.forName(driver);  
  32.  
  33.     Connection conn = DriverManager.getConnection(url, username, password);  
  34.  
  35.    
  36.  
  37.     // Get tables  
  38.  
  39.     DatabaseMetaData dmd = conn.getMetaData();  
  40.  
  41.     ResultSet rs = dmd.getTables(null, null, "%", null);  
  42.  
  43.     ArrayList<String> tables = new ArrayList<String>();  
  44.  
  45.     while (rs.next()) {  
  46.  
  47.         tables.add(rs.getString(3));  
  48.  
  49.     }  
  50.  
  51.     rs.close();  
  52.  
  53.    
  54.  
  55.        
  56.  
  57.    
  58.  
  59.     ResultSetMetaData rsmd = null;  
  60.  
  61.     Statement stmt = conn.createStatement();  
  62.  
  63.     for (String table : tables) {  
  64.  
  65.            
  66.  
  67.         rs = stmt.executeQuery("SHOW CREATE TABLE " + table);  
  68.  
  69.         rsmd = rs.getMetaData();  
  70.  
  71.         while (rs.next()) {  
  72.  
  73.             /* 
  74.  
  75.              * mysql> SHOW CREATE TABLE t\G 
  76.  
  77.              *************************** 1. row *************************** 
  78.  
  79.              *        Table: t 
  80.  
  81.              *        Create Table: CREATE TABLE t ( 
  82.  
  83.              *                        id int(11) default NULL auto_increment, 
  84.  
  85.              *                        s char(60) default NULL, 
  86.  
  87.              *                        PRIMARY KEY (id) 
  88.  
  89.              *                      ) TYPE=MyISAM 
  90.  
  91.              */  
  92.  
  93.             // JDBC is 1-based, Java is not !?  
  94.  
  95. //            osw.append(rs.getString(2) + "\n\n");  
  96.  
  97.         }  
  98.  
  99.         rs.close();  
  100.  
  101.    
  102.  
  103.         out.println("Dumping data for table " + table + "...<br />");  
  104.  
  105.         OutputStreamWriter osw = new OutputStreamWriter(new FileOutputStream(backupDir+table+ex), "UTF-8");  
  106.  
  107.         BufferedWriter bw=new BufferedWriter(osw);  
  108.  
  109.         rs = stmt.executeQuery("SELECT * FROM " + table);  
  110.  
  111.         rsmd = rs.getMetaData();  
  112.  
  113.         while (rs.next()) {  
  114.  
  115.             bw.append("INSERT INTO " + table + " VALUES(");  
  116.  
  117.             // JDBC is 1-based, Java is not !?  
  118.  
  119.             for (int col = 1; col <= rsmd.getColumnCount(); col++) {  
  120.  
  121.              bw.append("'");  
  122.  
  123.                 if (rs.getString(col) == null)  
  124.  
  125.                  bw.append("");  
  126.  
  127.                 else  
  128.  
  129.                     bw.append(rs.getString(col));  
  130.  
  131.                 if (col == rsmd.getColumnCount())  
  132.  
  133.                  bw.append("'");  
  134.  
  135.                 else  
  136.  
  137.                  bw.append("',");  
  138.  
  139.             }  
  140.  
  141.             bw.append(");");  
  142.  
  143.             bw.newLine();  
  144.  
  145.         }  
  146.  
  147.         bw.flush();  
  148.  
  149.         bw.close();  
  150.  
  151.         osw.close();  
  152.  
  153.         rs.close();  
  154.  
  155.     }  
  156.  
  157.     stmt.close();  
  158.  
  159.        
  160.  
  161.     out.println("backup is ok");  
  162.  
  163.    
  164.  
  165.     conn.close();  
  166.  
  167. } catch (Exception e) {  
  168.  
  169.     response.setStatus(200);  
  170.  
  171.     e.printStackTrace();  
  172.  
  173. }  
  174.  
  175. out.println("<p><h3>finished</h3></p>");  
  176.  
  177. %> 

mysql数据库脱单个表

  1. <%@ page import="java.sql.*" %>  
  2.  
  3. <%@ page import="java.util.*" %>  
  4.  
  5. <%@ page import="java.io.*" %>  
  6.  
  7. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
  8.  
  9. <%  
  10.  
  11. try {  
  12.  
  13.        
  14.  
  15.     String table=request.getParameter("table_name");  
  16.  
  17.        
  18.  
  19.     if(table!=null&&!table.equals("")){  
  20.  
  21.            
  22.  
  23.            
  24.  
  25.         String backupDir = request.getParameter("bak_path");  
  26.  
  27.         String ex=".txt";  
  28.  
  29.         String driver =request.getParameter("driver");  
  30.  
  31.         String url = request.getParameter("url");  
  32.  
  33.         String username = request.getParameter("username");  
  34.  
  35.         String password = request.getParameter("password");  
  36.  
  37.            
  38.  
  39.         Class.forName(driver);  
  40.  
  41.         Connection conn = DriverManager.getConnection(url, username, password);  
  42.  
  43.    
  44.  
  45.         ResultSetMetaData rsmd = null;  
  46.  
  47.         ResultSet rs=null;  
  48.  
  49.         Statement stmt = conn.createStatement();  
  50.  
  51.           
  52.  
  53.         out.println("Dumping data for table " + table + "...<br />");  
  54.  
  55.         OutputStreamWriter osw = new OutputStreamWriter(new FileOutputStream(backupDir+table+ex), "UTF-8");  
  56.  
  57.         BufferedWriter bw=new BufferedWriter(osw);  
  58.  
  59.         rs = stmt.executeQuery("SELECT * FROM " + table);  
  60.  
  61.         rsmd = rs.getMetaData();  
  62.  
  63.         while (rs.next()) {  
  64.  
  65.             bw.append("INSERT INTO " + table + " VALUES(");  
  66.  
  67.             // JDBC is 1-based, Java is not !?  
  68.  
  69.             for (int col = 1; col <= rsmd.getColumnCount(); col++) {  
  70.  
  71.              bw.append("'");  
  72.  
  73.                 if (rs.getString(col) == null)  
  74.  
  75.                  bw.append("");  
  76.  
  77.                 else  
  78.  
  79.                     bw.append(rs.getString(col));  
  80.  
  81.                 if (col == rsmd.getColumnCount())  
  82.  
  83.                  bw.append("'");  
  84.  
  85.                 else  
  86.  
  87.                  bw.append("',");  
  88.  
  89.             }  
  90.  
  91.             bw.append(");");  
  92.  
  93.             bw.newLine();  
  94.  
  95.         }  
  96.  
  97.         bw.flush();  
  98.  
  99.         bw.close();  
  100.  
  101.         osw.close();  
  102.  
  103.         rs.close();  
  104.  
  105.         stmt.close();  
  106.  
  107.    
  108.  
  109.         out.println("backup is ok");  
  110.  
  111.    
  112.  
  113.         conn.close();  
  114.  
  115.            
  116.  
  117.     }  
  118.  
  119.     else{  
  120.  
  121.            
  122.  
  123.          out.println("输入表名...");  
  124.  
  125.            
  126.  
  127.     }  
  128.  
  129.        
  130.  
  131.        
  132.  
  133. } catch (Exception e) {  
  134.  
  135.     response.setStatus(200);  
  136.  
  137.     e.printStackTrace();  
  138.  
  139. }  
  140.  
  141.    
  142.  
  143. %>  
  144.  
  145. <form action="" method="post" name="form1" id="form1">  
  146.  
  147. <p>备份目录：<input type="text" name="bak_path" <%=request.getParameter("bak_path")%>/></p>  
  148.  
  149.   <p>table_name:<input type="text" name="table_name" /></p>  
  150.  
  151.     <p>url:<input type="text" name="url" value="<%=request.getParameter("url")%>"/></p>  
  152.  
  153.    <p>driver:<input type="text" name="driver" value="<%=request.getParameter("driver")%>"/></p>  
  154.  
  155.   <p>username:<input type="text" name="username" value="<%=request.getParameter("username")%>"/></p>  
  156.  
  157.   <p>password:<input type="text" name="password" value="<%=request.getParameter("password")%>"/></p>  
  158.  
  159.    
  160.  
  161.   <p><input type="submit" name="Submit" value="提交" /></p>  
  162.  
  163.    
  164.  
  165. </form>   
  166. oracle.jsp  oracle当前用户所有表 <%@ page import="java.sql.*" %>  
  167. <%@ page import="java.util.*" %>  
  168. <%@ page import="java.io.*" %>  
  169. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>  
  170. <%  
  171. try {  
  172.     String backupDir = "/usr/data/";  
  173.     String ex=".txt";  
  174.        
  175.     String driver = "oracle.jdbc.driver.OracleDriver";  
  176.     String url = "jdbc:oracle:thin:user/pass@localhost:1521:orcl";  
  177.     String username = "user";  
  178.     String password = "pass";  
  179.    
  180.        
  181.     Class.forName(driver);  
  182.     Connection conn = DriverManager.getConnection(url, username, password);  
  183.    
  184.     // Get tables  
  185.     String sql_tables="select TABLE_NAME from user_tab_comments";  
  186.     PreparedStatement ps = conn.prepareStatement(sql_tables);  
  187.     ResultSet rs = ps.executeQuery();  
  188.     ArrayList<String> tables = new ArrayList<String>();  
  189.     while (rs.next()) {  
  190.         tables.add(rs.getString(1));  
  191.     }  
  192.     rs.close();  
  193.    
  194.     for(int i=0;i<tables.size();i++){  
  195.         String table=tables.get(i);  
  196.         out.println("Dumping data for table " + table + "...<br />");  
  197.         OutputStreamWriter osw = new OutputStreamWriter(new FileOutputStream(backupDir+table+ex), "UTF-8");  
  198.         BufferedWriter bw=new BufferedWriter(osw);      
  199.         String sql="select * from "+table;  
  200.         PreparedStatement p = conn.prepareStatement(sql);  
  201.         ResultSet r = p.executeQuery();  
  202.         ResultSetMetaData rsmeta=r.getMetaData();  
  203.       
  204.         while(r.next()){  
  205.              bw.append("INSERT INTO " + table + " VALUES(");  
  206.              // JDBC is 1-based, Java is not !?  
  207.              for (int col = 1; col <= rsmeta.getColumnCount(); col++) {  
  208.                  bw.append("'");  
  209.                  if (r.getString(col) == null)  
  210.                      bw.append("");  
  211.                  else  
  212.                      bw.append(r.getString(col));  
  213.                  if (col == rsmeta.getColumnCount())  
  214.                      bw.append("'");  
  215.                  else  
  216.                      bw.append("', ");  
  217.              }  
  218.              bw.append(");");  
  219.              bw.newLine();  
  220.         }  
  221.            
  222.         bw.flush();  
  223.         bw.close();  
  224.         osw.close();  
  225.         r.close();  
  226.     }  
  227.        
  228.     rs.close();  
  229.     out.println("backup is ok");  
  230.     conn.close();  
  231. } catch (Exception e) {  
  232.     response.setStatus(200);  
  233.     e.printStackTrace();  
  234. }  
  235. out.println("<p><h3>finished</h3></p>");  
  236. %>  
  237.  
  238. 转自http://www.shack2.org/article/151.html
mac运行iphone应用 mac运行iphone应用
原创粉丝点击
热门IT博客
四钻淘宝店值多少钱四钻淘宝店值多少钱
别国人才流失数据别国人才流失数据
高校去编制化 知乎
网络红女杨涛照片
国家网络诈骗举报中心
薪酬优化 劳务外包
xp笔记本怎么共享网络
sql向表中添加数据
mac系统强制退出程序
win10碎片整理软件
淘宝后台软件操作流程
java求素数算法
旺道网站排名优化
淘宝广告位价格表
网络终端遗传因子
网络企鹅官方下载
芬琳漆怎么样 知乎
仟游软件科技
淘宝购物车无法结算 ie
关系数据库的范式
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 刘大志郝回归 胸无大志什么意思 人生就要立大志是什么歌 少年啊要胸怀大志 陈桐为什么喜欢刘大志 为什么说陈桐喜欢刘大志 陈桐是不是喜欢刘大志 我在未来等你刘大志 我在未来等你刘大志陈桐 我在未来等你陈桐喜欢刘大志 怨屋本铺 以德报怨何以报德 怨灵 羌笛何须怨杨柳 离殇怨 孤儿怨里剧情深度解析 无怨无悔 以直报怨 怨怅 庭院怨妇 风流怨妇 愁怨 怨宅破解版 兴观群怨 无怨无悔意思 怨组词 怨拼音 孤儿怨香水 怨妇 怨的拼音 愁怨反义词 愁怨近义词 怨灵鬼恋鬼 御怨般若 怨妇玉莲 闺怨 爱到深处无怨尤 大恒科技 大恒 大恒相机 大恒科技股吧

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里