package sc.itcsat.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.naming.spi.DirStateFactory.Result;
import com.mysql.jdbc.Driver;
import com.mysql.jdbc.Statement;
public class JDBCDemo {
/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
*/
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/firstmysql";//
String username = "root";//
String password = "root";//
Connection con = DriverManager.getConnection(url, username, password);//
/*Statement stat = (Statement) con.createStatement();
int rows = stat.executeUpdate("INSERT INTO sort(sname,sprice,sdesc) VALUES('汽车',342000,'疯狂涨价')");
//System.out.println(rows);
*/
Statement stat = (Statement) con.createStatement();//
String sql = "SELECT * FROM sort";
ResultSet rs = stat.executeQuery(sql);
while(rs.next()) {
System.out.println(rs.getInt("sid") + " " + rs.getString("sname") + " "
+ rs.getDouble("sprice") + " " + rs.getString("sdesc"));
}
rs.close();
stat.close();
con.close();
}
}