Skip to content

Commit 72adf63

Browse files
nick-zhong123nick-zhong123
committed
添加jdbc项目
1 parent 3d039d3 commit 72adf63

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

60 files changed

+920
-0
lines changed

‎Hibernate_001/.gitignore renamed to ‎Hibernate/Hibernate_001/.gitignore

File renamed without changes.

‎Hibernate/Hibernate_001/.settings/org.eclipse.jdt.core.prefs

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
eclipse.preferences.version=1
2+
org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
3+
org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.6
4+
org.eclipse.jdt.core.compiler.codegen.unusedLocal=preserve
5+
org.eclipse.jdt.core.compiler.compliance=1.6
6+
org.eclipse.jdt.core.compiler.debug.lineNumber=generate
7+
org.eclipse.jdt.core.compiler.debug.localVariable=generate
8+
org.eclipse.jdt.core.compiler.debug.sourceFile=generate
9+
org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
10+
org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
11+
org.eclipse.jdt.core.compiler.problem.forbiddenReference=warning
12+
org.eclipse.jdt.core.compiler.source=1.6

‎Hibernate/Hibernate_001/.settings/org.eclipse.m2e.core.prefs

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
activeProfiles=
2+
eclipse.preferences.version=1
3+
resolveWorkspaceProjects=true
4+
version=1

‎Hibernate/Hibernate_001/.settings/org.hibernate.eclipse.console.prefs

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
default.configuration=
2+
eclipse.preferences.version=1
3+
hibernate3.enabled=true

‎Hibernate/Hibernate_001/.settings/org.jboss.ide.eclipse.as.core.prefs

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
eclipse.preferences.version=1
2+
org.jboss.ide.eclipse.as.core.singledeployable.deployableList=

‎Hibernate_001/pom.xml renamed to ‎Hibernate/Hibernate_001/pom.xml

File renamed without changes.

‎Hibernate_001/src/Address.hbm.xml renamed to ‎Hibernate/Hibernate_001/src/Address.hbm.xml

File renamed without changes.

‎Hibernate_001/src/Address.java renamed to ‎Hibernate/Hibernate_001/src/Address.java

File renamed without changes.

‎Hibernate_001/src/Junior.hbm.xml renamed to ‎Hibernate/Hibernate_001/src/Junior.hbm.xml

File renamed without changes.

‎Hibernate_001/src/Junior.java renamed to ‎Hibernate/Hibernate_001/src/Junior.java

File renamed without changes.

‎Hibernate_001/src/Students.hbm.xml renamed to ‎Hibernate/Hibernate_001/src/Students.hbm.xml

File renamed without changes.

‎Hibernate_001/src/Students.java renamed to ‎Hibernate/Hibernate_001/src/Students.java

File renamed without changes.

‎Hibernate_001/src/hibernate.cfg.xml renamed to ‎Hibernate/Hibernate_001/src/hibernate.cfg.xml

File renamed without changes.

‎Hibernate_001/test/SessionTest.java renamed to ‎Hibernate/Hibernate_001/test/SessionTest.java

File renamed without changes.

‎Hibernate_001/test/StudentTest.java renamed to ‎Hibernate/Hibernate_001/test/StudentTest.java

File renamed without changes.

‎Hibernate_001/test/StudentTestSessionToWork.java renamed to ‎Hibernate/Hibernate_001/test/StudentTestSessionToWork.java

File renamed without changes.

‎maven03/.gitignore renamed to ‎Maven/maven03/.gitignore

File renamed without changes.

‎maven03/.hgignore renamed to ‎Maven/maven03/.hgignore

File renamed without changes.

‎maven03/README.md renamed to ‎Maven/maven03/README.md

‎maven03/pom.xml renamed to ‎Maven/maven03/pom.xml

File renamed without changes.

‎maven03/src/main/java/com/yoyo/di/CoreModule.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/di/CoreModule.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/di/WebContextListener.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/di/WebContextListener.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/di/WebModule.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/di/WebModule.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/resource/BaseResource.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/resource/BaseResource.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/resource/BaseSNSResource.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/resource/BaseSNSResource.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/resource/HealthResource.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/resource/HealthResource.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/resource/RootResource.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/resource/RootResource.java

File renamed without changes.

‎maven03/src/main/java/com/yoyo/resource/SNSResource.java renamed to ‎Maven/maven03/src/main/java/com/yoyo/resource/SNSResource.java

File renamed without changes.

‎maven03/src/main/resources/logback.xml renamed to ‎Maven/maven03/src/main/resources/logback.xml

