Java连接MySql数据库简单实例

一、代码

import java.sql.*;

public class MySqlConnector {
    private static final String ip = "10.123.123.123";

    private static final int port = 3306;
    private static final String username = "myname";
    private static final String password = "mypass";
    private static final String dbname = "mydbname";
    private static final String sql = "select * from mytable limit 10";

    public static void main(String[] args) {
        Connection con;
        //jdbc驱动
        String driver="com.mysql.jdbc.Driver";
        String url="jdbc:mysql://"+ip+":"+port+"/"+dbname;
        try {
            //注册JDBC驱动程序
            Class.forName(driver);
            //建立连接
            con = DriverManager.getConnection(url, username, password);
            if (!con.isClosed()) {

                System.out.println("数据库连接成功");
                PreparedStatement ps = con.prepareStatement(sql);
                ResultSet resultSet = ps.executeQuery();
                while(resultSet.next()){
                    System.out.println(resultSet.getString(1));
                }
                System.out.println("success");

            }
            con.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.out.println("数据库驱动没有安装");
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println("数据库连接失败");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Exception 报错");
        }
    }


}

二、需要的jar包

mysql-connector-java-5.1.35.jar

三、使用方法

1.修改代码里的mysql相关ip、账号、密码等，修改要测试的sql语句
2.把这个打成jar包，部署到服务器上执行，就可以连接到mysql数据库、执行编写的sql语句了。