JDBC简介 (Java Database Connectivity,简称JDBC)
简单的说就是可以直接通过java语言,去操作数据库。
入门代码实现:
首先导入mysql.jar包 或者oracle.jar包
代码
package com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBC {
public static void main(String[] args) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs =null;
try {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获得连接对象
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/wsw", "root", "root");
//3.获得语句对象(执行Sql语句)
String sql="select *from user where id=?";
ps = conn.prepareStatement(sql);
ps.setInt(1, 1);
//4.执行Sql语句并接受结果集
rs = ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getInt("id")+" "+rs.getString("username"));
}
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
ps.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
运行结果