File renamed without changes.

‎maven03/src/main/webapp/.ebextensions/java7.config renamed to ‎Maven/maven03/src/main/webapp/.ebextensions/java7.config

File renamed without changes.

‎maven03/src/main/webapp/WEB-INF/web.xml renamed to ‎Maven/maven03/src/main/webapp/WEB-INF/web.xml

File renamed without changes.

‎maven03/src/test/java/com/yoyo/SanityTest.java renamed to ‎Maven/maven03/src/test/java/com/yoyo/SanityTest.java

File renamed without changes.

‎maven03/src/test/java/com/yoyo/ServerTest.java renamed to ‎Maven/maven03/src/test/java/com/yoyo/ServerTest.java

File renamed without changes.

‎maven03/src/test/java/com/yoyo/fixture/ContainerRule.java renamed to ‎Maven/maven03/src/test/java/com/yoyo/fixture/ContainerRule.java

File renamed without changes.

‎maven03/src/test/java/com/yoyo/fixture/ServerRule.java renamed to ‎Maven/maven03/src/test/java/com/yoyo/fixture/ServerRule.java

File renamed without changes.

‎maven03/src/test/resources/aws.properties renamed to ‎Maven/maven03/src/test/resources/aws.properties

File renamed without changes.

‎maven03/src/test/resources/logback-test.xml renamed to ‎Maven/maven03/src/test/resources/logback-test.xml

File renamed without changes.

‎wedemo.demo01/.gitignore renamed to ‎Maven/wedemo.demo01/.gitignore

File renamed without changes.

‎Maven/wedemo.demo01/.settings/.jsdtscope

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
<classpath>
3+
<classpathentry kind="src" path="src/main/webapp"/>
4+
<classpathentry kind="con" path="org.eclipse.wst.jsdt.launching.JRE_CONTAINER"/>
5+
<classpathentry kind="con" path="org.eclipse.wst.jsdt.launching.WebProject">
6+
<attributes>
7+
<attribute name="hide" value="true"/>
8+
</attributes>
9+
</classpathentry>
10+
<classpathentry kind="con" path="org.eclipse.wst.jsdt.launching.baseBrowserLibrary"/>
11+
<classpathentry kind="output" path=""/>
12+
</classpath>

‎Maven/wedemo.demo01/.settings/org.eclipse.jdt.core.prefs

