1) 二十四小时制: “yyyy-MM-dd HH:mm:ss”
2)十二小时制: “"yyyy-MM-dd hh:mm:ss"”
日期函数:
<%@page import="java.util.Date" %>
<%@page import="java.text.*"%>
<%
Date date=new Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
%>
sdf.format(date)
String sql="insert into kehuxinxi(bianhao,xingming,gongsimingcheng,dianhua,chuanzhen,youxiang,dizhi,beizhu,addtime) values('"+bianhao+"','"+xingming+"','"+gongsimingcheng+"','"+dianhua+"','"+chuanzhen+"','"+youxiang+"','"+dizhi+"','"+beizhu+"','"+sdf.format(date)+"') ";
String sql="insert into shangpinleibie(leibiemingcheng,addtime) values('"+leibiemingcheng+"','"+sdf.format(date)+"') ";
C:\Users\Administrator\Workspaces\MyEclipse 8.5 之前路径
在资源文件中:
DATASOURCE_jdbcUrl=jdbc\:mysql\://localhost\:3306/p7?useUnicode\=true&characterEncoding\=utf-8&autoReconnect\=true
hibernate编码(sping中)
?useUnicode=true&characterEncoding=utf-8
mvc编码(在资源文件中db.properties)
?useUnicode=true&characterEncoding=utf8
jdbc.url=jdbc:mysql://127.0.0.1:3306/xymh?useUnicode=true&characterEncoding=utf-8
sqlserver中编码
String Url="jdbc:sqlserver://localhost:1433;DataBaseName=mydb;user=sa&password=sa&useUnicode=true&characterEncoding=GB2312";
mysqld -install
mysqld -remove
net start mysql
Integer.parseInt(newsId) String 转换为int
编码转换问题
<%
request.setCharacterEncoding("ISO-8859-1");
String fileName=request.getParameter("Name");
System.out.println("=========================================="+fileName);
fileName =new String(fileName.getBytes("ISO-8859-1"),"UTF-8");
System.out.println("=========================================="+fileName);
%>