java连接mysql数据库实例:
public static void main(String[] args) {
Connection con=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/app1?characterEncoding=utf-8";
String user="root";
String password="root";
con=DriverManager.getConnection(url, user, password);
st=con.createStatement();
String sql="select * from t_user";
rs=st.executeQuery(sql);
while(rs.next()) {
System.out.println("|"
+rs.getInt("id")+"\t|"
+rs.getString("username")+"\t|"
+rs.getString("password")+"\t|"
+rs.getString("ident")+"\t|"
+rs.getString("telephone")+"\t|"
+rs.getString("address")+"\t|"
);
}
System.out.println("ok");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
if(rs!=null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(st!=null)
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(con!=null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}