首先需要下载jdbc:mysql-connector-java-5.1.22-bin.jar,引入工程中;
然后将jdbc放到tomcat的lib目录下
连接代码:
[code=java]public class DbCon {
private String url;
private String userName;
private String password;
public DbCon(){
url = "jdbc:mysql://127.0.0.1:3306/studentinfo";
userName = "root";
password = "root";
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Connection getConnection(){
Connection con = null;
try {
con = DriverManager.getConnection(url,userName,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (con!=null) {
System.out.println("-----con success------");
}
return con;
}[/code]
然后将jdbc放到tomcat的lib目录下
连接代码:
[code=java]public class DbCon {
private String url;
private String userName;
private String password;
public DbCon(){
url = "jdbc:mysql://127.0.0.1:3306/studentinfo";
userName = "root";
password = "root";
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Connection getConnection(){
Connection con = null;
try {
con = DriverManager.getConnection(url,userName,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (con!=null) {
System.out.println("-----con success------");
}
return con;
}[/code]