Skip to content

Commit 8c2040a

Browse files
author
javaage
committed
mybatis
1 parent 966ea0e commit 8c2040a

File tree

71 files changed

+7193
-3465
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

71 files changed

+7193
-3465
lines changed

‎flexible/postgres.zip‎

15.5 MB
Binary file not shown.

‎flexible/postgres/src/main/java/com/cisco/la/CourseHistoryServlet.java‎

Lines changed: 78 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,78 @@
1+
/**
2+
* Copyright 2017 Google Inc.
3+
*
4+
* Licensed under the Apache License, Version 2.0 (the "License");
5+
* you may not use this file except in compliance with the License.
6+
* You may obtain a copy of the License at
7+
*
8+
* http://www.apache.org/licenses/LICENSE-2.0
9+
*
10+
* Unless required by applicable law or agreed to in writing, software
11+
* distributed under the License is distributed on an "AS IS" BASIS,
12+
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13+
* See the License for the specific language governing permissions and
14+
* limitations under the License.
15+
*/
16+
17+
package com.cisco.la;
18+
19+
import com.cisco.la.util.MyBatisUtil;
20+
import com.google.common.base.Stopwatch;
21+
22+
import java.io.IOException;
23+
import java.io.InputStream;
24+
import java.io.InputStreamReader;
25+
import java.io.PrintWriter;
26+
import java.net.Inet4Address;
27+
import java.net.Inet6Address;
28+
import java.net.InetAddress;
29+
import java.sql.Connection;
30+
import java.sql.DriverManager;
31+
import java.sql.PreparedStatement;
32+
import java.sql.ResultSet;
33+
import java.sql.SQLException;
34+
import java.sql.Timestamp;
35+
import java.util.Date;
36+
import java.util.Properties;
37+
import java.util.concurrent.TimeUnit;
38+
import java.io.Reader;
39+
40+
import javax.servlet.ServletException;
41+
import javax.servlet.annotation.WebServlet;
42+
import javax.servlet.http.HttpServlet;
43+
import javax.servlet.http.HttpServletRequest;
44+
import javax.servlet.http.HttpServletResponse;
45+
46+
import org.apache.ibatis.io.Resources;
47+
import org.apache.ibatis.session.SqlSession;
48+
import org.apache.ibatis.session.SqlSessionFactory;
49+
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
50+
import com.cisco.la.mapper.RoleHistoryModelMapper;
51+
import com.cisco.la.model.RoleHistoryModel;
52+
53+
// [START example]
54+
@SuppressWarnings("serial")
55+
@WebServlet(name = "coursehistory", value = "")
56+
public class CourseHistoryServlet extends HttpServlet {
57+
Connection conn;
58+
59+
@Override
60+
public void doGet(HttpServletRequest req, HttpServletResponse resp){
61+
62+
}
63+
64+
@Override
65+
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
66+
super.doPost(req, resp);
67+
}
68+
69+
@Override
70+
protected void doPut(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
71+
super.doPut(req, resp);
72+
}
73+
74+
@Override
75+
protected void doDelete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
76+
super.doDelete(req, resp);
77+
}
78+
}

‎flexible/postgres/src/main/java/com/cisco/la/CourseServlet.java‎

