java调用数据库

方法1：

package com.unit.wjh;

import java.sql.ResultSetMetaData;
import java.sql.CallableStatement; 
import java.util.HashMap; 
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.sql.Statement;
import java.sql.Types;   
  
public class test {  
  public test() {  
  }  
  public static void main(String[] args ){  
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";  
String strUrl="jdbc:sqlserver://localhost:1433;DatabaseName=Leading";    
String userName="sa1";   
String userPwd="123456";


// 保存结果集
ResultSet rs = null;
// 创建执行sql的操作状态
Statement sm;
try  { 
    Class.forName(driverName);   
    System.out.println("加载驱动成功！");  
    } catch(Exception e)   {   
    e.printStackTrace();    
    System.out.println("加载驱动失败！");  
    } try{      
Connection dbConn=DriverManager.getConnection(strUrl,userName,userPwd);    
System.out.println("连接数据库成功！"); 
String sql = "select GoodsId,Operate,StoreId,RelationId from GoodsStoreDetail with (nolock) where GoodsId in (12345)";
System.out.println(sql);
sm = dbConn.createStatement();
//执行查询
rs = sm.executeQuery(sql);


//执行更新，删除，插入操作
//int rs1 = sm.executeUpdate(sql);

if (rs != null && rs.next()){
ResultSetMetaData rsmd = rs.getMetaData();
HashMap<String, String> map = new HashMap<String,String>();
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
map.put(rsmd.getColumnName(i),rs.getString(i));
}
System.out.println(map.toString());
//return true;
}
sm.close();
rs.close();
} catch (SQLException e) {
}
  }

}  

方法2：

public String goodssearch(){
    String result=null;
        try  { 
        Class.forName(driverName);   
        System.out.println("加载驱动成功！");  
        } catch(Exception e)   {   
        e.printStackTrace();    
        System.out.println("加载驱动失败！");  
        } try{    
        Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);    
        System.out.println("连接数据库成功！"); 
        Statement stmt = dbConn.createStatement();
               //ResultSet executeQuery(String sqlString)：执行查询数据库的SQL语句   ，返回一个结果集（ResultSet）对象。
               ResultSet rs = stmt.executeQuery("select ID,Unit,Package,BranchId,IsPublic from Goods with (nolock) where ID in ("+ID+")");
               //ResultSet rs1 = stmt.executeQuery("select operate from GoodsStoreDetail with (nolock) where GoodsId in (252955)");
               while(rs.next()){//如果对象中有数据，就会循环打印出来
                   System.out.println("商品信息\n----------------------------");
                   GoodsUnit=rs.getString("Unit");
                   result="商品编号----"+rs.getInt("ID")+"\n商品Unit----"+rs.getString("Unit")+"\n商品Package----"+rs.getString("Package")+"\nBranchid----"+rs.getInt("BranchId")+"\n公有----"+rs.getInt("IsPublic");
                   //System.out.println(rs.getString("operate"));
               }


        } catch(Exception e)   {    
        e.printStackTrace();    
        //System.out.print("SQL Server异常失败！");  
        }  
        return result;
       
               }