Lines changed: 99 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,99 @@
1+
eclipse.preferences.version=1
2+
org.eclipse.jdt.core.compiler.annotation.inheritNullAnnotations=disabled
3+
org.eclipse.jdt.core.compiler.annotation.missingNonNullByDefaultAnnotation=ignore
4+
org.eclipse.jdt.core.compiler.annotation.nonnull=org.eclipse.jdt.annotation.NonNull
5+
org.eclipse.jdt.core.compiler.annotation.nonnullbydefault=org.eclipse.jdt.annotation.NonNullByDefault
6+
org.eclipse.jdt.core.compiler.annotation.nullable=org.eclipse.jdt.annotation.Nullable
7+
org.eclipse.jdt.core.compiler.annotation.nullanalysis=disabled
8+
org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
9+
org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.5
10+
org.eclipse.jdt.core.compiler.codegen.unusedLocal=preserve
11+
org.eclipse.jdt.core.compiler.compliance=1.5
12+
org.eclipse.jdt.core.compiler.debug.lineNumber=generate
13+
org.eclipse.jdt.core.compiler.debug.localVariable=generate
14+
org.eclipse.jdt.core.compiler.debug.sourceFile=generate
15+
org.eclipse.jdt.core.compiler.problem.annotationSuperInterface=warning
16+
org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
17+
org.eclipse.jdt.core.compiler.problem.autoboxing=ignore
18+
org.eclipse.jdt.core.compiler.problem.comparingIdentical=warning
19+
org.eclipse.jdt.core.compiler.problem.deadCode=warning
20+
org.eclipse.jdt.core.compiler.problem.deprecation=warning
21+
org.eclipse.jdt.core.compiler.problem.deprecationInDeprecatedCode=disabled
22+
org.eclipse.jdt.core.compiler.problem.deprecationWhenOverridingDeprecatedMethod=disabled
23+
org.eclipse.jdt.core.compiler.problem.discouragedReference=warning
24+
org.eclipse.jdt.core.compiler.problem.emptyStatement=ignore
25+
org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
26+
org.eclipse.jdt.core.compiler.problem.explicitlyClosedAutoCloseable=ignore
27+
org.eclipse.jdt.core.compiler.problem.fallthroughCase=ignore
28+
org.eclipse.jdt.core.compiler.problem.fatalOptionalError=disabled
29+
org.eclipse.jdt.core.compiler.problem.fieldHiding=ignore
30+
org.eclipse.jdt.core.compiler.problem.finalParameterBound=warning
31+
org.eclipse.jdt.core.compiler.problem.finallyBlockNotCompletingNormally=warning
32+
org.eclipse.jdt.core.compiler.problem.forbiddenReference=warning
33+
org.eclipse.jdt.core.compiler.problem.hiddenCatchBlock=warning
34+
org.eclipse.jdt.core.compiler.problem.includeNullInfoFromAsserts=disabled
35+
org.eclipse.jdt.core.compiler.problem.incompatibleNonInheritedInterfaceMethod=warning
36+
org.eclipse.jdt.core.compiler.problem.incompleteEnumSwitch=warning
37+
org.eclipse.jdt.core.compiler.problem.indirectStaticAccess=ignore
38+
org.eclipse.jdt.core.compiler.problem.localVariableHiding=ignore
39+
org.eclipse.jdt.core.compiler.problem.methodWithConstructorName=warning
40+
org.eclipse.jdt.core.compiler.problem.missingDefaultCase=ignore
41+
org.eclipse.jdt.core.compiler.problem.missingDeprecatedAnnotation=ignore
42+
org.eclipse.jdt.core.compiler.problem.missingEnumCaseDespiteDefault=disabled
43+
org.eclipse.jdt.core.compiler.problem.missingHashCodeMethod=ignore
44+
org.eclipse.jdt.core.compiler.problem.missingOverrideAnnotation=ignore
45+
org.eclipse.jdt.core.compiler.problem.missingOverrideAnnotationForInterfaceMethodImplementation=enabled
46+
org.eclipse.jdt.core.compiler.problem.missingSerialVersion=warning
47+
org.eclipse.jdt.core.compiler.problem.missingSynchronizedOnInheritedMethod=ignore
48+
org.eclipse.jdt.core.compiler.problem.noEffectAssignment=warning
49+
org.eclipse.jdt.core.compiler.problem.noImplicitStringConversion=warning
50+
org.eclipse.jdt.core.compiler.problem.nonExternalizedStringLiteral=ignore
51+
org.eclipse.jdt.core.compiler.problem.nonnullParameterAnnotationDropped=warning
52+
org.eclipse.jdt.core.compiler.problem.nullAnnotationInferenceConflict=error
53+
org.eclipse.jdt.core.compiler.problem.nullReference=warning
54+
org.eclipse.jdt.core.compiler.problem.nullSpecViolation=error
55+
org.eclipse.jdt.core.compiler.problem.nullUncheckedConversion=warning
56+
org.eclipse.jdt.core.compiler.problem.overridingPackageDefaultMethod=warning
57+
org.eclipse.jdt.core.compiler.problem.parameterAssignment=ignore
58+
org.eclipse.jdt.core.compiler.problem.possibleAccidentalBooleanAssignment=ignore
59+
org.eclipse.jdt.core.compiler.problem.potentialNullReference=ignore
60+
org.eclipse.jdt.core.compiler.problem.potentiallyUnclosedCloseable=ignore
61+
org.eclipse.jdt.core.compiler.problem.rawTypeReference=warning
62+
org.eclipse.jdt.core.compiler.problem.redundantNullAnnotation=warning
63+
org.eclipse.jdt.core.compiler.problem.redundantNullCheck=ignore
64+
org.eclipse.jdt.core.compiler.problem.redundantSpecificationOfTypeArguments=ignore
65+
org.eclipse.jdt.core.compiler.problem.redundantSuperinterface=ignore
66+
org.eclipse.jdt.core.compiler.problem.reportMethodCanBePotentiallyStatic=ignore
67+
org.eclipse.jdt.core.compiler.problem.reportMethodCanBeStatic=ignore
68+
org.eclipse.jdt.core.compiler.problem.specialParameterHidingField=disabled
69+
org.eclipse.jdt.core.compiler.problem.staticAccessReceiver=warning
70+
org.eclipse.jdt.core.compiler.problem.suppressOptionalErrors=disabled
71+
org.eclipse.jdt.core.compiler.problem.suppressWarnings=enabled
72+
org.eclipse.jdt.core.compiler.problem.syntacticNullAnalysisForFields=disabled
73+
org.eclipse.jdt.core.compiler.problem.syntheticAccessEmulation=ignore
74+
org.eclipse.jdt.core.compiler.problem.typeParameterHiding=warning
75+
org.eclipse.jdt.core.compiler.problem.unavoidableGenericTypeProblems=enabled
76+
org.eclipse.jdt.core.compiler.problem.uncheckedTypeOperation=warning
77+
org.eclipse.jdt.core.compiler.problem.unclosedCloseable=warning
78+
org.eclipse.jdt.core.compiler.problem.undocumentedEmptyBlock=ignore
79+
org.eclipse.jdt.core.compiler.problem.unhandledWarningToken=warning
80+
org.eclipse.jdt.core.compiler.problem.unnecessaryElse=ignore
81+
org.eclipse.jdt.core.compiler.problem.unnecessaryTypeCheck=ignore
82+
org.eclipse.jdt.core.compiler.problem.unqualifiedFieldAccess=ignore
83+
org.eclipse.jdt.core.compiler.problem.unusedDeclaredThrownException=ignore
84+
org.eclipse.jdt.core.compiler.problem.unusedDeclaredThrownExceptionExemptExceptionAndThrowable=enabled
85+
org.eclipse.jdt.core.compiler.problem.unusedDeclaredThrownExceptionIncludeDocCommentReference=enabled
86+
org.eclipse.jdt.core.compiler.problem.unusedDeclaredThrownExceptionWhenOverriding=disabled
87+
org.eclipse.jdt.core.compiler.problem.unusedImport=warning
88+
org.eclipse.jdt.core.compiler.problem.unusedLabel=warning
89+
org.eclipse.jdt.core.compiler.problem.unusedLocal=warning
90+
org.eclipse.jdt.core.compiler.problem.unusedObjectAllocation=ignore
91+
org.eclipse.jdt.core.compiler.problem.unusedParameter=ignore
92+
org.eclipse.jdt.core.compiler.problem.unusedParameterIncludeDocCommentReference=enabled
93+
org.eclipse.jdt.core.compiler.problem.unusedParameterWhenImplementingAbstract=disabled
94+
org.eclipse.jdt.core.compiler.problem.unusedParameterWhenOverridingConcrete=disabled
95+
org.eclipse.jdt.core.compiler.problem.unusedPrivateMember=warning
96+
org.eclipse.jdt.core.compiler.problem.unusedTypeParameter=ignore
97+
org.eclipse.jdt.core.compiler.problem.unusedWarningToken=warning
98+
org.eclipse.jdt.core.compiler.problem.varargsArgumentNeedCast=warning
99+
org.eclipse.jdt.core.compiler.source=1.5