Lines changed: 92 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,92 @@
1+
/**
2+
* Copyright 2017 Google Inc.
3+
*
4+
* Licensed under the Apache License, Version 2.0 (the "License");
5+
* you may not use this file except in compliance with the License.
6+
* You may obtain a copy of the License at
7+
*
8+
* http://www.apache.org/licenses/LICENSE-2.0
9+
*
10+
* Unless required by applicable law or agreed to in writing, software
11+
* distributed under the License is distributed on an "AS IS" BASIS,
12+
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13+
* See the License for the specific language governing permissions and
14+
* limitations under the License.
15+
*/
16+
17+
package com.cisco.la;
18+
19+
import com.cisco.la.util.MyBatisUtil;
20+
import com.google.common.base.Stopwatch;
21+
22+
import java.io.IOException;
23+
import java.io.InputStream;
24+
import java.io.InputStreamReader;
25+
import java.io.PrintWriter;
26+
import java.net.Inet4Address;
27+
import java.net.Inet6Address;
28+
import java.net.InetAddress;
29+
import java.sql.Connection;
30+
import java.sql.DriverManager;
31+
import java.sql.PreparedStatement;
32+
import java.sql.ResultSet;
33+
import java.sql.SQLException;
34+
import java.sql.Timestamp;
35+
import java.util.Date;
36+
import java.util.Properties;
37+
import java.util.concurrent.TimeUnit;
38+
import java.io.Reader;
39+
40+
import javax.servlet.ServletException;
41+
import javax.servlet.annotation.WebServlet;
42+
import javax.servlet.http.HttpServlet;
43+
import javax.servlet.http.HttpServletRequest;
44+
import javax.servlet.http.HttpServletResponse;
45+
46+
import org.apache.ibatis.io.Resources;
47+
import org.apache.ibatis.session.SqlSession;
48+
import org.apache.ibatis.session.SqlSessionFactory;
49+
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
50+
import com.cisco.la.mapper.RoleHistoryModelMapper;
51+
import com.cisco.la.model.RoleHistoryModel;
52+
53+
// [START example]
54+
@SuppressWarnings("serial")
55+
@WebServlet(name = "course", value = "")
56+
public class CourseServlet extends HttpServlet {
57+
Connection conn;
58+
59+
@Override
60+
public void doGet(HttpServletRequest req, HttpServletResponse resp){
61+
try {
62+
PrintWriter out = resp.getWriter();
63+
resp.setContentType("text/plain");
64+
out.println("connecting to: ");
65+
66+
Reader reader = new InputStreamReader(getServletContext().getResourceAsStream("/WEB-INF/classes/mybatis-config.xml"));
67+
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
68+
SqlSessionFactory sqlSessionFactory = builder.build(reader);
69+
SqlSession sqlSession = sqlSessionFactory.openSession();
70+
71+
RoleHistoryModelMapper laRlHistoryDao = sqlSession.getMapper(RoleHistoryModelMapper.class);
72+
out.println("end4");
73+
RoleHistoryModel roleHistoryModel = new RoleHistoryModel();
74+
roleHistoryModel.setRoleHistory("test2");
75+
roleHistoryModel.setRoleName("test2");
76+
roleHistoryModel.setUpdateTime(new Date());
77+
roleHistoryModel.setUserID("test2");
78+
79+
laRlHistoryDao.insert(roleHistoryModel);
80+
out.println("end123");
81+
sqlSession.commit();
82+
} catch (IOException e1) {
83+
try{
84+
PrintWriter out = resp.getWriter();
85+
resp.setContentType("text/plain");
86+
out.println(e1.getMessage());
87+
}catch (IOException e) {
88+
89+
}
90+
}
91+
}
92+
}

‎flexible/postgres/src/main/java/com/cisco/la/GoldenSampleServlet.java‎

Lines changed: 92 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,92 @@
1+
/**
2+
* Copyright 2017 Google Inc.
3+
*
4+
* Licensed under the Apache License, Version 2.0 (the "License");
5+
* you may not use this file except in compliance with the License.
6+
* You may obtain a copy of the License at
7+
*
8+
* http://www.apache.org/licenses/LICENSE-2.0
9+
*
10+
* Unless required by applicable law or agreed to in writing, software
11+
* distributed under the License is distributed on an "AS IS" BASIS,
12+
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13+
* See the License for the specific language governing permissions and
14+
* limitations under the License.
15+
*/
16+
17+
package com.cisco.la;
18+
19+
import com.cisco.la.util.MyBatisUtil;
20+
import com.google.common.base.Stopwatch;
21+
22+
import java.io.IOException;
23+
import java.io.InputStream;
24+
import java.io.InputStreamReader;
25+
import java.io.PrintWriter;
26+
import java.net.Inet4Address;
27+
import java.net.Inet6Address;
28+
import java.net.InetAddress;
29+
import java.sql.Connection;
30+
import java.sql.DriverManager;
31+
import java.sql.PreparedStatement;
32+
import java.sql.ResultSet;
33+
import java.sql.SQLException;
34+
import java.sql.Timestamp;
35+
import java.util.Date;
36+
import java.util.Properties;
37+
import java.util.concurrent.TimeUnit;
38+
import java.io.Reader;
39+
40+
import javax.servlet.ServletException;
41+
import javax.servlet.annotation.WebServlet;
42+
import javax.servlet.http.HttpServlet;
43+
import javax.servlet.http.HttpServletRequest;
44+
import javax.servlet.http.HttpServletResponse;
45+
46+
import org.apache.ibatis.io.Resources;
47+
import org.apache.ibatis.session.SqlSession;
48+
import org.apache.ibatis.session.SqlSessionFactory;
49+
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
50+
import com.cisco.la.mapper.RoleHistoryModelMapper;
51+
import com.cisco.la.model.RoleHistoryModel;
52+
53+
// [START example]
54+
@SuppressWarnings("serial")
55+
@WebServlet(name = "goldensample", value = "")
56+
public class GoldenSampleServlet extends HttpServlet {
57+
Connection conn;
58+
59+
@Override
60+
public void doGet(HttpServletRequest req, HttpServletResponse resp){
61+
try {
62+
PrintWriter out = resp.getWriter();
63+
resp.setContentType("text/plain");
64+
out.println("connecting to: ");
65+
66+
Reader reader = new InputStreamReader(getServletContext().getResourceAsStream("/WEB-INF/classes/mybatis-config.xml"));
67+
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
68+
SqlSessionFactory sqlSessionFactory = builder.build(reader);
69+
SqlSession sqlSession = sqlSessionFactory.openSession();
70+
71+
RoleHistoryModelMapper laRlHistoryDao = sqlSession.getMapper(RoleHistoryModelMapper.class);
72+
out.println("end4");
73+
RoleHistoryModel roleHistoryModel = new RoleHistoryModel();
74+
roleHistoryModel.setRoleHistory("test2");
75+
roleHistoryModel.setRoleName("test2");
76+
roleHistoryModel.setUpdateTime(new Date());
77+
roleHistoryModel.setUserID("test2");
78+
79+
laRlHistoryDao.insert(roleHistoryModel);
80+
out.println("end123");
81+
sqlSession.commit();
82+
} catch (IOException e1) {
83+
try{
84+
PrintWriter out = resp.getWriter();
85+
resp.setContentType("text/plain");
86+
out.println(e1.getMessage());
87+
}catch (IOException e) {
88+
89+
}
90+
}
91+
}
92+
}

