代码如下：
建立连接
package Test;
import javasql;
public class ConnectionManager {
private static final String DRIVER_CLASS="commicrosoftsqlserverjdbcSQLServerDriver"; //定义常量（下同）
private static final String DATABASE="jdbc:sqlserver://localhost:1433;DatabaseName=news";
private static final String DATABASE_USER = "sa";
private static final String DATAVSES_PASS = "123456";
public static Connection getConnection(){
Connection conn = null;
try {
ClassforName(DRIVER_CLASS);
conn = DriverManagergetConnection(DATABASE,DATABASE_USER,DATAVSES_PASS);
} catch (Exception e) {
eprintStackTrace();
}
return conn;
}
public static void clossConnection (Connection connection){ //释放资源（下同）
try {
if (connection !=null && !connectionisClosed()){
connectionclose();
}
} catch (SQLException e) {
eprintStackTrace();
}
}
public static void closeResultSet(ResultSet rs){
try {
if (rs!=null){
rsclose();
rs = null ;
}
} catch (Exception e) {
eprintStackTrace();
}
}
public static void closeStatement(PreparedStatement pstmt) {
try {
if (pstmt != null){
pstmtclose();
pstmt = null;
}
} catch (Exception e) {
eprintStackTrace();
}
}
}
建立实体类
package Test;
import javautilDate;
public class FirestLevelTitle {
private int id ; // ID
private String titleName; //名称
private String creator ; //创建者
private Date createTime ;//创建时间
public FirestLevelTitle(int id ,String titleName ,String creator,Date createTime){
thisid = id;
thistitleName = titleName;
thiscreator = creator;
thiscreateTime = createTime;
}
public Date getCreateTime() {
return createTime;
}
public void setCreateTime(Date createTime) {
thiscreateTime = createTime;
}
public String getCreator() {
return creator;
}
public void setCreator(String creator) {
thiscreator = creator;
}
public int getId() {
return id;
}
public void setId(int id) {
thisid = id;
}
public String getTitleName() {
return titleName;
}
public void setTitleName(String titleName) {
thistitleName = titleName;
}
}
通过jdbc 访问数据库
package Test;
import javasql;
import javautilArrayList;
import javautilList;
public class FirestLeveTitleDbOpereation {
public List getAllFirestLeveTitleList(){ //返回FirestLevelTitle对象的集合
List list = new ArrayList(); //定义数组
Connection conn = null ;
PreparedStatement pstmt = null ;
ResultSet rs = null ;
try {
conn = ConnectionManagergetConnection(); //建立连接
String sql = "select from FirstLevelTitle order by CreatorTime desc"; //sql语句
pstmt = connprepareStatement(sql); //PreparedStatement 语句
rs = pstmtexecuteQuery(); //查询结果集
while (rsnext()) { //处理结果
int id = rsgetInt("id");
String title = rsgetString("TitleName");
String createw = rsgetString("Creator");
Date time = rsgetDate("CreatorTime");
//把个属性封装到FirestLevelTitle 对象中
FirestLevelTitle fTitle = new FirestLevelTitle(id,title,createw,time);
listadd(fTitle); //添加到集合中
}
} catch (Exception e) {
eprintStackTrace();
}
finally{ //释放资源
ConnectionManagercloseResultSet(rs);
ConnectionManagercloseStatement(pstmt);
ConnectionManagerclossConnection(conn);
}
return list;
}
}
jsp页面
<%@ page language="java" pageEncoding="GBK"
import="javautil ,Test" //添加引用
%>
<html>
<head>
</head>
<body>
<%
FirestLeveTitleDbOpereation first = new FirestLeveTitleDbOpereation();
List list = firstgetAllFirestLeveTitleList();
if (listsize()!=0){
for(int i = 0;i <listsize();i++){ //循环遍历
FirestLevelTitle fTitle = (FirestLevelTitle)listget(i);
%>
<td>
表名是： <%=fTitlegetTitleName()%> <br/>
id是：<%=fTitlegetId() %><br/>
时间是：<%=fTitlegetCreateTime() %><br/>
</td>
<%
}
}
%>
</body>
</html>
datediff(DD,aInhospitalDate,getdate())这个函数取出来的值是int的,
在sql里当varchar与int连接里, 不是这样直接连的,得把int转为varchar
这样写:
select '住了'+ convert(varchar,datediff(DD,aInhospitalDate,getdate()))+'天' from His_InhospitalRegister a
以上就是关于如何根据JSP代码创建SQL数据库全部的内容，包括:如何根据JSP代码创建SQL数据库、数据库中 怎样在字段中添加 常量 或者varchar 怎样转换成Int 型 这是我的语句。。、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）