如何在eclipse中设置mysql

最新推荐文章于 2024-09-12 17:29:00 发布

清箫

最新推荐文章于 2024-09-12 17:29:00 发布

阅读量2.7k

点赞数

文章标签： eclipse string mysql exception table insert

本文链接：https://blog.csdn.net/woxueliuyun/article/details/1887626

版权

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());
  }
}
}