Myeclipse连接Mysql数据库

Web工程下的test.java文件

需要导入三个jar文件

test.java

1. importjava.sql.*;
2. publicclasstest{
3. publicstaticvoidmain(String[]args){
4. //TODOAuto-generatedmethodstub
5. Stringdriver="com.mysql.jdbc.Driver";
6. Stringurl="jdbc:mysql://127.0.0.1:3306/world";
7. Stringuser="root";
8. Stringpassword="root";
9. try{
10. Class.forName(driver);
11. Connectionconn=DriverManager.getConnection(url,user,password);
12. if(!conn.isClosed())
13. System.out.println("SucceededconnectingtotheDatabase!");
14. Statementstatement=conn.createStatement();
15. Stringsql="select*fromcity";
16. ResultSetrs=statement.executeQuery(sql);
17. Stringname=null;
18. while(rs.next())
19. {
20. name=rs.getString("name");
21. name=newString(name.getBytes("ISO-8859-1"),"GB2312");
22. System.out.println(rs.getString("id")+"\t"+name);}
23. rs.close();
24. conn.close();
25. }
26. catch(ClassNotFoundExceptione)
27. {
28. System.out.println("Sorry,can`tfindtheDriver!");
29. e.printStackTrace();
30. }
31. catch(SQLExceptione)
32. {
33. e.printStackTrace();
34. }
35. catch(Exceptione)
36. {
37. e.printStackTrace();
38. }
39. }
41. }

本文出自 “阿凡达” 博客，请务必保留此出处http://shamrock.blog.51cto.com/2079212/815862