实施步骤:
准备前,Navicat新建一个数据库student,新建表std,插入数据
1、新建java project,命名JDBC
2、导入mysql-connector-java-5.0.5-bin.jar进入referenced libraries
3、新建class,命名JDBCTest
代码如下:
import java.sql.*;
public class JDBCTest {
public static void main(String[] args){
String driver = "com.mysql.jdbc.Driver"; //驱动程序名,要和mysql-connector-java-5.0.5-bin.jary一致
String url = "jdbc:MySQL://127.0.0.1:3306/student"; //URL指向要访问的数据库名scutcs
String user = "root";
String password = "123456";
try {
Class.forName(driver); //加载驱动程序
Connection conn = DriverManager.getConnection(url, user, password); //连续MySQL数据库
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select * from std";
ResultSet rs = statement.executeQuery(sql); //获取rs结果集
System.out.println(" 学号" + "\t" + " 姓名");
System.out.println("-----------------");
String name = null;
while(rs.next()) {
name = rs.getString("sname");
name = new String(name.getBytes("ISO-8859-1"),"GB2312");
System.out.println(rs.getString("sno") + "\t" + name);
}
rs.close();
conn.close();
} catch(ClassNotFoundException e) {
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
} catch(SQLException e) {
e.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
}
}
}
Succeeded connecting to the Database!
-----------------
执行结果如下所示:
-----------------
学号 姓名
-----------------
112 liyawen
12 12jhihi
15 45df