如何在eclipse中设置mysql

来源:互联网 发布:育知同创科技有限公司 编辑:程序博客网 时间:2024/06/06 11:46
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());
  }
 }
}
原创粉丝点击