《Java程序设计》第二次作业：MySQL数据库及Java操作MySQL数据库

最新推荐文章于 2024-10-25 09:55:36 发布

原创最新推荐文章于 2024-10-25 09:55:36 发布 · 661 阅读

CC 4.0 BY-SA版权

本文提供了一个使用Java通过JDBC连接MySQL数据库的示例代码，演示了如何加载驱动、建立连接、执行查询并获取结果集的过程。

import java.sql.*;


public class JDBCTest {


<span style="white-space:pre">	</span>public static void main(String[] args){


<span style="white-space:pre">		</span>// 驱动程序名
<span style="white-space:pre">		</span>String driver = "com.mysql.jdbc.Driver";


<span style="white-space:pre">		</span>// URL指向要访问的数据库名scutcs
<span style="white-space:pre">		</span>String url = "jdbc:mysql://127.0.0.1:3306/student";


<span style="white-space:pre">		</span>// MySQL配置时的用户名
<span style="white-space:pre">		</span>String user = "root"; 


<span style="white-space:pre">		</span>// MySQL配置时的密码
<span style="white-space:pre">		</span>String password = "1681691689";


<span style="white-space:pre">		</span>try { 
<span style="white-space:pre">			</span>// 加载驱动程序
<span style="white-space:pre">			</span>Class.forName(driver);


<span style="white-space:pre">			</span>// 连续数据库
<span style="white-space:pre">			</span>Connection conn = DriverManager.getConnection(url, user, password);


<span style="white-space:pre">			</span>if(!conn.isClosed()) 
<span style="white-space:pre">				</span>System.out.println("Succeeded connecting to the Database!");


<span style="white-space:pre">			</span>// statement用来执行SQL语句
<span style="white-space:pre">			</span>Statement stmt = conn.createStatement();


<span style="white-space:pre">			</span>// 要执行的SQL语句
<span style="white-space:pre">			</span>ResultSet rs =stmt.executeQuery( "select * from class1");


<span style="white-space:pre">			</span>while(rs.next()) {


<span style="white-space:pre">				</span>System.out.println(rs.getString("id") + "\t" + rs.getString("name") + "\t" + rs.getString("sex"));
<span style="white-space:pre">			</span>}


<span style="white-space:pre">			</span>rs.close();
<span style="white-space:pre">			</span>stmt.close();


<span style="white-space:pre">		</span>} catch(ClassNotFoundException e) {




<span style="white-space:pre">			</span>System.out.println("Sorry,can`t find the Driver!"); 
<span style="white-space:pre">			</span>e.printStackTrace();




<span style="white-space:pre">		</span>} catch(SQLException e) {




<span style="white-space:pre">			</span>e.printStackTrace();




<span style="white-space:pre">		</span>} catch(Exception e) {




<span style="white-space:pre">			</span>e.printStackTrace();




<span style="white-space:pre">		</span>} 
<span style="white-space:pre">	</span>} 
}
<img src="https://img-blog.csdn.net/20150513145244667?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMzkzMDMwMw==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="" />