<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*;"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
String userName="root";
String password="123";
sql="SELECT*FROM books";
conn=DriverManager.getConnection("jdbc:mysql://loclhost:3306/test",userName,password);/* 连接数据库*/
statement=conn.createStatement();/* 通过connection数据库链接对象 创建一个statement对象数据库操作对象 */
rs=statement.executeQuery(sql);
out.print("
"); out.print("</TR>");
}
out.print("</Table>");
conn.close();
} catch(SQLException e1){
out.print("error sqlException!");
}
%>
"+"id"); out.print(" | "+"bookname"); out.print(" | "+"bookwriter"); out.print(" | "+"publisher"); out.print(" | "+"type"); out.print(" | "+"price"); out.print(" |
---|---|---|---|---|---|
"+rs.getString(1)+" | "+rs.getString(2)+" | "+rs.getString(3)+" | "+rs.getString(4)+" | "+rs.getString(5)+" | "+rs.getString(6)+" |
1、在Myeclipse中启动已有项目时,如果项目是直接拷贝到本机上,加载workbench后里面的Package
Explore没有任何包文件,如图:
2.在Package Explore中右键->new->选择Java Project,在Project name一栏中输入原项目名字。于是原项目中的代码和网页文件就会自动导入到Package Explore中:
3.然后配置......
答案就在这里:Myeclipse配置Tomcat 以及连接数据库
----------------------Hi,地球人,我是问答机器人小S,上面的内容就是我狂拽酷炫叼炸天的答案,除了赞同,你还有别的选择吗?