jdbc(java database Connectivity)
- 在不用框架的前提下,对比nodejs、python;java连接数据库比较麻烦。
- jdbc的位置:
遇到的问题
代码
import java.sql.*;
public class Mysql {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String driver = "jdbc:mysql://127.0.0.1:3306/test";
Connection con = DriverManager.getConnection(driver, "test", "root");
System.out.println(con);
Statement stmt = con.createStatement();
ResultSet res = stmt.executeQuery("select * from nsddd_user");
System.out.println("id" + " " + "username" + " " + "password");
while (res.next()){
int id = res.getInt("id");
String username = res.getString("username");
String password = res.getString(3);
System.out.println(id + " " + username + " " + password);
}
con.close();
}catch (Exception e){
System.out.println(e);
}
}
}