Java连接mysql原始方法

最新推荐文章于 2022-07-21 13:54:52 发布

yankefei

最新推荐文章于 2022-07-21 13:54:52 发布

阅读量222

点赞数

分类专栏：应用示例文章标签： mysql java preparedStatement 查询

本文链接：https://blog.csdn.net/yankefei/article/details/84826527

版权

应用示例专栏收录该内容

11 篇文章 0 订阅

订阅专栏



	private static String mysqlUrl = "jdbc:mysql://192.168.1.1:3306/test?useUnicode=true&characterEncoding=utf-8";

	public static void main(String[] args) {
		Connection conn = null;
		PreparedStatement preStatement = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("成功加载MySql驱动！");

			conn = DriverManager.getConnection(mysqlUrl, "user", "password");
			String sql = "";
			preStatement = conn.prepareStatement(sql);

			rs = preStatement.executeQuery();
			while (rs.next()) {
				//TODO
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)rs.close();
				if(preStatement!=null)preStatement.close();
				if(conn!=null)conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}