求助,Myeclipse 发布网页与数据库MySQL连接问题 发布的网页是可以正常浏览呢,知道数据库连接问题,解决不了呢!!MySQLMyEclipsejavaweb 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 /*Navicat MySQL Data TransferSource Server : zhpSource Server Version : 50525Source Host : localhost:3306Source Database : db_workTarget Server Type : MYSQLTarget Server Version : 50525File Encoding : 65001Date: 2012-07-26 13:40:24*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `admin_infor`-- ----------------------------DROP TABLE IF EXISTS `admin_infor`;CREATE TABLE `admin_infor` ( `A_Num` int(11) NOT NULL, `Name` varchar(30) NOT NULL, `Password` varchar(30) NOT NULL, `ID` int(11) NOT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------ Records of admin_infor-- ------------------------------ ------------------------------ Table structure for `attend_sheets`-- ----------------------------DROP TABLE IF EXISTS `attend_sheets`;CREATE TABLE `attend_sheets` ( `Week` varchar(30) CHARACTER SET utf8 NOT NULL, `PStar_time` time NOT NULL, `PEnd_time` time NOT NULL, `SFlex_time` int(11) NOT NULL, `PFlex_time` int(11) NOT NULL, `Department_Num` varchar(30) NOT NULL, `Company_Num` varchar(30) NOT NULL, PRIMARY KEY (`Week`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------ Records of attend_sheets-- ----------------------------INSERT INTO `attend_sheets` VALUES ('星期2', '14:12:08', '14:12:13', '11', '22', '1', '1');INSERT INTO `attend_sheets` VALUES ('星期一', '12:12:12', '13:11:12', '12', '12', '4', '3');INSERT INTO `attend_sheets` VALUES ('星期二', '20:12:12', '12:12:12', '22', '22', '2', '12');-- ------------------------------ Table structure for `dtime_sheets`-- ----------------------------DROP TABLE IF EXISTS `dtime_sheets`;CREATE TABLE `dtime_sheets` ( `E_Num` int(11) NOT NULL, `Department_Num` varchar(11) NOT NULL, `Company_Num` varchar(11) NOT NULL, `Date` date NOT NULL, `Star_time` time DEFAULT NULL, `End_time` time DEFAULT NULL, `L_hmin` int(11) DEFAULT NULL, `E_hmin` int(11) DEFAULT NULL, `Overtimemin` int(11) DEFAULT NULL, `Leave` varchar(1) NOT NULL, `Travel` varchar(1) NOT NULL, `Weekend` varchar(1) NOT NULL, `Makeup` varchar(1) CHARACTER SET utf8 NOT NULL, `ID` int(11) NOT NULL, PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------ Records of dtime_sheets-- ----------------------------INSERT INTO `dtime_sheets` VALUES ('1', '1', '1', '2010-02-02', '10:10:12', '10:10:16', '1', '1', '1', '1', '1', '1', '1', '1');INSERT INTO `dtime_sheets` VALUES ('2', '2', '2', '2012-07-17', '02:15:28', '02:15:32', '1', '1', '1', '1', '1', '1', '1', '2');-- ------------------------------ Table structure for `eaffairs_sheets`-- ----------------------------DROP TABLE IF EXISTS `eaffairs_sheets`;CREATE TABLE `eaffairs_sheets` ( `E_Num` int(11) NOT NULL, `Department_Num` varchar(11) NOT NULL, `Manager_Num` varchar(11) NOT NULL, `Project` varchar(300) CHARACTER SET utf8 NOT NULL, `Reason` varchar(200) CHARACTER SET utf8 NOT NULL, `Star_time` date NOT NULL, `End_time` date NOT NULL, `Situation` varchar(1) DEFAULT NULL, `ID` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;-- ------------------------------ Records of eaffairs_sheets-- ----------------------------INSERT INTO `eaffairs_sheets` VALUES ('2', '2', '2', 'qingjia', 'e21e1', '2111-01-11', '2112-01-11', null, '1');INSERT INTO `eaffairs_sheets` VALUES ('3', '3', '3', 'qingjia', '3', '1212-01-12', '1311-01-11', null, '2');INSERT INTO `eaffairs_sheets` VALUES ('23', '33', '333', 'qingjia', '12e', '1010-01-12', '1212-01-12', null, '3');-- ------------------------------ Table structure for `employee_infor`-- ----------------------------DROP TABLE IF EXISTS `employee_infor`;CREATE TABLE `employee_infor` ( `E_Num` int(11) NOT NULL, `Name` varchar(30) CHARACTER SET utf8 NOT NULL, `Password` varchar(30) NOT NULL, `Department_Num` varchar(30) NOT NULL, `Company_Num` int(30) NOT NULL, `Age` int(30) NOT NULL, `Sex` varchar(30) NOT NULL, `Phone_Num` varchar(30) NOT NULL, `Post` varchar(20) DEFAULT NULL, `Permissions` int(11) NOT NULL, `ID_Num` varchar(30) NOT NULL, `Address` varchar(100) DEFAULT NULL, `Departure` varchar(30) DEFAULT NULL, `Email` varchar(30) NOT NULL, `Re` varchar(300) DEFAULT NULL, `ID` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;-- ------------------------------ Records of employee_infor-- ----------------------------INSERT INTO `employee_infor` VALUES ('1', '1', '222', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');INSERT INTO `employee_infor` VALUES ('2', '2', '111', '22', '2', '2', '2', '2', '2', '2', '2', '2', '2', '2', '2', '2');-- ------------------------------ Table structure for `holiday table`-- ----------------------------DROP TABLE IF EXISTS `holiday table`;CREATE TABLE `holiday table` ( `Date` date NOT NULL, `Setting` varchar(1) DEFAULT NULL, PRIMARY KEY (`Date`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------ Records of holiday table-- ----------------------------INSERT INTO `holiday table` VALUES ('1111-11-11', '0');INSERT INTO `holiday table` VALUES ('1111-11-12', '2');INSERT INTO `holiday table` VALUES ('1111-12-12', '1');INSERT INTO `holiday table` VALUES ('1221-11-11', '1');INSERT INTO `holiday table` VALUES ('2012-02-02', '1');INSERT INTO `holiday table` VALUES ('2012-07-25', '1');INSERT INTO `holiday table` VALUES ('2222-11-11', '1');INSERT INTO `holiday table` VALUES ('2222-12-22', '2');-- ------------------------------ Table structure for `infor_release`-- ----------------------------DROP TABLE IF EXISTS `infor_release`;CREATE TABLE `infor_release` ( `Infor_Num` int(11) NOT NULL AUTO_INCREMENT, `Infor_content` varchar(200) CHARACTER SET utf8 NOT NULL, `E_Num` int(11) NOT NULL, `Release_date` date NOT NULL, PRIMARY KEY (`Infor_Num`)) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;-- ------------------------------ Records of infor_release-- ----------------------------INSERT INTO `infor_release` VALUES ('2', '下午开会', '2', '2012-07-17');INSERT INTO `infor_release` VALUES ('3', '上午有事', '3', '2012-07-17');INSERT INTO `infor_release` VALUES ('6', '33333333', '2', '2012-07-26');INSERT INTO `infor_release` VALUES ('7', '22', '3', '2012-07-26');INSERT INTO `infor_release` VALUES ('8', '33', '2', '2012-07-26');INSERT INTO `infor_release` VALUES ('9', '313', '33', '2012-07-26');INSERT INTO `infor_release` VALUES ('10', '3333', '4', '2012-07-26');INSERT INTO `infor_release` VALUES ('11', '232', '23', '2012-07-26');INSERT INTO `infor_release` VALUES ('12', '2', '2', '2012-07-26');数据库SQL文件,直接导入的; myEClipse里面数据库测试连接成功了。 怎么才能查看到到在Myeclipse运行期间是否连接了数据库呢?? 很显然是数据库没连上你试试看连接你的mysql数据库,access denied就是说没连上看看帐号密码是否正确 S2SH连接sqlserver2000报错, java.lang.SecurityException myeclipse10.0 itext怎样设置背景图片啊????????? 100 分 jsp:include 问题?各位大侠帮我来看看, 请问如何在Servlet里远程调用 Web Service? 容器外调用tomcat数据池 [转]用web.xml控制Web应用的行为 JAVA写txt文件的小问题 Java中怎么判断中文中是否包含生僻字或繁体字??急求啊 关于cmp的问题!Mastering EJB 第七章的问题! form文本框的问题 求大神指教 WebService问题,急求!!!
Navicat MySQL Data TransferSource Server : zhp
Source Server Version : 50525
Source Host : localhost:3306
Source Database : db_workTarget Server Type : MYSQL
Target Server Version : 50525
File Encoding : 65001Date: 2012-07-26 13:40:24
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for `admin_infor`
-- ----------------------------
DROP TABLE IF EXISTS `admin_infor`;
CREATE TABLE `admin_infor` (
`A_Num` int(11) NOT NULL,
`Name` varchar(30) NOT NULL,
`Password` varchar(30) NOT NULL,
`ID` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of admin_infor
-- ------------------------------ ----------------------------
-- Table structure for `attend_sheets`
-- ----------------------------
DROP TABLE IF EXISTS `attend_sheets`;
CREATE TABLE `attend_sheets` (
`Week` varchar(30) CHARACTER SET utf8 NOT NULL,
`PStar_time` time NOT NULL,
`PEnd_time` time NOT NULL,
`SFlex_time` int(11) NOT NULL,
`PFlex_time` int(11) NOT NULL,
`Department_Num` varchar(30) NOT NULL,
`Company_Num` varchar(30) NOT NULL,
PRIMARY KEY (`Week`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of attend_sheets
-- ----------------------------
INSERT INTO `attend_sheets` VALUES ('星期2', '14:12:08', '14:12:13', '11', '22', '1', '1');
INSERT INTO `attend_sheets` VALUES ('星期一', '12:12:12', '13:11:12', '12', '12', '4', '3');
INSERT INTO `attend_sheets` VALUES ('星期二', '20:12:12', '12:12:12', '22', '22', '2', '12');-- ----------------------------
-- Table structure for `dtime_sheets`
-- ----------------------------
DROP TABLE IF EXISTS `dtime_sheets`;
CREATE TABLE `dtime_sheets` (
`E_Num` int(11) NOT NULL,
`Department_Num` varchar(11) NOT NULL,
`Company_Num` varchar(11) NOT NULL,
`Date` date NOT NULL,
`Star_time` time DEFAULT NULL,
`End_time` time DEFAULT NULL,
`L_hmin` int(11) DEFAULT NULL,
`E_hmin` int(11) DEFAULT NULL,
`Overtimemin` int(11) DEFAULT NULL,
`Leave` varchar(1) NOT NULL,
`Travel` varchar(1) NOT NULL,
`Weekend` varchar(1) NOT NULL,
`Makeup` varchar(1) CHARACTER SET utf8 NOT NULL,
`ID` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of dtime_sheets
-- ----------------------------
INSERT INTO `dtime_sheets` VALUES ('1', '1', '1', '2010-02-02', '10:10:12', '10:10:16', '1', '1', '1', '1', '1', '1', '1', '1');
INSERT INTO `dtime_sheets` VALUES ('2', '2', '2', '2012-07-17', '02:15:28', '02:15:32', '1', '1', '1', '1', '1', '1', '1', '2');-- ----------------------------
-- Table structure for `eaffairs_sheets`
-- ----------------------------
DROP TABLE IF EXISTS `eaffairs_sheets`;
CREATE TABLE `eaffairs_sheets` (
`E_Num` int(11) NOT NULL,
`Department_Num` varchar(11) NOT NULL,
`Manager_Num` varchar(11) NOT NULL,
`Project` varchar(300) CHARACTER SET utf8 NOT NULL,
`Reason` varchar(200) CHARACTER SET utf8 NOT NULL,
`Star_time` date NOT NULL,
`End_time` date NOT NULL,
`Situation` varchar(1) DEFAULT NULL,
`ID` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of eaffairs_sheets
-- ----------------------------
INSERT INTO `eaffairs_sheets` VALUES ('2', '2', '2', 'qingjia', 'e21e1', '2111-01-11', '2112-01-11', null, '1');
INSERT INTO `eaffairs_sheets` VALUES ('3', '3', '3', 'qingjia', '3', '1212-01-12', '1311-01-11', null, '2');
INSERT INTO `eaffairs_sheets` VALUES ('23', '33', '333', 'qingjia', '12e', '1010-01-12', '1212-01-12', null, '3');-- ----------------------------
-- Table structure for `employee_infor`
-- ----------------------------
DROP TABLE IF EXISTS `employee_infor`;
CREATE TABLE `employee_infor` (
`E_Num` int(11) NOT NULL,
`Name` varchar(30) CHARACTER SET utf8 NOT NULL,
`Password` varchar(30) NOT NULL,
`Department_Num` varchar(30) NOT NULL,
`Company_Num` int(30) NOT NULL,
`Age` int(30) NOT NULL,
`Sex` varchar(30) NOT NULL,
`Phone_Num` varchar(30) NOT NULL,
`Post` varchar(20) DEFAULT NULL,
`Permissions` int(11) NOT NULL,
`ID_Num` varchar(30) NOT NULL,
`Address` varchar(100) DEFAULT NULL,
`Departure` varchar(30) DEFAULT NULL,
`Email` varchar(30) NOT NULL,
`Re` varchar(300) DEFAULT NULL,
`ID` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;-- ----------------------------
-- Records of employee_infor
-- ----------------------------
INSERT INTO `employee_infor` VALUES ('1', '1', '222', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');
INSERT INTO `employee_infor` VALUES ('2', '2', '111', '22', '2', '2', '2', '2', '2', '2', '2', '2', '2', '2', '2', '2');-- ----------------------------
-- Table structure for `holiday table`
-- ----------------------------
DROP TABLE IF EXISTS `holiday table`;
CREATE TABLE `holiday table` (
`Date` date NOT NULL,
`Setting` varchar(1) DEFAULT NULL,
PRIMARY KEY (`Date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of holiday table
-- ----------------------------
INSERT INTO `holiday table` VALUES ('1111-11-11', '0');
INSERT INTO `holiday table` VALUES ('1111-11-12', '2');
INSERT INTO `holiday table` VALUES ('1111-12-12', '1');
INSERT INTO `holiday table` VALUES ('1221-11-11', '1');
INSERT INTO `holiday table` VALUES ('2012-02-02', '1');
INSERT INTO `holiday table` VALUES ('2012-07-25', '1');
INSERT INTO `holiday table` VALUES ('2222-11-11', '1');
INSERT INTO `holiday table` VALUES ('2222-12-22', '2');-- ----------------------------
-- Table structure for `infor_release`
-- ----------------------------
DROP TABLE IF EXISTS `infor_release`;
CREATE TABLE `infor_release` (
`Infor_Num` int(11) NOT NULL AUTO_INCREMENT,
`Infor_content` varchar(200) CHARACTER SET utf8 NOT NULL,
`E_Num` int(11) NOT NULL,
`Release_date` date NOT NULL,
PRIMARY KEY (`Infor_Num`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;-- ----------------------------
-- Records of infor_release
-- ----------------------------
INSERT INTO `infor_release` VALUES ('2', '下午开会', '2', '2012-07-17');
INSERT INTO `infor_release` VALUES ('3', '上午有事', '3', '2012-07-17');
INSERT INTO `infor_release` VALUES ('6', '33333333', '2', '2012-07-26');
INSERT INTO `infor_release` VALUES ('7', '22', '3', '2012-07-26');
INSERT INTO `infor_release` VALUES ('8', '33', '2', '2012-07-26');
INSERT INTO `infor_release` VALUES ('9', '313', '33', '2012-07-26');
INSERT INTO `infor_release` VALUES ('10', '3333', '4', '2012-07-26');
INSERT INTO `infor_release` VALUES ('11', '232', '23', '2012-07-26');
INSERT INTO `infor_release` VALUES ('12', '2', '2', '2012-07-26');数据库SQL文件,直接导入的;
你试试看连接你的mysql数据库,access denied就是说没连上
看看帐号密码是否正确