Java SQL 示例-优快云博客

本文提供了一个使用 Java 进行 SQL 数据库操作的示例代码，包括连接数据库、执行查询和更新等基本功能。通过示例展示了如何使用 JDBC 驱动进行数据库交互。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import java.sql.*;
public class DbTest
{   private Connection conn=null;
    private ResultSet rs=null;
    private Statement stm=null;
public DbTest(){}
public void openOdbcDb(String dsnn,String user,String password)
{try{
String url="jdbc:odbc:"+dsnn;
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         conn=DriverManager.getConnection(url,user,password);

}catch(Exception e){System.err.println("aq.executeQuery: " + e.getMessage());}
        }

public void openJdbcDb(String dsnn)
{openJdbcDb(dsnn,"sa","sa");
        }
public void openJdbcDb(String dsnn,String user,String password)
{try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+dsnn;
        conn= DriverManager.getConnection(url,user,password);
}catch(Exception e){System.err.println("aq.executeQuery: " + e.getMessage());}
        }
public ResultSet executeQuery(String sql)
{rs=null;
     try{
stm=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
     rs=stm.executeQuery(sql);

}catch(Exception e){System.err.println("aq.executeQuery: " + e.getMessage());}
return rs;
}

public void executeUpdate(String sql)
{ try{
stm=conn.createStatement();
      stm.executeUpdate(sql);
}catch(Exception e){System.err.println("aq.executeQuery: " + e.getMessage());}
     }
    public void closeDb()
{if(rs!=null)
{try{rs.close();
       rs=null;
        }catch(Exception e){}
       }
   if(stm!=null)
   {try{stm.close();
   stm=null;
   }catch(Exception e){}
   }
   if(conn!=null)
   {try{
   conn.close();
   conn=null;
   }
   catch(Exception e){}
   }
    }
public static void main(String [] args)throws Exception
{DbTest test=new DbTest();
     test.testDb("select * from liuyan_tb join fuzhuang_tb on liuyan_tb.ID=fuzhuang_tb.ID");

     }
public void testDb(String sql)throws Exception
{ ResultSet rst=null;
openJdbcDb("clother");
System.out.println(sql);
      rst=executeQuery(sql);
for(int j=1; j<=rst.getMetaData().getColumnCount(); j++)
{System.out.print(rst.getMetaData().getColumnName(j)+"   ");}
   System.out.println("");
     while (rst.next())
     { for(int j=1; j<=rst.getMetaData().getColumnCount(); j++)
     {
       System.out.print( rst.getObject(j)+"   ");
}
System.out.println("");
     }

closeDb();
}
}

JDBC1