注册驱动程序,建立连接,执行SQL语句,得到结果。
class.forName("com.MySQL.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1:3306/crm";
String usrname = "root";
String password = "";
Connection con = DriverManager.getConnection(url,username,password);
Statement stms = con.createStatement();
ResultSet rst = stms.excuteQuery("select * from tablename");