300字范文 > [java面试]宇信易诚广州分公司 java笔试题目回顾录

[java面试]宇信易诚广州分公司 java笔试题目回顾录

时间：2024-04-29 01:12:03

本文地址：/sushengmiyan/article/details/28479895

作者：sushengmiyan

-------------------------

题目1.数据库相关

1.报文格式定义例如以下：

20字符长的姓名+1字符长的性别+3字符长的年龄

姓名长度不足20的右边补空格性别中0表示男，1表示女

年龄不足3字符的左边补0

如：

denny 0026

这一段报文解析后表示姓名为denny性别为男，年龄为26

数据库表结构例如以下：

create table test

(

name varchar(20) primary key,

sex varchar(1),

age varchar(3)

);

java

一，写一个方法

public String makePackage(String name, int sex, int age);

由输入的姓名，性别。年龄返回相应的报文

二、写一个方法

public void parserPackage(String package);

由输入的报文，解析后写入数据库表test中.

sql

从test中取出年龄大于16岁的前10条记录

从test中取出给定name的记录的sex,age以及按年龄排的名次

题目2javascript相关

页面例如以下

<html><body><input id="package" type = "text"/><input type="button" οnclick="parse()"/><input id="name" type="text"/><input id="sex" type="text"/><input id="age" type="text"/></body></html>

用javascript 实现方法parser() 当点击button的时候，依照报文格式解析id为package的文本域的内容，并将解析完的结果写入到对应的id的文本域里。

题目3css相关

用css给上面的button加上背景图片

web

请求页面例如以下：

<html>

<body>

</form>

</body>

</html>

写一个servlet调用parsePackage方法将请求页面表单域中的package的值解析并写入数据库。将此servlet配置到tomcat中

-----------------------------

答案

java答案例如以下：</p><pre code_snippet_id="376946" snippet_file_name="blog_0604_2_2610834" name="code" class="javascript">import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class YuchengFacetoFace {//报文格式定义例如以下：//20字符长的姓名+1字符长的性别+3字符长的年龄//姓名长度不足20的右边补空格性别中0表示男，1表示女//年龄不足3字符的左边补0//如：//denny0026//这一段报文解析后表示姓名为denny性别为男，年龄为26public String makePackage(String name, int sex, int age){//输入的合法性校验未做String Result = "";int length = name.length();if (length < 20){int cutLength = 20 - length;for (int i = 0; i < cutLength; i++) {Result += " ";}Result += name;}Result += sex;//099的情况呢？if (age < 10) {Result = Result + 0 + 0 + age;}elseif (age < 100) {Result = Result + 0 + age;}else{Result += age;}return Result;}//由输入的报文，解析后写入数据库表test中.public void parserPackage(String Package){String name = Package.substring(0, 19);;int sex = Integer.parseInt(Package.substring(20, 20));int age = Integer.parseInt(Package.substring(21, 23));/** insert into test values(name, sex, age);* select top 10 * from test where age < 16* select * from test where name = name odered by age*/}//连接MYSQL数据库并创建数据库和表public static void CreateDataBase() throws SQLException, ClassNotFoundException{String driver = "com.mysql.jdbc.Driver";Class.forName(driver);//载入mysql数据库，用Class.forName（"驱动名称"）进行载入//第二步，创建数据库连接，将数据库与当前文件连接起来。后面才干够对数据库进行操作//格式：String url = "jdbc:mysql://localhost:3306/Yuchengtech";//建立数据库连接地址Connection conn = DriverManager.getConnection(url, "root", "admin");//连接数据库Statement s = conn.createStatement();String SQL = "insert into test(name, sex,age) values(" +'"'+ "susheng" + '"' + ", 1, 25);";s.execute(SQL);}public static void main(String[] args) throws SQLException, ClassNotFoundException {//YuchengFacetoFace yff = new YuchengFacetoFace();//System.out.println(yff.makePackage("susheng", 0, 12));CreateDataBase();}}

二、js的代码答案

<html><head><script language="javascript">function parse(){var content = document.getElementById("package").value;var name = content.substring(1,20).trim();var sex = content.substring(20,21);var age = content.substring(21,24); document.getElementById("name").value = name;document.getElementById("sex").value = sex;document.getElementById("age").value = age;}</script></head><body><input id="package" type = "text"/><input type="button" οnclick="parse()"/><input id="name" type="text"/><input id="sex" type="text"/><input id="age" type="text"/></body></html>

css非常easy 有个background-image:url(a.jpg);

web的答案

package com.yuchengtech;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class TestServer extends HttpServlet {/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get.* * @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String Src = request.getParameter("package");YuchengFacetoFace yff = new YuchengFacetoFace();yff.parserPackage(Src);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post.* * @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String Src = request.getParameter("package");YuchengFacetoFace yff = new YuchengFacetoFace();yff.parserPackage(Src);}}

本内容不代表本网观点和政治立场，如有侵犯你的权益请联系我们处理。

网友评论

网友评论仅供其表达个人看法，并不表明网站立场。