软件测试(单元测试)
测试系统:河北省重大需求填报系统
测试内容:
注册登录模块，包含注册账号、系统登录,找回密码;
用户管理模块，修改个人资料,更改用户密码,删除用户,用户查询；
征文信息模块, 征文信息填报,征文信息审核,征文信息修改；
统计查询模块, 按类别查询模块,精确查询模块;查询所有征文信息模块
图表展示模块, Json数据展示;
测试工具:
eclipse+junit5
测试方案:
单元测试方案
|
模块功能 |
注册登录模块 |
||
|
现有资源 |
模块1 |
注册账号 |
|
|
模块2 |
登录系统 |
||
|
模块 3 |
找回密码 |
||
|
程序结构 |
功能点 |
涉及的方法 |
|
|
注册帐号 |
方法1：public boolean add(User user) 功能说明：添加用户 参数描述：User use：用户类对象 输出：true 或 false 异常： 流程：输入用户信息 添加数据库 返回注册信息,注册码
|
||
|
登录系统 |
方法1： public boolean checkUserid(String username) 功能说明：验证用户是否存在 参数描述：String username：用户名 输出：true 或 false 异常： 流程：输入用户名 查询数据库 返回布尔值 方法2：public User checkUser(String username,String password,String role) 功能说明：验证密码是否正确 参数描述：String username：用户名 （主键） String password：用户密码 String role: 用户角色 输出：null 或 user类对象信息 异常： 流程：输入用户名,用户密码 用户角色 查询数据库 返回用户信息 |
||
|
找回密码 |
方法1：public boolean Tusal(String username) 功能说明：判断用户是否存在 参数描述：String username：用户名 输出：true 或 false 异常： 流程：输入用户名 查询数据库 返回布尔值 方法2：public boolean Tusalkey(String username,String keyid) 功能说明：判断用户是否正确 参数描述：String username：用户名 String keyid：注册码 输出：true 或 false 异常： 流程：输入用户名和注册码 查询数据库 返回布尔值 方法3：public boolean modifyPassword(String name,String password) 功能说明：找回密码 参数描述：String name：用户名 String password：用户密码 输出：true 或 false 异常： 流程：输入用户名和密码 修改数据库 返回布尔值
|
||
|
测试用例 |
测试功能点 |
用例描述 |
用例测试结果 |
|
注册帐号 |
使用测试程序实现单元测试： public void addtest() { String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + name + "','" + password + "','" + employee + "','" + factoryname +"','" + postal +"','" + premission + "')";"; User user = (User) JSONObject.toBean (JSONObject.fromObject(data), User.class); assertEquals(Ser.add(user), true); }
public void Tusalkeyidtest() { assertEquals(Ser.Tusalkeyid("20183669"), true); assertEquals(Ser.Tusalkeyid("20183788"), false); } |
通过 |
|
|
登录系统 |
方法一：使用测试程序实现单元测试： public void checkuseridtest() { assertEquals(Ser.checkUserid("zzm","123456",inperson"), true); assertEquals(Ser.checkUserid("zzmtest","zzm""admin"), false); }
@Test void testLogin() { //普通用户登录 String id="赵常恒"; String password="123"; String shenfen="inperson"; String sql="select * from user where (username='" + id + "' and password='" + password + "' and employee='"+shenfen+"')"; try { MessageService.login(sql); System.out.println("普通用户,登陆成功"); } catch (Exception e) { System.out.println(e); } //形式审核员登录 sql="select * from user where (username='" + "infor" + "' and password='" + "infor" + "' and employee='"+"inforplace"+"')"; try { if(MessageService.login(sql)>0) { System.out.println("形式审核员,登陆成功"); } } catch (Exception e) { System.out.println(e); } //管理员登录 sql="select * from user where (username='" + "admin" + "' and password='" + "admin" + "' and employee='"+"admin"+"')"; try { if(MessageService.login(sql)>0) { System.out.println("管理员,登陆成功"); } } catch (Exception e) { System.out.println(e); } sql="select * from user where (username='" + "one" + "' and password='" + "one" + "' and employee='"+"business"+"')"; try { if(MessageService.login(sql)>0) { System.out.println("部门审核员,登陆成功"); } } catch (Exception e) { System.out.println(e); } } @Test void testSearch() { //未输入时,全部展示 System.out.println("列表全部查询,List>0"); System.out.println("列表以工作单位查询,List>0"); //普通用户登录 String id="赵常恒"; String password="123"; String shenfen="inperson"; String sql="select * from user where (username='" + id + "' and password='" + password + "' and employee='"+shenfen+"')"; try { MessageService.login(sql);
} catch (Exception e) { System.out.println(e); } //形式审核员登录 sql="select * from user where (username='" + "infor" + "' and password='" + "infor" + "' and employee='"+"inforplace"+"')"; try { if(MessageService.login(sql)>0) {
} } catch (Exception e) { System.out.println(e); } //管理员登录 sql="select * from user where (username='" + "admin" + "' and password='" + "admin" + "' and employee='"+"admin"+"')"; try { if(MessageService.login(sql)>0) {
} } catch (Exception e) { System.out.println(e); } sql="select * from user where (username='" + "one" + "' and password='" + "one" + "' and employee='"+"business"+"')"; try { if(MessageService.login(sql)>0) {
} } catch (Exception e) { System.out.println(e); } } 方法二：使用界面进行单元测试： 进入登录界面，输入【帐号】、【密码】、【角色】，点击【登录】按钮后，将进入用户对应界面，并显示部分信息。 |
通过 |
|
|
找回密码 |
使用测试程序实现单元测试： public void Tusaltest() { assertEquals(Ser.Tusal("1111123"), true); assertEquals(Ser.Tusal("1111126"), false); }
public void Tusalkeytest() { assertEquals(Ser.Tusalkey("zzm666", "zzm666"), true); assertEquals(Ser.Tusalkey("zzm666", "zzm999"), false); }
|
通过 |
|
|
测试结果 |
注册登录模块通过 |
||
|
Username |
Password |
Employee |
Factoryname |
Postal |
premisson |
predict |
Test |
|
123456 |
123456 |
Inperson |
石家庄铁道大学 |
054001 |
0 |
True |
True |
|
11 |
11 |
Inperson |
11 |
11 |
0 |
True |
True |
|
123456 |
123456 |
Inforplace |
石家庄铁道大学 |
054001 |
1 |
False |
False |
|
Zzm |
987654321 |
business |
宿舍 |
12356 |
2 |
False |
True |
|
Zzm666 |
S123456 |
Information |
铁道大学 |
321 |
3 |
False |
True |
|
模块功能 |
用户管理模块 |
||
|
现有资源 |
模块1 |
修改个人资料 |
|
|
模块2 |
更改用户密码 |
||
|
模块3 |
删除用户 |
||
|
模块4 |
用户查询 |
||
|
程序结构 |
功能点 |
涉及的方法 |
|
|
修改个人资料 |
方法1： public boolean updateinfo(User user) 功能说明：修改用户资料 参数描述：User user：用户类对象 输出：true 或 false 异常： 流程：输入用户对象 修改数据库 返回布尔值 |
||
|
更该用户密码 |
方法1：public boolean updatecode(Usermess user) 功能说明：修改用户密码 参数描述： Usermess user：用户对象
输出：true 或 false 异常： 流程：输入Usermess 修改user数据库 返回布尔值 |
||
|
删除用户 |
方法1：public boolean deleteUser(String username,String role) 功能说明：删除宿舍信息 参数描述：String username 用户名 String role 用户角色 主键 role username 输出：true 或 false 异常： 流程：输入username role 删除数据库信息 返回布尔值 |
||
|
用户查询 |
方法1：public List<Usermess> searchinfo(sql) 功能说明：查询用户信息 参数描述：sql 查询语句 输出：返回list数组 异常： 流程：输入sql语句 查询数据库 返回用户信息 |
||
|
测试用例 |
测试功能点 |
用例描述 |
用例测试结果 |
|
修改个人资料 |
使用测试程序实现单元测试： void testUpdateinfo() { Usermess usermess1 = new Usermess(); Usermess usermess2 = new Usermess(); Usermess1.set("123456", "123456", "inperson", "石家庄铁道大学", "054600", "0") ;true Usermess2.set("123456", "123456", "inperson", "铁道大学", "054600", "2") false assertEquals(Ser.updateinfo(usermess1), true); assertEquals(Ser. updateinfo (usermess2), false); } |
通过 |
|
|
更该用户密码 |
使用测试程序实现单元测试： public void testupdatecode() { Usermess usermess1 = new Usermess(); Usermess usermess2 = new Usermess(); Usermess usermess3 = new Usermess(); Usermess1.set("123456", "123456", "inperson") Usermess2.set("123456","123457","inperson") Usermess3.set("123456","123456","admin") assertEquals(Ser.update(Usermess1),true); assertEquals(Ser.update(Usermess2),false); assertEquals(Ser.update(Usermess3),false); } |
通过 |
|
|
删除用户信息 |
使用测试程序实现单元测试： public void testdeleteUser(String username,String role) { Usermess usermess1 = new Usermess(); Usermess usermess2 = new Usermess(); Usermess usermess3 = new Usermess(); Usermess1.set("123456", "inperson") Usermess2.set("zzm666", "bussiness") Usermess3.set("zzm", "admin") assertEquals(Ser. deleteUser (Usermess1),true); assertEquals(Ser. deleteUser (Usermess2),false); assertEquals(Ser. deleteUser (Usermess3),false); } |
通过 |
|
|
查询用户 |
方法一：使用测试程序实现单元测试： public void testsearchinfo () { //testcase sql String sql ="select * from user" try { List<Usermess> list= MessageService. searchinfo (sql); //list转Json JSONArray Js = JSONArray.fromObject(echartslist); System.out.println(Js); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } 方法二：使用界面进行单元测试： 管理员进入用户信息界面，输入要查询的信息，点击【搜索】按钮后，显示用户详细信息 |
|
|
|
测试结果 |
用户管理模块通过 |
||
|
模块功能 |
征文信息模块 |
||
|
现有资源 |
模块1 |
征文信息填报 |
|
|
模块2 |
修改个人信息 |
||
|
程序结构 |
功能点 |
涉及的方法 |
|
|
征文信息填报 |
方法1：private boolean addinformation (sql) 功能说明：征文信息填报 参数描述：sql :sql语句 页面参数 输出：true 或 false 异常： 流程：输入sql 增添需求信息 返回布尔值
|
||
|
征文信息审核 |
方法1：public boolean aboutmine(Userinfo userinfo) 功能说明：修改个人资料 参数描述：Userinfo userinfo：用户信息类对象 输出：true 或 false 异常： 流程：输入用户信息 修改数据库 返回布尔值 |
||
|
|
征文信息修改 |
|
|
|
测试用例 |
测试功能点 |
用例描述 |
用例测试结果 |
|
征文信息填报 |
使用测试程序实现单元测试，例如：
|
通过 |
|
|
征文信息审核 |
使用测试程序实现单元测试； @Test //通过修改状态位来改变征文信息状态,默认为0,形式审核为1,部门审核为3, void voidStatuscheck() { String[] status=new String[] { "0","1","3"}; //id=531 文件ID 正确测试 最终status=3 int id=531; //普通转形式审核 True String sql1 = "update information set status='" + status[1] + "' where id='" + id + "'"; //形式转部门 True String sql2 = "update information set status='" + status[2] + "' where id='" + id + "'";
if (MessageService.update(sql1)) { System.out.println("形式审核通过"); if (MessageService.update(sql2)) { System.out.println("部门审核通过"); }else { System.out.println("部门审核未通过"); } }else { System.out.println("形式审核未通过"); }
} |
通过 |
|
|
|
征文信息修改 |
//征文信息修改 //变化数值,email,phone comaddress void testUpdateinfo() { String[] test1 =new String[] { "石家庄铁道大学","河北省石家庄市","www.website.com","3176080045@qq.com","赵常恒","054600","1356942","19930502297","starr","河北","text","techname" String[] test2 =new String[] { "石家庄铁道大学","河北省铁道大学","www.website.com","www.baidu.com","赵常恒","054600","1356942","15028884162","starr","河北","text","techname"
}; String sql = "insert into information(companyname,comaddress,comwebsite,email,lawperson,postal,contacts,phone,fax" + ",insattr,belongcom,summary,techname,techchat,discuss,subject,domain,vocation," + "togemodern,togecom,status,money,belongarea,totime,telphone,keyword) " + "values('" + companyname + "','" + comaddress+ "','" + comwebsite + "','" + email +"','" + lawperson +
"','" + postal +"','" + contacts +"','" + phone +"','" + fax +"','" + insattr +"','" + belongcom +"','" + summary +"','" + techname + "','" + techchat +"','" + discuss +"','" + subject +"','" + domain +"','" + vocation +"','" + togemodern +"','" + togecom +"','" + status + keyword +"')"; try { if(MessageService.update(sql)) { System.out.println("征文信息修改成功"); System.out.println(); } } catch (Exception e) { System.out.println(e); }
if(MessageService.update(sql)) { System.out.println("征文信息修改成功"); System.out.println(); } } catch (Exception e) { System.out.println(e); } |
通过 |
|
测试结果 |
征文信息模块测试通过 |
||
|
模块功能 |
统计查询模块 |
||
|
程序结构 |
功能点 |
涉及的方法 |
|
|
按类别查询 |
方法1：public static List<Area> getarea(String sql) 功能说明：按类别查询 并转换为JSONG格式 参数描述：String sql sql 查询语句 输出：Json查询 异常： 流程：输入sql 查询数据库 返回类别数据 方法2:页面测试 |
||
|
|
精确查询模块 |
采用页面测试,后台代码同类别测试相似 |
|
|
|
查询所有征文信息模块 |
方法1：public static userInfo searchinfo(String sql) 功能说明:查询所有征集信息模块 参数描述: String sql 查询语句 异常: 流程：输入sql 查询数据库 返回征文信息数据 方法2:页面测试 |
|
|
测试用例 |
测试功能点 |
用例描述 |
用例测试结果 |
|
类别查询 |
方法1: String information="techchat"; String sql="select "+information+" as leibie,count(*) as num from information group by "+information+" "; try { List<echarts> echartslist= MessageService.getechartsdata(sql); //list转Json JSONArray Js = JSONArray.fromObject(echartslist); System.out.println(Js); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } 输出效果: [{"areaname":"石家庄市","code":"130100"},{"areaname":"唐山市","code":"130200"},{"areaname":"秦皇岛市","code":"130300"},{"areaname":"邯郸市","code":"130400"},{"areaname":"邢台市","code":"130500"},{"areaname":"保定市","code":"130600"},{"areaname":"张家口市","code":"130700"},{"areaname":"承德市","code":"130800"} 使用界面进行单元测试： 进入搜索查询界面输入要查询的信息，选择输入【地域】，，点击【搜索】按钮后，浏览界面能正确的显示所有满足名称模糊查询条件的结果信息；
|
通过 |
|
|
|
精确查询模块 |
进入搜索查询界面输入要查询的信息，选择输入【地域】，【时间】,【公司】,【法人】，，点击【搜索】按钮后，浏览界面能正确的显示所有满足名称查询条件的结果信息；
|
通过 |
|
|
查询所有征文信息模块 |
代码测试: String sql="select * from information"; 返回数据转换为Json格式
|
通过 |
|
测试结果 |
统计查询模块通过 |
||
|
模块功能 |
图表展示模块 |
||
|
程序结构 |
功能点 |
涉及的方法 |
|
|
Json数据展示 |
方法1：public static List<echarts> getechartsdata(String sql) 功能说明：类别查询 并转换为JSONG格式 参数描述：String sql sql 查询语句 输出：Json数据 异常： 流程：输入sql 查询数据库 返回类别数据 方法2:页面测试 |
||
|
测试用例 |
测试功能点 |
用例描述 |
用例测试结果 |
|
Json数据展示 |
方法1: String information="comaddress" ; String information2="tomcat" String sql="select "+information+" as leibie,count(*) as num from information group by "+information+" "; try { List<echarts> echartslist= MessageService.getechartsdata(sql); //list转Json JSONArray Js = JSONArray.fromObject(echartslist); System.out.println(Js); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } 输出部分展示: [{"areaname":"石家庄市","code":"130100"},{"areaname":"唐山市","code":"130200"},{"areaname":"秦皇岛市","code":"130300"},{"areaname":"邯郸市","code":"130400"},{"areaname":"邢台市","code":"130500"},{"areaname":"保定市","code":"130600"},{"areaname":"张家口市","code":"130700"},{"areaname":"承德市","code":"130800"}
{"leibie":"北京市丰台区南大红门路1号","num":1},{"leibie":"北京市东城区王府井帅府园1号","num":2},{"leibie":"北京市海淀区交大东路66号院钻河中心1号楼2层233室",号",num":京市海淀区上地四街9号四方大厦","num":1},{"leibie":"北京市海淀区中关村南三街16号D座812号","num":1},{"leibie":"北京市北三环东路18号","num":1},{"leibie":"石铁大","num":1}]
使用界面进行单元测试： 进入搜索查询界面输入要查询的信息，选择输入【地域】，，点击【搜索】按钮后，浏览界面能正确的显示所有满足名称模糊查询条件的结果信息；
|
通过 |
|
|
测试结果 |
图表展示模块通过 |
||
测试代码:
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
package com.service;
import static org.junit.jupiter.api.Assertions.*;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.mysql.cj.protocol.Message;
import User.Alldata;
import User.echarts;
import User.userInfo;
import User.xsdate;
class MessageServiceTest {
@Test
//注册测试
void testAdd() {
System.out.println("Register Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "insert into user(username,password,employee,factoryname,postal,premission) values('" + a[i][0] + "','" + a[i][1]
+ "','" + a[i][2] + "','" + a[i][3] +"','" + a[i][4] +"','" + a[i][5] + "')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" factor:"+a[i][3]+" postal:"+a[0][4]+" permession:"+a[0][5]+" Return:"+MessageService.add(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" factor:"+"none"+" postal:"+"none"+" permession:"+"none"+" Return:"+MessageService.add(sql));
}
@Test
//登录测试
void testLogin() {
//
String[][] a= {{"赵常恒","123456","inperson"},{"zzm","zzm9251","inperson"},{"zchzzm","waod3n","inpersion"},{"infor","infor","inforplace"}
,{"admin","admin","admin"},{"one","one","business"},{"121112","1212","inpersion"},{"error","error","someone"}
};
System.out.println("Login Test Case:");
for(int i=0;i<a.length;i++) {
String sql="select * from user where (username='" + a[i][0] + "' and password='" +a[i][1]+ "' and employee='"+a[i][1]+"')";
System.out.println("username:"+a[i][0]+" password:"+a[i][1]+" vertify:"+a[i][2]+" Return:"+MessageService.login(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" password:"+"none"+" vertify:"+"none"+" Return:"+MessageService.login(sql));
}
@Test
void testDelete() {
System.out.println("Delete Test Case:");
String[][] a= {{"赵常恒","123456","inperson","factor1","054600","0"},{"zzm","zzm9251","inperson","factor2","054600","0"},{"zchzzm","waod3n","inpersion","factor3","054600","0"},{"infor","infor","inforplace","factor4","054600","0"}
,{"admin","admin","admin","factor5","054600","0"},{"one","one","business","factor6","054600","0"},{"121112","1212","inpersion","factor7","054600","0"},{"error","error","someone","factor8","054600","0"},{"赵常恒","123456","inperson","factor1","054600","0"}
};
for(int i=0;i<a.length;i++) {
String sql = "delete from user where username='"+a[i][0]+"'and employee='"+a[i][2]+"'";
System.out.println("username:"+a[i][0]+" vertify:"+a[i][2]+" Return:"+MessageService.delete(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" vertify:"+"none"+" Return:"+MessageService.delete(sql));
}
@Test
//业务测试
void testGetalldate() throws SQLException {
List<Alldata> lst = new ArrayList<Alldata>();
String[][] sql= {{"select * from alldate"},{"select * from alldate where id='"+1+"'"},
{"select * from alldate where id='"+2+"'"},{"select * from alldate where id='"+3+"'"}
,{"selec A from alldate" }};
System.out.println("YeWu Test Case");
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getalldate(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getalldate(sql1));
}
//二层产业测试
@Test
void testGetxsdate() throws SQLException {
List<xsdate> lst = new ArrayList<xsdate>();
String[] xtypeid= {"1","2","3","4","5"};
System.out.println("Factory Test Case");
for(int i=0;i<xtypeid.length;i++) {
String sql="select * from xsdate where xtypeid='"+Integer.parseInt(xtypeid[i])+"'";
System.out.println("xtypeid"+xtypeid[i]+" Return:"+MessageService.getalldate(sql));
MessageService.getxsdate(sql);
}
String sql="xxx";
System.out.println("xtypeid"+"none"+" Return:"+MessageService.getalldate(sql));
}
//图表数据测试
@Test
void testGetechartsdata() throws SQLException {
List<echarts> lst = new ArrayList<echarts>();
System.out.println("Echarts Test Case");
String[] information= {"comaddress","companyname","discuss","voation","test"};
for(int i=0;i<information.length;i++) {
String sql="select "+information[i]+" as leibie,count(*) as num from information group by "+information[i]+" ";
System.out.println("类别:"+information[i]+" Return:"+MessageService.getechartsdata(sql));
}
String sql="xxx";
System.out.println("类别:"+"none"+" Return:"+MessageService.getechartsdata(sql));
}
@Test
//页面分类查询测试
void testGetlayuiinfonum() throws SQLException {
System.out.println("Layui Num Test Case");
String[][] test= {{"companyname","天津科技大学"},{"comaddress","天津市河西区大沽南路1038号"},{"insattr","高等院校"},{"insattr","测试"}};
for(int i=0;i<test.length;i++) {
String sql="select count(*) as num from information where "+test[i][0]+" like '"+test[i][1]+"' ";
System.out.println("Key: "+test[i][0]+" content:"+test[i][1]+" Return:"+MessageService.getlayuiinfonum(sql));
}
String sql="xxx";
System.out.println("Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfonum(sql));
}
@Test
void testGetuserpremission() throws SQLException {
System.out.println("Permission Test Case");
String[][] test= {{"infor","inforplace"},{"admin","admin"},{"one","business"},{"123456","inperson"},{"noexist","noexist"}};
for(int i=0;i<test.length;i++) {
String sql="select premission from user where username='"+test[i][0]+"'employee='"+test[i][1]+"'";
System.out.println("username:"+test[i][0]+" emplyee:"+test[i][1]+" Return:"+MessageService.getuserpremission(sql));
}
String sql="xxx";
System.out.println("username:"+"none"+" emplyee:"+"none"+" Return:"+MessageService.getuserpremission(sql));
}
@Test
void testGetlayuiinfo() throws NumberFormatException, SQLException {
System.out.println("LayuiInfo Test Case");
String[][] test= {{"1","companyname","天津科技大学"},{"1","comaddress","天津市河西区大沽南路1038号"},{"1","insattr","高等院校"},{"1","insattr","测试"},
{"2","companyname","天津科技大学"},{"3","comaddress","天津市河西区大沽南路1038号"},{"4","insattr","高等院校"}};
for(int i=0;i<test.length;i++) {
String sql="select * from information where "+test[i][1]+" like '"+test[i][2]+"' ";
System.out.println("page:"+test[i][0]+" Key: "+test[i][1]+" content:"+test[i][2]+" Return:"+MessageService.getlayuiinfo(Integer.parseInt(test[i][0]), 20, sql));
}
String sql="xxx";
System.out.println("page:"+"none"+" Key: "+"none"+" content:"+"none"+" Return:"+MessageService.getlayuiinfo(1, 20, sql));
}
@Test
void testGetmessage() throws SQLException {
System.out.println("DemandInfo Test Case");
List<userInfo> lst = new ArrayList<userInfo>();
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"select A from information" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getmessage(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getmessage(sql1));
}
@Test
//征文信息状态修改
void testUpdate() {
String[] status=new String[] {
"0","1","3"};
//id=531 文件ID 正确测试 最终status=3
int id=531;
//普通转形式审核 True
String sql1 = "update information set status='" + status[1] + "' where id='" + id
+ "'";
//形式转部门 True
String sql2 = "update information set status='" + status[2] + "' where id='" + id
+ "'";
if (MessageService.update(sql1)) {
System.out.println("形式审核通过");
if (MessageService.update(sql2)) {
System.out.println("部门审核通过");
}
}
}
@Test
//信息查询
void testSearchinfo() {
System.out.println("DemandSearchInfo Test Case");
String[][] sql= {{"select * from information"},{"select * from information where id='"+1+"'"},
{"select * from information where id='"+99+"'"},{"select * from information where id='"+134+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchinfo(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchinfo(sql1));
}
@Test
//用户查询
void testSearchmess() {
System.out.println("UserSearchInfo Test Case");
String[][] sql= {{"select * from user"},{"select * from user where id='"+1+"'"},
{"select * from user where id='"+99+"'"},{"select * from user where id='"+5+"'"}
,{"selec A from alldate" }};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.searchmess(sql[i][0]));
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.searchmess(sql1));
}
@Test
//地域查询
void testGetarea() throws SQLException {
System.out.println("Area Test Case");
int [] j= {1};
String[][] sql= {{"select * from area"},{"select areaname from area where code='"+130100+"'"},
{"select * from area where id='"+10+"'"},{"selec A from alldate" },{"select * from area where id='"+j[0]+"'"}
};
for(int i=0;i<sql.length;i++) {
System.out.println("测试语句"+sql[i][0]+" Return:"+MessageService.getarea(sql[i][0]));
}
for(int i=0;i<j.length;i++) {
System.out.println("测试语句"+sql[4][0]+" Return:"+MessageService.getarea(sql[i][0]));
j[0]++;
}
String sql1="xxx";
System.out.println("测试语句"+sql1+" Return:"+MessageService.getarea(sql1));
}
}
浙公网安备 33010602011771号