SQL Server连接与关闭

SQLServer的基本应用

fun main() {
    //val df = SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS")
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    val connection = DriverManager.getConnection(
        "jdbc:sqlserver://47.96.113.52:1433;databaseName=AIS20180930224051;",
        "sa", "ypbwkfyjhyhgzj_sql2018"
    )
    val stt="SCBL00000799"
    var str="select TOP 1 * from  t_material_receiving where 单据编号 = '" + stt+"'"
    val ps = connection.prepareStatement(str)
    val rs = ps.executeQuery()
    while (rs.next()) {
        println(rs.getString("单据"))
        println(rs.getString("单据编号"))
    }
    //一定记得关闭
    rs.close()
    ps.close()
    connection.close()
}