package JDBC;
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ConnToMySql {
public static void main(String[] args) throws Exception{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mysql", "root", "1");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from teacher");
while ( rs.next()) {
System.out.println(rs.getInt(1) + "\t" + rs.getString(2)+ "\t");
}
}
}