Java代碼-------

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class JDBCUtil {

private static final String URL="jdbc:mysql://127.0.0.1:3306/imooc";

private static final String USER="root";

private static final String PASSWORD="123456";

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

//1.加載驅(qū)動程序

Class.forName("com.mysql.jdbc.Driver");

//2.獲得數(shù)據(jù)庫的連接

Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);

//3.通過數(shù)據(jù)庫連接操作數(shù)據(jù)庫，實(shí)現(xiàn)增刪查改

Statement stmt=conn.createStatement();

//查詢imooc_goddess里面的user_name,age

ResultSet rs=stmt.executeQuery("select user_name,age form imooc_goddess");

while(rs.next()){//為真，則有數(shù)據(jù)

System.out.println(rs.getString("user_name")+","+rs.getInt("age"));

}

}

}

數(shù)據(jù)表：

CREATE TABLE `db` (

? `id` int(11) NOT NULL AUTO_INCREMENT,

? `user_name` varchar(30) NOT NULL,

? `sex` int(11) DEFAULT NULL,

? `age` int(11) DEFAULT NULL,

? `birthday` date DEFAULT NULL,

? `email` varchar(30) DEFAULT NULL,

? `mobile` varchar(11) DEFAULT NULL,

? `create_user` varchar(30) DEFAULT NULL,

? `create_date` date DEFAULT NULL,

? `update_user` varchar(30) DEFAULT NULL,

? `update_date` date DEFAULT NULL,

? `isdel` int(11) DEFAULT NULL,

? PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

SET character_set_client="utf8";

SET character_set_connection="utf8";

SET character_set_results="utf8";

自己手動添加了一條信息