‎Maven/wedemo.demo01/.settings/org.eclipse.m2e.core.prefs

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
activeProfiles=
2+
eclipse.preferences.version=1
3+
resolveWorkspaceProjects=true
4+
version=1

‎Maven/wedemo.demo01/.settings/org.eclipse.wst.common.component

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,11 @@
1+
<?xml version="1.0" encoding="UTF-8"?><project-modules id="moduleCoreId" project-version="1.5.0">
2+
<wb-module deploy-name="wedemo.demo01">
3+
<wb-resource deploy-path="/" source-path="/target/m2e-wtp/web-resources"/>
4+
<wb-resource deploy-path="/" source-path="/src/main/webapp" tag="defaultRootSource"/>
5+
<wb-resource deploy-path="/WEB-INF/classes" source-path="/src/main/resources"/>
6+
<wb-resource deploy-path="/WEB-INF/classes" source-path="/java"/>
7+
<wb-resource deploy-path="/WEB-INF/classes" source-path="/src/main/java"/>
8+
<property name="context-root" value="wedemo.demo01"/>
9+
<property name="java-output-path" value="/wedemo.demo01/target/classes"/>
10+
</wb-module>
11+
</project-modules>

‎Maven/wedemo.demo01/.settings/org.eclipse.wst.common.project.facet.core.xml

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
<faceted-project>
3+
<fixed facet="wst.jsdt.web"/>
4+
<installed facet="java" version="1.5"/>
5+
<installed facet="jst.web" version="2.3"/>
6+
<installed facet="wst.jsdt.web" version="1.0"/>
7+
</faceted-project>

‎Maven/wedemo.demo01/.settings/org.eclipse.wst.jsdt.ui.superType.container

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
org.eclipse.wst.jsdt.launching.baseBrowserLibrary

