import java.sql.*;
public class MySQLConnection {
public static void main(String[] args){
System.out.println("MySQL connection test");
Connection con = null;
Statement stat = null;
String urlstr = "jdbc:mysql://localhost:3306/tmysqldb";
String user = "root";
String password = "123456";
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(urlstr, user, password);
stat = con.createStatement();
stat.executeUpdate("insert into new_table(id) values(1)");
ResultSet rs = stat.executeQuery("select * from new_table");
while (rs.next())
System.out.println("id:"+rs.getString("id"));
rs.close();
System.out.println("Test ends");
}catch(Exception e){
System.out.println(e.getMessage());
}
}
}
public class MySQLConnection {
public static void main(String[] args){
System.out.println("MySQL connection test");
Connection con = null;
Statement stat = null;
String urlstr = "jdbc:mysql://localhost:3306/tmysqldb";
String user = "root";
String password = "123456";
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(urlstr, user, password);
stat = con.createStatement();
stat.executeUpdate("insert into new_table(id) values(1)");
ResultSet rs = stat.executeQuery("select * from new_table");
while (rs.next())
System.out.println("id:"+rs.getString("id"));
rs.close();
System.out.println("Test ends");
}catch(Exception e){
System.out.println(e.getMessage());
}
}
}