一、eclipse创建一个普通的java工程命名为mdt
package www.zjptcc.wxw.matjdbctest;
import java.sql.*;
public class TestMysql {
static String url = "jdbc:mysql://localhost:3306/mymotif?useSSL=false&user=mymotif&password=wxwpxh";
public void showatable(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM COURSE");
int colcount=st.getResultSet().getMetaData().getColumnCount();
while (rs.next()) {
for(int col=1;col<=colcount;col++){