mysql로 JDBC와 db연결

1단계_드라이버 불러오기

Class.forName("cohttp://m.mysql.jdbc.Driver");
 

2단계_데이터베이스 연결

String dbUrl="jdbc:mysql://localhost:3306/jspdb5";

String dbUser="jspid";

String dbPass="jsppass";

Connection con=DriverManager.getConnection(dbUrl, dbUser, dbPass);

/*
다른분꺼
Class.forName("cohttp://m.mysql.jdbc.Driver");
String db_address = "jdbc:mysql://localhost:3306/pratice_board";
String db_username = "root";
String db_pwd = "root";

Connection connection = DriverManager.getConnection(db_address, db_username, db_pwd);

String insertQuery = "SELECT * FROM pratice_board.post order by num desc";
PreparedStatement psmt = connection.prepareStatement(insertQuery);
ResultSet result = psmt.executeQuery();%>
*/