jdbc
时间:2019-05-12 14:14:13
收藏:0
阅读:234
一、加载驱动程序:Class.forName(driverClass)
-
Mysql:Class.forName("com.mysql.jdbc.Driver")
-
Oracle:Class.forName("oracle.jdbc.driver.OracleDriver")
二、连接数据库:
-
Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/database","username","password");
三、创建Statement对象:
-
Statement stmt=conn.createStatement();
四、查询
-
ResulSet rs=stmt.executeQuery("sql");
-
while(rs.next()){System.out.println(rs.getString("columnLabel"));
-
}
原文:https://www.cnblogs.com/ruowei/p/10852024.html
评论(0)