1、在MyEclipse中点击window,选择open perspective,选择MyEclipse database explorer;
右键new,driver template:MySQL Connector/J;driver name:随便起;
Connection URL:jdbc:mysql://localhost:3306/login(数据库名)
user name:root;password:mimanicaibudao
driver JARs:mysql-connector-java-5.1.7-bin.jar;
driver classname:com.mysql.jdbc.Driver;
点击finish即可;
2、回到Java项目中:
选择要添加驱动的项目,右键,build path,add library ,user library;
next;user libraries,new,输入library名字;
Add External JARs,选择mysql-connector-java-5.1.7-bin.jar;OK
3、jsp request:把mysql-connector-java-5.0.4-bin.jar拷贝到D:\Tomcat 6.0\lib下,
然后在classpath里面加入D:\Tomcat 6.0\lib\mysql-connector-java-5.0.4-bin.jar即可。
配置这个的目的是让你的java应用程序找到连接mysql的驱动。
拷贝这一步就是为JSP连接数据库配置驱动。
4、成功
连接数据库代码:
String URL="jdbc:mysql://localhost:3306/login";
String USER="root";
String PAWD="mimanicaibudao";
Connection connection=null;
Statement statement=null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection=DriverManager.getConnection(URL,USER,PAWD);
statement=connection.createStatement();
}
catch(ClassNotFoundException cnfex){
cnfex.printStackTrace();
}
catch (SQLException sqlex) {
sqlex.printStackTrace();
}
catch (Exception e) {
System.out.println(e.toString());
}
右键new,driver template:MySQL Connector/J;driver name:随便起;
Connection URL:jdbc:mysql://localhost:3306/login(数据库名)
user name:root;password:mimanicaibudao
driver JARs:mysql-connector-java-5.1.7-bin.jar;
driver classname:com.mysql.jdbc.Driver;
点击finish即可;
2、回到Java项目中:
选择要添加驱动的项目,右键,build path,add library ,user library;
next;user libraries,new,输入library名字;
Add External JARs,选择mysql-connector-java-5.1.7-bin.jar;OK
3、jsp request:把mysql-connector-java-5.0.4-bin.jar拷贝到D:\Tomcat 6.0\lib下,
然后在classpath里面加入D:\Tomcat 6.0\lib\mysql-connector-java-5.0.4-bin.jar即可。
配置这个的目的是让你的java应用程序找到连接mysql的驱动。
拷贝这一步就是为JSP连接数据库配置驱动。
4、成功
连接数据库代码:
String URL="jdbc:mysql://localhost:3306/login";
String USER="root";
String PAWD="mimanicaibudao";
Connection connection=null;
Statement statement=null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection=DriverManager.getConnection(URL,USER,PAWD);
statement=connection.createStatement();
}
catch(ClassNotFoundException cnfex){
cnfex.printStackTrace();
}
catch (SQLException sqlex) {
sqlex.printStackTrace();
}
catch (Exception e) {
System.out.println(e.toString());
}