展开全部
看下面代码,具636f70793231313335323631343130323136353331333332623964体的数据需要你自己填入。package com.huawei.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
public class Demo
{
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Demo.queryName("select Student.name from Student where Student. score = 80");
}
public static List queryName(String sql) throws ClassNotFoundException, SQLException
{
List list = new ArrayList();
Class.forName("");
Connection con = DriverManager.getConnection("", "", "");
Statement stat = con.createStatement();
ResultSet rs = stat.executeQuery(sql);
while(rs.next())
{
String name = rs.getString("name");
list.add(name);
}
return list;
}
}
class Student
{
private String name;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}