java进阶（11-1）：配置数据源：JDBC的ODBC和漏洞弥补（两种固定格式）

来源：互联网发布：有赞微商城源码编辑：程序博客网时间：2024/06/06 21:07

import java.sql.*;public class TTTest{     public static void main(String[]args){     Connection ct=null;     Statement sm=null;     try {                                      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");              //相当于加载了一个驱动程序（若想让计算机访问硬件，则要给计算机加驱动程序）             ct=DriverManager.getConnection("jdbc:odbc:sql sever Test");               //是windows进入，如果是密码的话后加："用户名","密码"             sm=ct.createStatement();             /*              * 上面三个用来连接数据库              * */             //1.查找             ResultSet rs=sm.executeQuery("select*from bumen");             while(rs.next())             //rs.next()：下一条记录，意为只要有下一条记录就继续执行，如果没有就退出 while语句             {             int bianhao=rs.getInt(1);             String mingcheng=rs.getString(2);             String didian=rs.getString(3);             System.out.println(bianhao+" "+mingcheng+" "+didian);             }             //2.添加              int i=sm.executeUpdate("insert into bumen values('12','aa','aaaa')");             if(i==0)                {             System.out.println("添 加成功！");                }else                   {                System.out.println("添加失败！");                   }             //3.删除             int j=sm.executeUpdate("delete from bumen where bianhao='8'");             if(j==0)                {             System.out.println("添 加成功！");                }else                   {                System.out.println("添加失败！");                   }             //4.修改             int k=sm.executeUpdate("update bumen set didian='忠义堂'");             if(k==0)                {             System.out.println("添 加成功！");                }else                   {                System.out.println("添加失败！");                   }                  }catch(Exception e){}     finally     {     try{    if(sm!=null)       {    sm.close();       }    if(ct!=null)       {    ct.close();       }        }catch(Exception e2){}     }     } }

import java.sql.*;public class TTest1 {     public static void main(String[]args){     PreparedStatement ps=null;//用来弥补漏洞     Connection ct=null;      ResultSet rs=null;     try {                                      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");                          ct=DriverManager.getConnection("jdbc:odbc:sql sever Test");                                    //1.插入         /* ps=ct.prepareStatement("insert into bumen values(?,?,?)");             ps.setInt(1, 7);    ps.setString(2,"侦察");             ps.setString(3, "山外");         */                //1,2,3是第几个问号的意思             //2.查询             ps=ct.prepareStatement("select*from bumen where bianhao=? or didian=?");             ps.setInt(1,6);  ps.setString(2,"后山");             rs=ps.executeQuery();             while(rs.next())                          {             int bianhao=rs.getInt(1);             String mingcheng=rs.getString(2);             String didian=rs.getString(3);             System.out.println(bianhao+" "+mingcheng+" "+didian);             }     }catch(Exception e){}     finally     {     try{    if(rs!=null)       {    rs.close();       }    if(ps!=null)       {    ps.close();       }        }catch(Exception e2){}     }     } }

import java.sql.*;  public class TTest1 {      public static void main(String[]args){           PreparedStatement ps=null;//用来弥补漏洞            Connection ct=null;            ResultSet rs=null;           try {                                            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");                                           ct=DriverManager.getConnection("jdbc:odbc:sql sever Test");                         ps=ct.prepareStatement("create database abcd");               ps=ct.prepareStatement("create table aabbcc(aa int,bb nvarchar(2))");             ps=ct.prepareStatement("backup database abcd to disk='e:/abcd.bak'");             //备份文件             ps=ct.prepareStatement("drop table aabbcc");             ps=ct.prepareStatement("restore database abcd from disk='e:abcd.bak'");             //从备份文件中取出             ps.execute();             System.out.println("执行完毕！");         }catch(Exception e){}           finally           {               try{                  if(rs!=null)                     {                      rs.close();                     }                  if(ps!=null)                     {                      ps.close();                     }                  }catch(Exception e2){}           }       }   }

0 0