连接不上MYSQL数据库啊,菜鸟在线狂等
用了大家说得方法,郁闷了好几天啊!还是连接不上数据库阿,真不知道为什么啊!驱动我也放在tomcat下了。代码在发一次,帮帮忙:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ import="java.sql.*"%>
<%
final String DBDRIVER = "org.gjt.mm.mysql.Driver";
final String DBURL = "jdbc:mysql://localhost:3306/mysql";
final String DBUSER = "root";
final String DBPASSWORD ="";
Connection conn = null;
%>
<%
try
{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
Statement stmt = conn.createStatement();
String sql = "CREATE TABLE person(name varchar(32))";
stmt.executeUpdate(sql);
stmt.close();
}
catch(Exception e)
{
out.println(e);
}
%>