[测试题交流] JavaEE 面试的一点分享

我是走流程考完入学考试报的面试，只有2天时间，由于本人大四事情特别多，没法好好的去复习Java基础，打算抱着侥幸的心理面试看看效果。面试是这样的，上来给2道编程题如下图

2道编程题共30分，时间50分钟。
不让查看参考任何资料。
第一题，由于

<div>Class.forName("com.mysql.jdbc.Driver");</div><div>String url = "jdbc:mysql://localhost:3306/test";</div>

复制代码

这中间的两个字符串记不得，直接到底身亡。
第二题，很简单，由于第一题的冲击波太大，影响了第二题的发挥，随机数竟然使用java.util.Random,直接面试失败。
接下来给出这两个面试题的答案：
1.

<div>package Test;</div><div>
</div><div>import java.sql.Connection;</div><div>import java.sql.DriverManager;</div><div>import java.sql.PreparedStatement;</div><div>import java.sql.ResultSet;</div><div>import java.sql.SQLException;</div><div>import java.util.ArrayList;</div><div>import java.util.Iterator;</div><div>import java.util.List;</div><div>
</div><div>class Student {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private String name;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private int age;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private int score;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public String getName() {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>return name;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public void setName(String name) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>this.name = name;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public int getAge() {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>return age;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public void setAge(int age) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>this.age = age;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public int getScore() {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>return score;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public void setScore(int score) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>this.score = score;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div>}</div><div>public class Test1 {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public static Connection getConnection() throws ClassNotFoundException, SQLException {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Class.forName("com.mysql.jdbc.Driver");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>String url = "jdbc:mysql://localhost:3306/test";</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>String user = "root";</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>String password = "123456";</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>return DriverManager.getConnection(url, user, password);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public static List<Student> getStudents() throws </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>ClassNotFoundException, SQLException {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>List<Student> list = new ArrayList<Student>();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>String sql = "select * from tb_stu";</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Connection conn = getConnection();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>PreparedStatement ps = conn.prepareStatement(sql);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>ResultSet rs = ps.executeQuery();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>while(rs.next()) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Student s = new Student();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>s.setName(rs.getString("name"));</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>s.setAge(rs.getInt("age"));</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>s.setScore(rs.getInt("score"));</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>list.add(s);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>return list;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public static void main(String[] args) throws ClassNotFoundException, SQLException {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>List<Student> list = getStudents();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//1.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>for(Student s : list) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println(s.getName()+","+s.getAge()+","+s.getScore());</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//2.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Iterator i = list.iterator();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>while(i.hasNext()) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Student s = (Student)i.next();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println(s.getName()+","+s.getAge()+","+s.getScore());</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div>}</div>

复制代码

2.

<div>package Test;</div><div>
</div><div>import java.util.Random;</div><div>import java.util.Scanner;</div><div>
</div><div>public class Test2 {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>public static void main(String[] args) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println("请输入一个字符串");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Scanner scan = new Scanner(System.in);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>String str1 = scan.nextLine();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println("请输入想要查找的字符");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>String str2 = scan.nextLine();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>for(int i=0; i < 4; i++) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>if(str1.contains(str2)) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println(str2+"出现的位置是："+str1.indexOf(str2)+" 次数："+ times(str1,str2));</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.exit(0);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>else {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println("请重新输入");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>str2 = scan.nextLine();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>char c = str1.charAt((int)(Math.random()*str1.length()));</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println("由于5次输入均错误，所以随机选择了一个字符" + c);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>System.out.println(c+"出现的位置是："+str1.indexOf(c)+" 次数："+ times(str1,c+""));</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>/**</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> * 一个字符ch在字符串str中出现的次数</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> * @param str</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> * @param ch</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> * @return</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> */</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private static int times(String str1, String str2) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>int sum = 0;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>char[] cha = str1.toCharArray();</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>for(int i=0; i<str1.length(); i++) {</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>if(cha[i] == str2.toCharArray()[0])</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>sum++;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>return sum;</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div>}</div>

复制代码

给我面试的是盖洪晓老师，老师说了，后面还有理论知识题20分。
每人有3次面试机会，12两次相等，第3次需要重新走流程。
面试内容涵盖：面向对象集合线程 IO 反射 jdbc mysql http（没有网络编程和GUI）
这次失败主要由于没有做好准备，下次我会准备好的，黑马，等我！

痴爱一生 · 痴爱一生

66666666666,赞一个

流离岁月 · 流离岁月

1024个赞

淹忆 · 淹忆

赞。。。。。。。。。。。

demon凯 · demon凯

点赞楼主加油

936994215

由于代码显示有问题，重新弄一下！

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
class Student {
private String name;
private int age;
private int score;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public int getScore() {
return score;
}
public void setScore(int score) {
this.score = score;
}
}
class DbUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "123456";
return DriverManager.getConnection(url, user, password);
}
}
public class Test1 {
public static List<Student> getStudents() throws
ClassNotFoundException, SQLException {
List<Student> list = new ArrayList<Student>();
String sql = "select * from tb_stu";
Connection conn = DbUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
Student s = new Student();
s.setName(rs.getString("name"));
s.setAge(rs.getInt("age"));
s.setScore(rs.getInt("score"));
list.add(s);
}
return list;
}
public static void main(String[] args) throws ClassNotFoundException, SQLException {
List<Student> list = getStudents();
//1.
for(Student s : list) {
System.out.println(s.getName()+","+s.getAge()+","+s.getScore());
}
//2.
Iterator i = list.iterator();
while(i.hasNext()) {
Student s = (Student)i.next();
System.out.println(s.getName()+","+s.getAge()+","+s.getScore());
}
}
}

复制代码

936994215

第二题代码：

import java.util.Scanner;
public class Test2 {
public static void main(String[] args) {
System.out.println("请输入一个字符串");
Scanner scan = new Scanner(System.in);
String str1 = scan.nextLine();
System.out.println("请输入想要查找的字符");
String str2 = scan.nextLine();
for(int i=0; i < 4; i++) {
if(str1.contains(str2)) {
System.out.println(str2+"出现的位置是："+str1.indexOf(str2)+" 次数："+ times(str1,str2));
System.exit(0);
}
else {
System.out.println("请重新输入");
str2 = scan.nextLine();
}
}
char c = str1.charAt((int)(Math.random()*str1.length()));
System.out.println("由于5次输入均错误，所以随机选择了一个字符" + c);
System.out.println(c+"出现的位置是："+str1.indexOf(c)+" 次数："+ times(str1,c+""));
}
/**
* 一个字符ch在字符串str中出现的次数
* @param str
* @param ch
* @return
*/
private static int times(String str1, String str2) {
int sum = 0;
char[] cha = str1.toCharArray();
for(int i=0; i<str1.length(); i++) {
if(cha[i] == str2.toCharArray()[0])
sum++;
}
return sum;
}
}

复制代码

bitwdh · bitwdh

面试怎么感觉好难得样子？

Jason.Wong · Jason.Wong

面试的编程题现场可以用eclipse写吗？还是用笔记本写~~（听别人说有手写~）

Ake丶 · Ake丶

最近也在复习中。共勉。黑马等我！！！！！

贼像样 · 贼像样

多谢楼主分享心得，祝成功

perfect_class · perfect_class

谢谢分享,感觉好难啊!

陈建 · 陈建

够详细啊，赞一个

新人—小明同学 · 新人—小明同学

论坛有你更精彩{:3_51:}

610980097

第二题不能使用Random? 这道题不让用Random吗?

936994215

610980097 发表于 2016-7-2 22:58
第二题不能使用Random? 这道题不让用Random吗?

用的Math.random和Random有点不一样

y506798278 · y506798278

还有JDBC的啊，先留个名

tyzf37 · tyzf37

赞楼主,下次加油，感谢分享

ASDZZZ · ASDZZZ

完全看不懂啊

雷雨天 · 雷雨天

我给你32个赞

帐号		自动登录	找回密码
密码			加入黑马

[测试题交流] JavaEE 面试的一点分享

31 个回复