hello world
import java.sql.*;
public class HelloWorldApp {
public static void main(String[] args){
System.out.println("hello");
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/mysql";
String user = "root";
String password = "123456";//数据库用户的密码
try{
try{
Class.forName(driver);
}catch(ClassNotFoundException e){
e.printStackTrace();
}
Connection conn = DriverManager.getConnection(url,user,password);
if(!conn.isClosed()){
System.out.println("success!");
}
Statement statement = conn.createStatement();
String sql = "select * from user";
ResultSet rs = statement.executeQuery(sql);
String name = null;
while(rs.next()){
name = rs.getString("User");
System.out.println(name);
}
rs.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
执行成功,会打印出Mysql中的mysql数据库的user table的User列表。