mysql的JDBC连接
mysqlJDBC连接：
import java.sql.*;
public class TestMysqlConnection {
public static void main(String args[]) {
Connection conn =
null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName("com.mysql.jdbc.Driver");
conn =
DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=abc123");
stmt
= conn.createStatement();
rs = stmt.executeQuery("select * from
dept");
while (rs.next())
{
System.out.println(rs.getString("deptno"));
}
} catch
(ClassNotFoundException e) {
e.printStackTrace();
} catch
(SQLException ex) {
System.out.println("SQLException: " +
ex.getMessage());
System.out.println("SQLState: " +
ex.getSQLState());
System.out.println("VendorError: " +
ex.getErrorCode());
} finally {
try {
if (rs != null)
{
rs.close();
rs = null;
}
if (stmt != null)
{
stmt.close();
stmt = null;
}
if (conn != null)
{
conn.close();
conn = null;
}
} catch
(SQLException e)
{
e.printStackTrace();
}
}
}
}
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
