JDBC基本概念

public static void main(String[] args) throws ClassNotFoundException, SQLException {
//01加载驱动
Class.forName(“com.mysql.cj.jdbc.Driver”);
//02建立连接
//Connection conn=DriverManager.getConnection(“jdbc:mysql://:3305”,“root”,"");
Connection conn=DriverManager.getConnection(“jdbc:mysql://:3305/db?user=root”);
System.out.println(conn.getMetaData().getDatabaseProductVersion());
//Connection conn= DriverManager.getConnection(“jdbc:mysql://localhost:3305”,“root”,"");
//Connection conn=DriverManager.getConnection(“jdbc:mysql://:3305/mysql”,“root”,"");
//Connection conn=DriverManager.getConnection(“jdbc:mysql://:3305/db?useUnicode=true&charactorEncoding=utf8&useSSL=false”,“root”,"");
//System.out.println(conn);
//03执行语句
Statement st=conn.createStatement();
//st.execute(“create database db default charset utf8”);
//st.execute(“create table stu(id int unsigned auto_increment,name varchar(30),primary key(id))”);
//int rows=st.executeUpdate(“insert into stu values(null,‘小红’),(null,‘小明’),(null,‘李华’)”);
//System.out.println(rows);

ResultSet rs=st.executeQuery(“select * from stu order by id desc”);
if(rs.isBeforeFirst()){
while(rs.next()){
System.out.printf(“id:%d,name:%s%n”,rs.getInt(1),rs.getString(“name”));
}
}else{
System.out.println(“没有数据”);
}
//04 关闭连接
st.close();
rs.close();
conn.close();
}