package com.dxm;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Driver;
import com.sun.jndi.url.corbaname.corbanameURLContextFactory;
//
//1. 注册驱动.
//2. 获得连接.
//3. 获得语句执行对象
//4. 执行sql语句
//5. 处理结果
//6. 释放资源.
public class JDBCDemo {
private static Statement createStatement;
public static void main(String[] args) throws SQLException, ClassNotFoundException {
//注册驱动
//DriverManager.registerDriver(new Driver());//源码体现注册两次驱动
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/mybase";
String user="root";
String password="1234";
//2. 获得连接.
java.sql.Connection connection = DriverManager.getConnection(url, user, password);
System.out.println(connection);
//3. 获得语句执行对象
Statement statement = connection.createStatement();
System.out.println(statement);
//5. 处理结果
// int row = statement.executeUpdate("INSERT INTO sort(sname,sprice,sdesc) VALUES('汽车用品',50000,'疯狂涨价')");
// System.out.println(row);
String selectUrl = "select * from sort";
ResultSet resultSet = statement.executeQuery(selectUrl);
while (resultSet.next()) {
System.out.println(resultSet.getInt("sid")+" "+
resultSet.getString("sname")+" "+
resultSet.getDouble("sprice")+" "+
resultSet.getString("sdesc"));
}
//6. 释放资源.
resultSet.close();
statement.close();
connection.close();
}
}