sqlconnection.java

来自「用于按照xml文件配置直接生成SQL脚本文件」· Java 代码 · 共 47 行

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));
  }

}