createStatement用法

2019独角兽企业重金招聘Python工程师标准>>>

package com.iflytek.main.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JdbcDemo {

public static void main(String[] args)throws Exception {

try {

// 加载驱动类

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

// 建立连接

String url = "jdbc:sqlserver://localhost:1433; databaseName=Northwind";

// 用户名

String user = "sa";

// 密码

String password = "593850582";

// 连接接口

Connection conn = DriverManager.getConnection(url,

user, password);

// 创建SQL语句的对象

Statement st = conn.createStatement();

// 创建SQL查询语句

String query = "select shipsName,unitprice,Quantity,SumPrice,orderdate,SupplierName from Orders,order Details";

// 执行SQL语句，返回结果集

ResultSet rs = st.executeQuery(query);

// 遍历结果集

while (rs.next()) {

System.out.println(rs.getInt(query));

}

System.out.println("数 据 查 询 完 成");

rs.close();

st.close();

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

转载于:https://my.oschina.net/u/656507/blog/70546