java链接mysql数据库方式

package com.data;

import java.sql.*;

public class mydata {

static Connection con;
static Statement statement;
static ResultSet rs;
public static Connection conn() {

String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/mydata?characterEncoding=utf8"; // mydata为要链接的数据库名称
String user = "root";
String password = "123456";
try {
Class.forName(driver);
} catch (Exception e) {
System.out.println("无法加载驱动程序" + driver);
}
try {
con = DriverManager.getConnection(url, user, password);
} catch (SQLException ee) {
System.out.println("数据库连接失败");
}
return con;
}

public static void main(String args[]) {

try {
if (!conn().isClosed()) {
statement = conn().createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from j_new";
rs = statement.executeQuery(sql);

// 获得数据结果集合
ResultSetMetaData rmeta = rs.getMetaData();
// 确定数据集的列数，亦字段数
int numcolumns = rmeta.getColumnCount();
// 输出每一个数据值
System.out.println(numcolumns + "条");
System.out.print("id");
System.out.print("|");
System.out.print("num");
System.out.println("<br>");
while (rs.next()) {
System.out.print(rs.getString(1) + " ");
System.out.print("|");
System.out.print(rs.getString(2));
System.out.print("|");
System.out.print(rs.getString(3));
System.out.print(rs.getString(4));
System.out.print(rs.getString(5));
System.out.println("<br>");
}
rs.close();
statement.close();
}

conn().close();
} catch (SQLException ee) {
System.out.println("数据库连接失败");
}
}

public String name() {
return "字符串";
}

}