方法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;
}