• 大小: 5.13MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-09-17
  • 语言: Java
  • 标签: freemarker  模板  

资源简介

最近在做一个出卷系统,需要通过试卷模板从数据库中抽取题目,然后按照模板的样式生成完整的试卷,包括试卷格式的排版和图片的写入。这是用freemarker模板生成word文档。里面包括完整代码和所需jar包。

资源截图

代码片段和文件信息

package test2;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class conDao {

public Connection conn = null; // 声明Connection对象的实例
public Statement stmt = null; // 声明Statement对象的实例
public  ResultSet rs = null; // 声明ResultSet对象的实例
private static String propFileName = “connDB.properties“; // 指定资源文件保存的位置
private static Properties prop = new Properties(); // 创建并实例化Properties对象的实例
private static String dbClassName = “com.mysql.jdbc.Driver“  ;//定义保存数据库驱动的变量
private static String dbUrl= “jdbc:mysql://localhost:3306/exam_system“ ;
private static String dbUser = “root“;
private static String dbPwd = “123456“;
    public conDao() {
    
    
    }
public static  Connection getConnection() {
Connection conn = null;
try {
Class.forName(“com.mysql.jdbc.Driver“).newInstance();
conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/exam_system“ “root“ “123456“);
System.out.println(“suceess!“);
} catch (Exception ee) {
ee.printStackTrace();
}
if (conn == null) {
System.err
.println(“警告: DbConnectionManager.getConnection() 获得数据库链接失败.\r\n\r\n链接类型:“
+ dbClassName
+ “\r\n链接位置:“
+ dbUrl
+ “\r\n用户/密码“
+ dbUser + “/“ + dbPwd);
}
return conn;
}

/*
 * 功能:执行查询语句
 */
public  ResultSet executeQuery(String sql) {
try { // 捕捉异常
conn = getConnection(); // 调用getConnection()方法构造Connection对象的一个实例conn
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println(ex.getMessage()); // 输出异常信息
}
return rs; // 返回结果集对象
}

public static void main(String[] args) {  
        getConnection();
        System.out.println(“success“);

    }  
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        982  2018-10-27 10:04  freemarker2word\JavaToWord - 副本\.classpath

     文件        386  2018-10-17 09:00  freemarker2word\JavaToWord - 副本\.project

     文件       7872  2018-10-17 09:33  freemarker2word\JavaToWord - 副本\.settings\org.eclipse.jdt.core.prefs

     文件       2607  2018-11-28 07:57  freemarker2word\JavaToWord - 副本\bin\test2\conDao.class

     文件       1662  2018-11-28 07:57  freemarker2word\JavaToWord - 副本\bin\test2\question.class

     文件      10164  2019-01-18 15:23  freemarker2word\JavaToWord - 副本\bin\test2\WordTest.class

     文件       7915  2019-01-18 15:23  freemarker2word\JavaToWord - 副本\bin\test2\WordTest1.class

     文件        112  2018-10-26 15:52  freemarker2word\JavaToWord - 副本\connDB.properties

     文件    1007505  2018-10-26 16:59  freemarker2word\JavaToWord - 副本\mysql-connector-java-5.1.47-bin.jar

     文件       2100  2018-10-26 21:21  freemarker2word\JavaToWord - 副本\src\test2\conDao.java

     文件       1071  2018-10-26 17:21  freemarker2word\JavaToWord - 副本\src\test2\question.java

     文件      10765  2019-01-18 15:23  freemarker2word\JavaToWord - 副本\src\test2\WordTest.java

     文件       7487  2019-01-18 15:23  freemarker2word\JavaToWord - 副本\src\test2\WordTest1.java

     文件       2025  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\index.html

     文件      81921  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\alphaidx.html

     文件      42701  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\allclasses-frame.html

     文件      37281  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\allclasses-noframe.html

     文件     193579  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\constant-values.html

     文件      51845  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\deprecated-list.html

     文件      10180  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\AndMatcher.html

     文件      28518  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\ByteArrayTemplateLoader.html

     文件      10679  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\CacheStorage.html

     文件       9739  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\CacheStorageWithGetSize.html

     文件       4404  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\AndMatcher.html

     文件       4547  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ByteArrayTemplateLoader.html

     文件      19312  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\CacheStorage.html

     文件       7841  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\CacheStorageWithGetSize.html

     文件       4503  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ClassTemplateLoader.html

     文件       7459  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ConcurrentCacheStorage.html

     文件       4723  2018-03-31 05:10  freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ConditionalTemplateConfigurationFactory.html

............此处省略860个文件信息

评论

共有 条评论