‎Maven/wedemo.demo01/.settings/org.eclipse.wst.jsdt.ui.superType.name

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
Window

‎Maven/wedemo.demo01/.settings/org.eclipse.wst.validation.prefs

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
disabled=06target
2+
eclipse.preferences.version=1

‎wedemo.demo01/pom.xml renamed to ‎Maven/wedemo.demo01/pom.xml

File renamed without changes.

‎wedemo.demo01/src/main/webapp/WEB-INF/web.xml renamed to ‎Maven/wedemo.demo01/src/main/webapp/WEB-INF/web.xml

File renamed without changes.

‎wedemo.demo01/src/main/webapp/index.jsp renamed to ‎Maven/wedemo.demo01/src/main/webapp/index.jsp

File renamed without changes.

‎jdbc/jdbc_imooc/.gitignore

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
/bin/
2+
/target/

‎jdbc/jdbc_imooc/.settings/org.eclipse.jdt.core.prefs

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
eclipse.preferences.version=1
2+
org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
3+
org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.6
4+
org.eclipse.jdt.core.compiler.codegen.unusedLocal=preserve
5+
org.eclipse.jdt.core.compiler.compliance=1.6
6+
org.eclipse.jdt.core.compiler.debug.lineNumber=generate
7+
org.eclipse.jdt.core.compiler.debug.localVariable=generate
8+
org.eclipse.jdt.core.compiler.debug.sourceFile=generate
9+
org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
10+
org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
11+
org.eclipse.jdt.core.compiler.problem.forbiddenReference=warning
12+
org.eclipse.jdt.core.compiler.source=1.6

‎jdbc/jdbc_imooc/.settings/org.eclipse.m2e.core.prefs

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
activeProfiles=
2+
eclipse.preferences.version=1
3+
resolveWorkspaceProjects=true
4+
version=1

‎jdbc/jdbc_imooc/pom.xml

Lines changed: 27 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,27 @@
1+
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
2+
<modelVersion>4.0.0</modelVersion>
3+
<groupId>jdbc_imooc</groupId>
4+
<artifactId>jdbc_imooc</artifactId>
5+
<version>0.0.1-SNAPSHOT</version>
6+
<build>
7+
<sourceDirectory>src</sourceDirectory>
8+
<plugins>
9+
<plugin>
10+
<artifactId>maven-compiler-plugin</artifactId>
11+
<version>3.1</version>
12+
<configuration>
13+
<source>1.6</source>
14+
<target>1.6</target>
15+
</configuration>
16+
</plugin>
17+
</plugins>
18+
</build>
19+
<dependencies>
20+
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
21+
<dependency>
22+
<groupId>mysql</groupId>
23+
<artifactId>mysql-connector-java</artifactId>
24+
<version>5.1.40</version>
25+
</dependency>
26+
</dependencies>
27+
</project>

‎jdbc/jdbc_imooc/sql/imooc.sql

