SSH个人相册
使用Maven环境下创建album相册管理
pom中找不到oracle数据库驱动问题
Missing artifact com.oracle:ojdbc6:jar:11.2.0.1.0
原因:Oracle的ojdbc.jar是收费的,所以maven的中央仓库中没有这个资源,只能通过配置本地库才能加载到项目中去。
废话不多说,解决方案如下:
1.首先确定你是否有安装oracle,如果有安装的话,找到ojdbc6.jar包
D:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar(这是我路径,你们的可能与我不同)
2.将ojdbc6.jar包添加到maven,也就是运行下面的语句,注意:不是在C盘下运行,是在该目录下执行下面的语句,如果你不知道你的版本号,可以执行select * from v$version;进行查看
mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.1.0 -Dpackaging=jar -Dfile=ojdbc6.jar
安装成功
3.最后找到项目的pom.xml引入如下代码,右击项目名称,找到maven,找到update project更新下就ok了
com.oracle ojdbc6 11.2.0.1.0作者:viktoria
来源:CSDN
原文:https://blog.csdn.net/viktoria/article/details/77503266/
版权声明:本文为博主原创文章,转载请附上博文链接!
关于在eclipse中web.xml找不到配置文件解决方案
eclipse中基于maven构建的web项目pom.xml中指定的jar包无法发布到tomcat中
1、点击项目然后右键proto
2.在文本框中输入Deployment Assembly 然后点击 add 找到 Java Build Path Entries
3.选择 Maven Dependencies即可
关于ssh整合中遇到找不到action或者是路径不对问题
注意:action即控制器中的方法必须是公开的
1.首先检查路径是否有误
2.检查是否开启动态调用 和 开启白名单
<constant name="struts.enable.DynamicMethodInvocation" value="true"/>
<!-- 设置白名单 -->
<global-allowed-methods>regex:.*</global-allowed-methods>
3.如果以上还是出错,检查一下web.xml的struts2的中央控制器
4.如果以上还是出错,那么检查一下你的action中方法必须给public公开的
5.最后还是解决不了,就重新换一下jar包 依赖 可能是依赖冲突
关于js中使用submit会出现两次提交的形式
在from表单中input类型为submit,而提交方式为点击按钮使用ajax方式提交,会出现两次请求后台的情况
即出现表单提交 但是页面没有跳转成功,即出现两次请求后台的信息
解决方法,使用ajax提交时 input提交方式改为button方式,
//注册
$("#registerForm").submit(function(){
if(checkuserName() && checkpassword() && checkemail()){
addUserInfo_Ajax();
return true;
}/* else{
return false;
} */
})
因为ajax是异步的,当在运行ajax的代码时候,此时程序提交了submit而没有进行进入ajax中,所以会在地址栏后面加上属性
因为使用submit提交方式
##关于sql多条件group by
select ai.albumId,ai.albumName,ai.albumCover,ai.albumDate,count(pi.photoId) as ct
from AlbumInfo ai left join PhotoInfo pi on ai.albumId=pi.albumId
group by ai.albumId,ai.albumName,ai.albumCover,ai.albumDate
在hibernate如何使用呢?
一种使用构造函数的方法,即投影查询投影查询有三种方式:
1.直接查
2.查询返回对象
3.查询返回Map键值对
这里使用Map键值对查询
注意:使用键值对必须使用给其要列名创建别名
##关于上传图片 预览图片中遇到的坑?
<script type="text/javascript">
function doFileChange(fileElm){
var reader = new FileReader();//文件读取器
reader.onload=function(e){ //文件加载
$("#photoPreview").append("<img src='"+e.target.result+"'/>");
}
for(var i=0;i<fileElm.files.length;i++){
reader.readAsDataURL(fileElm.files[i]);
}
}
</script>
当你添加多个图片的时候,则会在前台控制器报错
即当前的程序正在读取图片,是什么原因呢?原因是当你第一张图片还没有reader.readAsDataURL(fileElm.files[i]);又在读取第二张图片
解决方法:使用回调函数:递归方法来执行
<script type="text/javascript">
function doFileChange(fileElm){
var reader = new FileReader();//文件读取器
var index = 0; //声明第一张图片
reader.onload=function(e){ //文件加载
$("#photoPreview").append("<img src='"+e.target.result+"'/>");
console.log(index);
index++;//自身加一
if(index<fileElm.files.length){//判断是否还有图片
reader.readAsDataURL(fileElm.files[index]);//读取第二张 第三张。。。
}
}
reader.readAsDataURL(fileElm.files[index]);//读取第一张图片
}
</script>
用插件实现预览图片 这里插件引用的时lrz
就不用考虑线程阻塞问题
<script src="${pageContext.request.contextPath }/js/jquery-3.3.1.js"></script>
<script src="${pageContext.request.contextPath }/js/lrz/lrz.bundle.js"></script>
<script type="text/javascript">
function doFileChange(fileElm){
for(var i=0;i<fileElm.files.length;i++){
lrz(fileElm.files[i],{width:900}).then(function(reslutObj){//对图片进行压缩
$("#photoPreview").append("<img src='"+reslutObj.base64+"'/>");
})
}
}
//这里仅仅是显示图片,对图片没有压缩
/* function doFileChange(fileElm){
var reader = new FileReader();//文件读取器
var index = 0; //声明第一张图片
$("#imgTip").show();
reader.onload=function(e){ //文件加载
$("#photoPreview").append("<img src='"+e.target.result+"'/>");
console.log(index);
index++;//自身加一
if(index<fileElm.files.length){//判断是否还有图片
reader.readAsDataURL(fileElm.files[index]);//读取第二张 第三张。。。
}else{
$("#imgTip").hide();
}
}
reader.readAsDataURL(fileElm.files[index]);//读取第一张图片
} */
</script>
关于图片垂直居中的方法
<div class="photoList">
<s:iterator value="#request.photoList" var="pi">
<section>
<span><span> <img src="${rt }/${pi.photoUrl}">
<label>文字说明</label>
</section>
</s:iterator>
</div>
在图片旁边多加一个span标签;用的原理是 图片与文字垂直居中的方法
css样式的写法
.photoList section img{
max-height: 100%;max-width: 100%;
vertical-align: middle;
}
.photoList section span{
vertical-align: middle;height: 100%;display: inline-block; <!--处理图片垂直居中的方法-->
}
pom.xml文件配置的内容
<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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.bdqn.album.sys</groupId>
<artifactId>album</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>album Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<!-- servlet的依赖 -->
<!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- junit -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/antlr/antlr -->
<dependency>
<groupId>antlr</groupId>
<artifactId>antlr</artifactId>
<version>2.7.7</version>
</dependency>
<!-- https://mvnrepository.com/artifact/aopalliance/aopalliance -->
<dependency>
<groupId>aopalliance</groupId>
<artifactId>aopalliance</artifactId>
<version>1.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.ow2.asm/asm -->
<!-- <dependency>
<groupId>org.ow2.asm</groupId>
<artifactId>asm</artifactId>
<version>5.2</version>
</dependency> -->
<!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.6.8</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.fasterxml/classmate -->
<dependency>
<groupId>com.fasterxml</groupId>
<artifactId>classmate</artifactId>
<version>1.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-pool/commons-pool -->
<dependency>
<groupId>commons-pool</groupId>
<artifactId>commons-pool</artifactId>
<version>1.5.3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.5</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-lang3 -->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
<version>3.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/dom4j/dom4j -->
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.freemarker/freemarker -->
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>2.3.26-incubating</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.geronimo.specs/geronimo-jta_1.1_spec -->
<dependency>
<groupId>org.apache.geronimo.specs</groupId>
<artifactId>geronimo-jta_1.1_spec</artifactId>
<version>1.1.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate.common/hibernate-commons-annotations -->
<dependency>
<groupId>org.hibernate.common</groupId>
<artifactId>hibernate-commons-annotations</artifactId>
<version>5.0.1.Final</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.1.4.Final</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate.javax.persistence/hibernate-jpa-2.1-api -->
<dependency>
<groupId>org.hibernate.javax.persistence</groupId>
<artifactId>hibernate-jpa-2.1-api</artifactId>
<version>1.0.0.Final</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.jboss/jandex -->
<dependency>
<groupId>org.jboss</groupId>
<artifactId>jandex</artifactId>
<version>2.0.3.Final</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.javassist/javassist -->
<dependency>
<groupId>org.javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.20.0-GA</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.jboss.logging/jboss-logging -->
<dependency>
<groupId>org.jboss.logging</groupId>
<artifactId>jboss-logging</artifactId>
<version>3.3.0.Final</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-api -->
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-api</artifactId>
<version>2.10.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/ognl/ognl -->
<dependency>
<groupId>ognl</groupId>
<artifactId>ognl</artifactId>
<version>3.1.15</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-aop -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-expression -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.2.0.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-core -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-core</artifactId>
<version>2.5.16</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-json-plugin -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-json-plugin</artifactId>
<version>2.5.16</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-spring-plugin -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-spring-plugin</artifactId>
<version>2.5.16</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.shiro/shiro-all -->
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-all</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc5</artifactId>
<version>11.2.0.1.0</version>
</dependency>
<!-- action注解 -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-convention-plugin</artifactId>
<version>2.5.16</version>
</dependency>
</dependencies>
<build>
<finalName>album</finalName>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.5.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
</build>
</project>
下载路径
https://download.csdn.net/download/weixin_42736725/11190361