java mysql

关注

原创最新推荐文章于 2026-02-27 11:48:38 发布 144 阅读 AI 写同款· GEO 优化 ›

.NET 4.0下HttpWebRequest请求HTTPS报错？试试这个注册表修改方案本文深入解析.NET 4.0下HttpWebRequest请求HTTPS报错问题，提供注册表修改方案以解决'基础连接已经关闭'错误。通过调整SchUseStrongCrypto注册表项，强制使用TLS 1.2等现代加密协议，确保安全连接。适用于企业环境部署和长期维护建议。阅读详情

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class helloworld {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		
		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydata", "root", "");
		System.out.println(con);
		
		String sql = "select * from student";
		PreparedStatement pst = con.prepareStatement(sql);
		
		ResultSet rs = pst.executeQuery();
		while(rs.next())
		{
			int id = rs.getInt("id");//rs.getInt(1)
			String name = rs.getString("name");//rs.getString(2)
			int age = rs.getInt("age");//rs,getInt(3)
			System.out.printf("%d %s %d\n", id, name, age);
		}
		rs.close();
		pst.close();
		con.close();
	}

}

收录于