本地项目连接服务器数据库,java - 我的项目正在连接到本地tomcat服务器6上的mysql数据库，但未连接到托管平台中的tomcat6 - 堆栈内存溢出...

写一个jsp并尝试打这个

pageEncoding="ISO-8859-1"%>

Insert title here

Start Test

Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","user","Passowrd");

out.println("Connected Successfully");

PreparedStatement preparedStatement=con.prepareStatement("SELECT * FROM admin");

ResultSet rst=preparedStatement.executeQuery();

while(rst.next()){

out.print("
"+" "+rst.getString(1)+" "+rst.getString(2)+" "+rst.getString(3));

}

preparedStatement=con.prepareStatement("SELECT count(*),admin_id,username from admin a WHERE username='ankit' AND pwd=md5('ankit')");

rst=preparedStatement.executeQuery();

while(rst.next()){

out.print("
"+" "+rst.getString(1)+" "+rst.getString(2)+" "+rst.getString(3));

}

%>