jdbc其实
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mainTest {
public static void main(String[] args) {
// com.mysql.jdbc.Driver d;
try {
// 加载MySql的驱动类
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("加载驱动失败!");
e.printStackTrace();
}
String url = "jdbc:mysql://localhost:3306/test";
String username = "root";
String password = "root";
try {
String sql = "select * from tb_cat";
Connection con = DriverManager.getConnection(url, username, password);
Statement stmt = con.createStatement();
// PreparedStatement pstmt = con.prepareStatement(sql) ;
ResultSet rs = stmt.executeQuery(sql);
// int rows = stmt.executeUpdate("INSERT INTO ...") ;
// boolean flag = stmt.execute(String sql) ;
while (rs.next()) {
String name = rs.getString("cat_name");
String pass = rs.getString(1);
System.out.println(name);
System.out.println(pass);
}
} catch (SQLException se) {
System.out.println("数据库连接失败!");
se.printStackTrace();
}
}
}
太困了 感觉不到自己意识