import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class JdbcDemo {
private final static String DRIVER="com.mysql.jdbc.Driver";
private final static String URL="jdbc:mysql://localhost:3306/userinfo";
private final static String USER="superman";
private final static String PASSWORD="431026";
private final static String NO="1";
public static void main(String args[]){
Connection connection=null;
Statement stm=null;
try {
Class.forName(DRIVER);
connection = (Connection) DriverManager.getConnection(URL,USER,PASSWORD);
if(!connection.isClosed())
{
System.out.println("数据库成功连接了！");
}
stm=(Statement) connection.createStatement();
String sql="select * from userinfo;";
ResultSet rs=stm.executeQuery(sql);
System.out.println("NO |UserName |Password") ;
System.out.println("__________________________________");
while(rs.next()){
System.out.println(rs.getString(1)+" |");
System.out.println(rs.getString(2)+" |");
System.out.println(rs.getString(3)+" |");
System.out.println();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}finally{
try {
connection.close();
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