‎flexible/postgres/src/main/java/com/cisco/la/RoleHistoryServlet.java‎

Lines changed: 92 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,92 @@
1+
/**
2+
* Copyright 2017 Google Inc.
3+
*
4+
* Licensed under the Apache License, Version 2.0 (the "License");
5+
* you may not use this file except in compliance with the License.
6+
* You may obtain a copy of the License at
7+
*
8+
* http://www.apache.org/licenses/LICENSE-2.0
9+
*
10+
* Unless required by applicable law or agreed to in writing, software
11+
* distributed under the License is distributed on an "AS IS" BASIS,
12+
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13+
* See the License for the specific language governing permissions and
14+
* limitations under the License.
15+
*/
16+
17+
package com.cisco.la;
18+
19+
import com.cisco.la.util.MyBatisUtil;
20+
import com.google.common.base.Stopwatch;
21+
22+
import java.io.IOException;
23+
import java.io.InputStream;
24+
import java.io.InputStreamReader;
25+
import java.io.PrintWriter;
26+
import java.net.Inet4Address;
27+
import java.net.Inet6Address;
28+
import java.net.InetAddress;
29+
import java.sql.Connection;
30+
import java.sql.DriverManager;
31+
import java.sql.PreparedStatement;
32+
import java.sql.ResultSet;
33+
import java.sql.SQLException;
34+
import java.sql.Timestamp;
35+
import java.util.Date;
36+
import java.util.Properties;
37+
import java.util.concurrent.TimeUnit;
38+
import java.io.Reader;
39+
40+
import javax.servlet.ServletException;
41+
import javax.servlet.annotation.WebServlet;
42+
import javax.servlet.http.HttpServlet;
43+
import javax.servlet.http.HttpServletRequest;
44+
import javax.servlet.http.HttpServletResponse;
45+
46+
import org.apache.ibatis.io.Resources;
47+
import org.apache.ibatis.session.SqlSession;
48+
import org.apache.ibatis.session.SqlSessionFactory;
49+
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
50+
import com.cisco.la.mapper.RoleHistoryModelMapper;
51+
import com.cisco.la.model.RoleHistoryModel;
52+
53+
// [START example]
54+
@SuppressWarnings("serial")
55+
@WebServlet(name = "rolehistory", value = "")
56+
public class RoleHistoryServlet extends HttpServlet {
57+
Connection conn;
58+
59+
@Override
60+
public void doGet(HttpServletRequest req, HttpServletResponse resp){
61+
try {
62+
PrintWriter out = resp.getWriter();
63+
resp.setContentType("text/plain");
64+
out.println("connecting to: ");
65+
66+
Reader reader = new InputStreamReader(getServletContext().getResourceAsStream("/WEB-INF/classes/mybatis-config.xml"));
67+
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
68+
SqlSessionFactory sqlSessionFactory = builder.build(reader);
69+
SqlSession sqlSession = sqlSessionFactory.openSession();
70+
71+
RoleHistoryModelMapper laRlHistoryDao = sqlSession.getMapper(RoleHistoryModelMapper.class);
72+
out.println("end4");
73+
RoleHistoryModel roleHistoryModel = new RoleHistoryModel();
74+
roleHistoryModel.setRoleHistory("test2");
75+
roleHistoryModel.setRoleName("test2");
76+
roleHistoryModel.setUpdateTime(new Date());
77+
roleHistoryModel.setUserID("test2");
78+
79+
laRlHistoryDao.insert(roleHistoryModel);
80+
out.println("end123");
81+
sqlSession.commit();
82+
} catch (IOException e1) {
83+
try{
84+
PrintWriter out = resp.getWriter();
85+
resp.setContentType("text/plain");
86+
out.println(e1.getMessage());
87+
}catch (IOException e) {
88+
89+
}
90+
}
91+
}
92+
}

0 commit comments

Comments
 (0)