Myeclipse连接mysql代码

最新推荐文章于 2025-03-16 23:45:00 发布

iteye_10711

最新推荐文章于 2025-03-16 23:45:00 发布

阅读量115

点赞数

CC 4.0 BY-SA版权

文章标签： MySQL Myeclipse SQL JDBC

本文链接：https://blog.youkuaiyun.com/iteye_10711/article/details/81997790

本文展示了一个使用Java连接MySQL数据库并查询学生的示例代码。该示例包括加载驱动、建立连接、执行SQL查询及处理结果集等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import java.sql.*;
public class connect {
public static void main(String[] args){
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/scutcs";
String user = "root";
String password = "123456";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select * from student";
ResultSet rs = statement.executeQuery(sql);
String name = null;
while(rs.next())
{
name = rs.getString("name");
name = new String(name.getBytes("ISO-8859-1"),"GB2312");
System.out.println(rs.getString("id") + "\t" + name); }
rs.close();
conn.close();
} catch(ClassNotFoundException e)
{ System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
}catch(SQLException e)
{ e.printStackTrace();
} catch(Exception e)
{ e.printStackTrace(); }
}
}