package find;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2004</p> * <p>Company: </p> * @author not attributable * @version 1.0 */import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.Statement;import java.sql.ResultSet;public class SqlConnection {  private Connection conn;  public SqlConnection() {  }  public Connection getSQLConnection(){        try{                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();                String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=finance";                //mydb為數據庫                String user="sa";                String password="sa";                conn= DriverManager.getConnection(url,user,password);        }catch(Exception e){                e.printStackTrace();        }        return this.conn;  }  public static void main(String[] args) throws Exception {    SqlConnection sqlConnection1 = new SqlConnection();    ResultSet rs = sqlConnection1.getSQLConnection().createStatement().executeQuery("SELECT * FROM goodsTable");    rs.next();    System.out.println(rs.getString("category"));    //System.out.println(rs.getString(1));    //System.out.println(rs.getInt(2));  }}