Lines changed: 41 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,41 @@
1+
/*
2+
Navicat MySQL Data Transfer
3+
4+
Source Server : 本地
5+
Source Server Version : 50615
6+
Source Host : localhost:3306
7+
Source Database : imooc
8+
9+
Target Server Type : MYSQL
10+
Target Server Version : 50615
11+
File Encoding : 65001
12+
13+
Date: 2015-01-14 00:06:01
14+
*/
15+
16+
SET FOREIGN_KEY_CHECKS=0;
17+
18+
-- ----------------------------
19+
-- Table structure for imooc_goddess
20+
-- ----------------------------
21+
DROP TABLE IF EXISTS `imooc_goddess`;
22+
CREATE TABLE `imooc_goddess` (
23+
`id` int(11) NOT NULL AUTO_INCREMENT,
24+
`user_name` varchar(30) NOT NULL,
25+
`sex` int(11) DEFAULT NULL,
26+
`age` int(11) DEFAULT NULL,
27+
`birthday` date DEFAULT NULL,
28+
`email` varchar(30) DEFAULT NULL,
29+
`mobile` varchar(11) DEFAULT NULL,
30+
`create_user` varchar(30) DEFAULT NULL,
31+
`create_date` date DEFAULT NULL,
32+
`update_user` varchar(30) DEFAULT NULL,
33+
`update_date` date DEFAULT NULL,
34+
`isdel` int(11) DEFAULT NULL,
35+
PRIMARY KEY (`id`)
36+
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
37+
38+
-- ----------------------------
39+
-- Records of imooc_goddess
40+
-- ----------------------------
41+
INSERT INTO `imooc_goddess` VALUES ('1', '小溪', '1', '22', '2000-12-12', 'xiaoxi@163.com', '13911111111', 'ADMIN', '2015-01-08', 'ADMIN', '2015-01-08', '0');

‎jdbc/jdbc_imooc/src/com/imooc/action/GoddessAction.java

Lines changed: 117 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,117 @@
1+
package com.imooc.action;
2+
3+
import java.sql.SQLException;
4+
import java.util.ArrayList;
5+
import java.util.Date;
6+
import java.util.HashMap;
7+
import java.util.List;
8+
import java.util.Map;
9+
10+
import com.imooc.dao.GoddessDao;
11+
import com.imooc.model.Goddess;
12+
13+
public class GoddessAction {
14+
15+
public void add(Goddess goddess) throws SQLException {
16+
GoddessDao dao = new GoddessDao();
17+
dao.addGoddess(goddess);
18+
}
19+
20+
public List<Goddess> get(Integer id) throws SQLException {
21+
GoddessDao dao = new GoddessDao();
22+
return dao.get(id);
23+
}
24+
25+
public void edit(Goddess goddess) throws SQLException {
26+
GoddessDao dao = new GoddessDao();
27+
dao.updateGoddess(goddess);
28+
}
29+
30+
public void del(Integer id) throws SQLException {
31+
GoddessDao dao = new GoddessDao();
32+
dao.delGoddess(id);
33+
}
34+
35+
public List<Goddess> query() throws SQLException {
36+
GoddessDao dao = new GoddessDao();
37+
return dao.query();
38+
}
39+
40+
public List<Goddess> query(List<Map<String, Object>> params) throws SQLException {
41+
GoddessDao dao = new GoddessDao();
42+
return dao.query(params);
43+
}
44+
45+
public static void main(String[] args) throws SQLException {
46+
GoddessDao gd = new GoddessDao();
47+
List<Goddess> gs = null;
48+
49+
/*Goddess g1 = new Goddess();
50+
g1.setUser_name("小丽");
51+
g1.setAge(22);
52+
g1.setSex(1);
53+
g1.setBirthday(new Date());
54+
g1.setEmail("xiaoxia@163.com");
55+
g1.setMobile("123456");
56+
g1.setCreate_user("大牛");
57+
g1.setCreate_date(new Date());
58+
g1.setUpdate_user("大牛哥");
59+
g1.setUpdate_date(new Date());
60+
g1.setIsdel(1);
61+
gd.addGoddess(g1);*/
62+
63+
/*Goddess g1 = new Goddess();
64+
g1.setId(2);
65+
g1.setUser_name("小丽");
66+
g1.setAge(22);
67+
g1.setSex(1);
68+
g1.setBirthday(new Date());
69+
g1.setEmail("xiaoxia@163.com");
70+
g1.setMobile("123456");
71+
g1.setUpdate_user("大牛哥");
72+
g1.setUpdate_date(new Date());
73+
g1.setIsdel(1);
74+
System.out.println("user_name: " + g1.getUser_name());
75+
gd.updateGoddess(g1);*/
76+
77+
//gd.delGoddess(2);
78+
79+
/*
80+
gs = gd.get(3);
81+
for(Goddess g: gs) {
82+
System.out.println(g.getUser_name());
83+
}*/
84+
85+
/*gs = gd.query();
86+
System.out.println("Start query");
87+
for(Goddess g: gs) {
88+
System.out.println(g.getUser_name());
89+
}*/
90+
91+
gs = gd.query("小丽");
92+
System.out.println(gs.size());
93+
for(int i = 0; i < gs.size(); i++) {
94+
System.out.println(gs.get(i).toString());
95+
}
96+
97+
/*List<Map<String, Object>> params = new ArrayList<Map<String, Object>> ();
98+
Map<String, Object> param = new HashMap<String, Object> ();
99+
100+
param.put("name", "user_name");
101+
param.put("rela", "like");
102+
param.put("value", "'%小%'");
103+
params.add(param);
104+
105+
param = new HashMap<String, Object> ();
106+
param.put("name", "mobile");
107+
param.put("rela", "like");
108+
param.put("value", "'%6%'");
109+
params.add(param);
110+
111+
gs = gd.query(params);
112+
System.out.println(gs.size());
113+
for(int i = 0; i < gs.size(); i++) {
114+
System.out.println(gs.get(i).toString());
115+
}*/
116+
}
117+
}

0 commit comments

Comments
 (0)