getname.java

来自「使用java编写的一个学生选课系统」· Java 代码 · 共 31 行

package Srs;
import java.sql.*;

import Srs.LinkDatabase;
public class GetName {
	private LinkDatabase linkDatabase = new LinkDatabase();
	private Connection connection;
	private Statement statement;
	private String sql;
	private ResultSet resultSet;
	public String getName(String newId){
		try{
			sql = "select name"+" "+
					"from students"+" "+
					"where id ='"+newId+"';";
			connection = linkDatabase.getlink();
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			if(!resultSet.next()){
				return null;
			}
			else{
			return resultSet.getString("name");
			}
		}catch(SQLException e){
			e.printStackTrace();
			return null;
		}
	}
}